Data

1. Application A DBMS Application B Data Application C Exhibit C-1 Database Architecture

2. COURSE RECORD Course Record Course Section Teacher Room Time Acc 1 Calvin 340 MW 1pm STUDENT RECORD Student # Last Name First Name Major Grade Student Record 12345 Smith Bob History B 23456 Sanders Shelly Math A 34567 Samson Jennifer CS C COURSE RECORD CS 1 Hobbes 205 TTh 2pm 12345 Smith Bob History B 45678 Fisher Mary CS A- 56789 Lincoln Perry Math A Exhibit C-2 Sample Hierarchical Structure

3. FINANCIAL STATEMENTS Assets Liabilities Equity Current assets Current liabilities Revenue Property, plant, and equipment Long-term liabilities Expenses Exhibit C-3 Accounting Data in a Hierarchical Structure

4. Name Telephone Number Maureen Rodriguez 485-5215 Steve Anderson 268-9615 Cheryl Gibbs 377-3216 Lyn Hoggan 226-5476 Scott Kirkham 321-9512 Karrie Eaquinto 462-6387 Jim Stice 373-6733 Exhibit C-4 A Sample Relational Table

5. CUSTOMER SALE Name Telephone Balance Invoice # Date Customer Nicol 123-4567 123,456 213 01Sep91 Nicol Benjamin 852-7412 365,412 214 01Sep91 Charisse Tate 951-3578 214,569 215 02Sep91 Benjamin Charisse 357-4563 456,321 216 02Sep91 Tate Marty 632-1587 124,682 217 03Sep91 Marty 218 03Sep91 Sariah Sariah 145-9687 975,632 219 04Sep91 McKell McKell 875-6891 112,002 PRODUCT PRODUCT-SALE Item # Description Price Cost Invoice # Item # Qty 213 1 2 1 Rocket 215 100 213 2 1 2 Violin 250 75 215 2 1 3 Bat 35 22 216 4 5 217 3 2 4 Doll 56 12 218 4 1 Exhibit C-5 Examples of Relational Tables

6. File Database Record #1 Record #2 Record #3 Fields Record Layout Sale # Register # Customer # Employee # Exhibit C-6 File Structure Relationships