Application 1 Data DBMS Application 2 Application 3
Application 1 Data DBMS Application 2 Application 3 DB User Novice User
Payroll Data DBMS IT Depart ment Payroll Clerk General Ledger Business Manager Accounts Payable AP Clerk
User 1 view User 3 view User 2 view Conceptual Schema Users perception of the data Internal Schema How is data stored Data
Database Table 2 Control Table 1 Master Table 3 Transaction
Database Table 2 Schema States (Abbreviation, Description) Table 2 Control Table 1 Schema Person (Id, Last, First, Middle, State, DOB) Table 1 Master Table 3 Schema Classes(Id, Subject, Number, Grade) Table 3 Transaction
Database State Control Student Master 123456 Molly Smith Jane VA 10/04/1995 2364598 Taylor Jones R MD 09/30/1994 55684 Mark Twain E NJ 10/25/1992 Course Transaction
Database - terms State Control VA Virginia MD Maryland NJ New Jersy Course Transaction 123456 CS 474 A 123456 WRTC 250 B+ 55684 CS 139 A 123456 Molly Smith Jane VA 10/04/1995 2364598 Taylor Jones R MD 09/30/1994 55684 Mark Twain E NJ 10/25/1992 Student Master
Database - terms State Control VA Virginia MD Maryland NJ New Jersy Course Transaction 123456 CS 474 A 123456 WRTC 250 B+ 55684 CS 139 A 123456 Molly Smith Jane VA 10/04/1995 2364598 Taylor Jones R MD 09/30/1994 55684 Mark Twain E NJ 10/25/1992 Student Master
- Slides: 8