1 / 13

Data Handling

Data Handling. This lesson will cover:. The importance of storing and processing data for modern organizations. The benefits of electronic databases over paper-based databases and spreadsheets . Different types of databases and the advantages they bring to organizations. Why do we store data?.

halesm
Download Presentation

Data Handling

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Handling

  2. This lesson will cover: The importance of storing and processing data for modern organizations. The benefits of electronic databases over paper-based databases and spreadsheets . Different types of databases and the advantages they bring to organizations.

  3. Why do we store data? Storing and using data is an essential part of running a modern business or organization. Why do organizations need to keep records?

  4. Commercial organizations Commercial organizations store and manipulate data for sales, ordering, finance and producing models and forecasts. Spreadsheets can be used but they have some limitations: • can be difficult to generate very complex search queries • complicated to allow multiple users access to the same data • don’t allow for sophisticated validation criteria to prevent erroneous entries • more likely to produce duplicate or redundant records. Databases are very good for working with lots of data.

  5. What are databases? A database is any organized collection of related data and information. For example, your personal address book or telephone book is a database. A database is made up of tables,which contain records sortedinto fields. Organizations that use databases are constantly retrieving and storing records about their staff, their customers and their finances.

  6. Electronic vs. paper databases

  7. Databases vs. spreadsheets

  8. Using databases Organizations that use databases include: Schools Businesses Hospitals Libraries Police What databases might have your name in their records?

  9. Using databases

  10. Internet sales

  11. Flat file database A flat file database is a database which has only one table, which is not linked to any other table. It is a relatively simple database. An address book is an example of a flat file database. Spreadsheet software can be used to create flat file databases. In contrast, relational databases use multiple tables to store information. They can then relate records on one table to records on another table, to produce a third table which displays this new data.

  12. Relational databases

  13. True or false?

More Related