Understanding the Database Tables Used in Business
This presentation, titled "Understanding the Database Tables Used in Business," covers the fundamentals of database tables and their importance in business operations. The second slide emphasizes that a database is a tool for organizing
- Uploaded on | 3 Views
- brittanyhall
About Understanding the Database Tables Used in Business
PowerPoint presentation about 'Understanding the Database Tables Used in Business'. This presentation describes the topic on This presentation, titled "Understanding the Database Tables Used in Business," covers the fundamentals of database tables and their importance in business operations. The second slide emphasizes that a database is a tool for organizing. The key topics included in this slideshow are . Download this presentation absolutely free.
Presentation Transcript
Slide1Understand database tables used in business. Understand database tables used in business. D D a a t t a a b b a a s s e e F F u u n n d d a a m m e e n n t t a a l l s s
Slide25.01 Understand database tables used in businessSlide 2 ► A ► A d d a a t t a a b b a a s s e e i i s s a a t t o o o o l l f f o o r r o o r r g g a a n n i i z z i i n n g g , , s s t t o o r r i i n n g g , , r r e e t t r r i i e e v v i i n n g g , , a a n n d d c c o o m m m m u u n n i i c c a a t t i i n n g g g g r r o o u u p p s s o o f f i i n n f f o o r r m m a a t t i i o o n n t t h h a a t t h h a a v v e e s s i i m m i i l l a a r r c c h h a a r r a a c c t t e e r r i i s s t t i i c c s s What is a database? What is a database?
Slide35.01 Understand database tables used in businessSlide 3 Examples of Business Databases Examples of Business Databases ► Telephone book ► Telephone book ► Student data ► Student data ► Music ► Music ► Fingerprint database ► Fingerprint database ► Dictionaries ► Dictionaries ► Customer data ► Customer data ► Real estate listings ► Real estate listings MLS listings online MLS listings online ► Hospital/patient data ► Hospital/patient data ► Inventory ► Inventory Barcode scanner keeps inventory in database Barcode scanner keeps inventory in database
Slide45.01 Understand database tables used in businessSlide 4 What makes a database? What makes a database? Databases consist of four objects: Databases consist of four objects: 1. Tables 1. Tables store data in rows and columns* 2. Queries 2. Queries retrieve and process data 3. Forms 3. Forms control data entry and data views Customized manner of inputting data into a database or presenting data on a screen 4. Reports 4. Reports summarize and print data *In this objective, our focus is on tables
Slide55.01 Understand database tables used in businessSlide 5 Tables: the Building Blocks of all Databases Tables: the Building Blocks of all Databases • 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 .
Slide65.01 Understand database tables used in businessSlide 6 Components of a Database Table Components of a Database Table ► Record – A group of related fields of information. Everything on one row is a record ► 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 ► 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. ► Entry – Data typed into a field. Made up of characters. Example: John Doe is an entry in the name field. Also known as data.
Slide75.01 Understand database tables used in businessSlide 7 Database Tables: The Big Picture 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 1. Records 3. Entry 2. Fields
Slide8DiscussionDiscussion ► Name ► Name ► Birth date ► Birth date ► Social Security No. ► Social Security No. ► Street ► Street ► City ► City ► State ► State ► Zip ► Zip ► Phone ► Phone Each item on the left is classified as a/an: Each item on the left is classified as a/an: a) Table a) Table b) Record b) Record c) Field c) Field d) Entry d) Entry 5.01 Understand database tables used in business Slide 8
Slide9DiscussionDiscussion ► Susan Almond ► Susan Almond ► 10/22/1985 ► 10/22/1985 ► 245-88-9845 ► 245-88-9845 ► 31 Bessemer St. ► 31 Bessemer St. ► Greensboro ► Greensboro ► NC ► NC ► 25233 ► 25233 ► 336-585-5646 ► 336-585-5646 Each item on the left is classified as a/an: Each item on the left is classified as a/an: a) Table a) Table b) Record b) Record c) Field c) Field d) Entry d) Entry 5.01 Understand database tables used in business Slide 9
Slide10DiscussionDiscussion ► Susan Almond ► Susan Almond ► 10/22/1985 ► 10/22/1985 ► 245-88-9845 ► 245-88-9845 ► 31 Bessemer St. ► 31 Bessemer St. ► Greensboro ► Greensboro ► NC ► NC ► 25233 ► 25233 ► 336-585-5646 ► 336-585-5646 All of the information about Susan Almond is classified as a/an: All of the information about Susan Almond is classified as a/an: a) Table a) Table b) Record b) Record c) Field c) Field d) Entry d) Entry 5.01 Understand database tables used in business Slide 10
Slide11DiscussionDiscussion ► Information about multiple employees is classified as a/an: ► Information about multiple employees is classified as a/an: a) Table a) Table b) Record b) Record c) Field c) Field d) Entry d) Entry 5.01 Understand database tables used in business Slide 11
Slide12Susan’s Record Susan’s Record 5.01 Understand database tables used in business Slide 12 Name Bday SS Street City St Zip Phone Almond, Susan 10/22/1 985 245-88- 9845 31 Bessemer St Greensboro NC 25233 336-585- 5646 One record is displayed from the Employee Table above. The table contains 8 fields.
Slide13Test your knowledge Test your knowledge ► Using the last page of the Database Fundamentals graphic organizer, classify each database component. ► Using the last page of the Database Fundamentals graphic organizer, classify each database component. 5.01 Understand database tables used in business Slide 13