Database Fundamentals

Database Fundamentals

• 1.
  Objective 5.01: Understand database tables used in business. Database Fundamentals
• 2.
  A database isa tool for organizing, storing, retrieving, and communicating groups of information that have similar characteristics What is a database? 5.01 Understand database tables used in business Slide
• 3.
  Examples of Business Databases Telephone book Student data Music Fingerprint database Dictionaries Customer data Real estate listings MLS listings online Hospital/patient data Inventory Barcode scanner keeps inventory in database 5.01 Understand database tables used in business Slide
• 4.
  What makes adatabase? 5.01 Understand database tables used in business Slide Databases consist of four objects: Tables store data in rows and columns* Queries retrieve and process data Forms control data entry and data views Customized manner of inputting data into a database or presenting data on a screen Reports summarize and print data *In this objective, our focus is on tables
• 5.
  Tables: the BuildingBlocks of all Databases 5.01 Understand database tables used in business Slide Tables organize data Each database consists of one or more tables Tables store data, so they’re essential building blocks of any database. All databases contain at least one table A database should have a separate table for every major subject, such as for employee records or customer orders. Data should not be duplicated in multiple tables. Tables contain R ows called R ecords and Columns called Fields .
• 6.
  Components of aDatabase Table Record – A group of related fields of information. Everything on one row is a record Field – One item or bit of information in a record; represented by a COLUMN . Comprised of entries Entry – Data typed into a field. Made up of characters. Example: John Doe is an entry in the name field. Also known as data. 5.01 Understand database tables used in business Slide
• 7.
  5.01 Understand databasetables used in business Slide Database Tables: The Big Picture To calculate the number of entries in a database multiply the number of fields by the number of records. Ex. 5*26= 130 entries in this database. 3. Cells - ENTRIES 1. Rows – RECORDS 2. Columns - FIELDS Records Entry Fields
• 8.
  Discussion Name Birthdate Social Security No. Street City State Zip Phone Each item on the left is classified as a/an: Table Record Field Entry 5.01 Understand database tables used in business Slide
• 9.
  Discussion Susan Almond10/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 5.01 Understand database tables used in business Slide
• 10.
  Discussion Susan Almond10/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 5.01 Understand database tables used in business Slide
• 11.
  Discussion Information aboutmultiple employees is classified as a/an: Table Record Field Entry 5.01 Understand database tables used in business Slide
• 12.
  Susan’s Record 5.01Understand database tables used in business Slide One record is displayed from the Employee Table above. The table contains 8 fields. Name Bday SS Street City St Zip Phone Almond, Susan 10/22/1985 245-88-9845 31 Bessemer St Greensboro NC 25233 336-585-5646
• 13.
  Test your knowledgeUsing the last page of the Database Fundamentals graphic organizer, classify each database component. 5.01 Understand database tables used in business Slide