1 / 17

Database Fundamentals

Database Fundamentals. Objective 5.01: Understand database tables used in business. What is a Database ?. Database - a tool used to organize, store, retrieve, and communicate (report on) groups of related information. Examples of Databases. Business stock inventory

teigra
Download Presentation

Database Fundamentals

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. DatabaseFundamentals Objective 5.01: Understand database tables used in business

  2. What is a Database? • Database - a tool used to organize, store, retrieve, and communicate (report on) groups of related information.

  3. Examples of Databases • Business stock inventory • Barcode scanner keeps inventory in database • Fingerprint database • iTunes • Personal address book • Student data (NCWISE), such as Student ID #’s • Telephone book • Online library card catalog • Media Center information • Encyclopedias • Dictionaries • eBay and other online businesses • Inventory • Keep track of customers, products, vendors, pay pal accounts

  4. Why do businesses use databases? • A database is a tool used by businesses to manage the huge amount of data required to run the business. • keep track of employee information, customers, products, and prices of products. • information can be easily and efficiently managed and shared by database software.

  5. What makes a Database? • Databasesconsist of 4 main Objects: • Tables - store data in rows and columns • Queries - retrieve and process data • Forms- control data entry and data views • A form is a customized manner of inputting data into a database or presenting data on a screen. • Reports - summarize and print data

  6. Tables • Tablesstore data • the essential building blocks • Tables- used to group and organize information within a database. • All databases contain at least one table. • Eachdatabaseusually consists of one or more tables.

  7. Tables • Databases should have a separate table for every major subject • employee records or customer orders. • Data should not be duplicated in multiple tables.

  8. Tables • 1. Table – arrangement of columns and rows • Made up of • Rowscalled Records • Columnscalled Fields

  9. Table Components: Entry, Field, Record 2. Entry - a single piece of data in a database table. • Data is typed into a Field as an entry 3. Field - a grouping or category of similar information • represented by a COLUMN, comprised of entries. 4. Recordis a complete description of all of the fields related to one item in a table.

  10. Tables 3. A Fieldis a grouping or category of similar information contained in a table. • A Field is represented by a COLUMN. • It is comprised of entries. • A Field is a unique identifier for a category of information. • It is one item or bit of information in a record.

  11. Tables 4. Record - a combination of fields related to one item in a table. • Everything on one row is a record.

  12. Database Tables:The Big Picture • Table • Entries • Field 4. Record 3. FIELDS (columns) 4. RECORDS (rows) 2. ENTRIES(cells) To calculate the number of entries in a database--multiply the number of fields by the number of records. Ex. 5 fields(columns)*26 rows (records) = 130 entries in this database.

  13. What is the answer? • Name • Birth date • Social Security No. • Street • City • State • Zip • Phone Each item on the left is classified as a/an: • Table • Record • Field • Entry

  14. What is the answer? • Susan Almond • 10/22/1985 • 245-88-9845 • 31 Bessemer St. • Greensboro • NC • 25233 • 336-585-5646 Each item on the left is classified as a/an: • Table • Record • Field • Entry

  15. What is the answer? • Susan Almond • 10/22/1985 • 245-88-9845 • 31 Bessemer St. • Greensboro • NC • 25233 • 336-585-5646 All of the information about Susan Almond is classified as a/an: • Table • Record • Field • Entry

  16. What is the answer? • Information about multiple employees is classified as a/an: • Table • Record • Field • Entry

  17. Susan’s Record One record is displayed from the Employee Table above. The table contains 8 fields.

More Related