1 / 20

Databases

Databases. 23 November 2010. Transformation. Data vs. Information. Data – a collection of facts made up of text, numbers and dates: Murray 35000 7/18/86 Information - the meaning given to data in the way it is interpreted:

breanna-mccall
Download Presentation

Databases

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. Databases 23 November 2010

  2. Transformation

  3. Data vs. Information • Data – a collection of facts made up of text, numbers and dates:Murray 35000 7/18/86 • Information - the meaning given to data in the way it is interpreted: Mr. Murray is a sales person whose annual salary is $35,000 and whose hire date is July 18, 1986.

  4. Data Unprocessed Information Organized and communicated Knowledge Evaluated and usable Differences

  5. What is a database? storage space for information

  6. Non-electronic Examples A filing cabinet, an address book, a telephone directory, a timetable, etc.

  7. Electronic Database Systems: Then

  8. Now From Friendster.com on-line tour

  9. Databases you may use

  10. Benefits • Making information useful • Making information easily accessible • Integrating information

  11. Name: Barry HarrisCollege: BusinessTel: 962-5555 Basic Database Concepts • Field Name: Barry Harris • A single item of data common to all records • Record Name: Barry HarrisCollege: BusinessTel: 962-5555 • A collection of data about an individual item • Table • A set of related records

  12. Fields Basic elements of content

  13. An Example of a Table Fields Records

  14. Primary Keys & Foreign Keys To ensure that each record is unique in each table, we can set one field to be a Primary Key field. A Primary Key is a field that that will contain no duplicates and no blank values. Foreign Keys link to data in other tables

  15. A Sample Relational Database

  16. Other parts of a database • Tables • Forms • Queries • Reports

  17. Forms • A friendlier view of the database • Used for data input, display and printing

  18. Queries • A means of asking questions (querying) of your data • Can look across tables

  19. Reports • If the query is a question... ...then the report is its answer • Tailored to the needs of the user • Allows you to group and summarize data • Cannot edit

  20. Databases in Spreadsheets • Can be done • Example • BUT other tools exist to make it easier • User not need to understand as much • Handles routine operations

More Related