Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a relational schema of the table(s) in 2NF. Remember with a relational schema to underline the primary key, indicate it underneath the table/attribute lists,
Create a relational schema of the table(s) in 2NF. Remember with a relational schema to underline the primary key, indicate it underneath the table/attribute lists, and also list the foreign key and the table it references.
FIGURE 6.6 THE COMPLETED DATABASE (CONTINUED) Table name: EMPLOYEE Database name: Ch06 ConstructCo EMP NUM EMP LNAME EMP_FNAME EMP_INITIAL EMP_HIREDATE JOB CODE Table name: EMPLOYEE EMP NUM EMP LNAME EMP FNAME EMP INITIAL EMP HIREDATE JOB CODE 101 102 103 104 105 106 107 108 109 110 08-Now00 502 2-Jul-89 501 01-Dec-97 503 15-Nov88 501 01-Feb-94 502 22-Jun-05 500 0-Oct-94 500 22-Aug-89 501 18-Jul-99 501 11-Dec-96 505 04-Apr-89 506 23-Oct-95 507 15-Nov-94 508 20-Aug-91 508 25-Jan-90 501 05-Mar-95 510 19-Jun-94 509 04-Jan-06 510 John David June Senion Arbough Ramoras Johnson Smithfield Alonzo Washington Ralph Smith Olenko Wabash Smithson Joenbrood Jones Bawan Pratt Williamson Angie Frommer Alice William Maria 112 113 114 115 116 Gerald Geoff Darlene Delbert Annelise Travis Gerald 118 JamesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started