Question: Decompose the dependency diagram in Problem to create table structures that are all in 3NF and write the relational schema. Make sure that you
Decompose the dependency diagram in Problem to create table structures that are all in 3NF and write the relational schema. Make sure that you label all dependencies. The normalized dependency diagram is shown in Figure 3.3. (Note the addition of MOD_CODE in the AIRCRAFT table to serve as the AIRCRAFT table's FK to MODEL.) CHARTER table CHAR_TRIP CHAR_DATE CHAR_CITY CHAR_PAX CHAR_MILES CUST_NUMBER PILOT COPILOT FLT ENGINEER LOAD_MASTER CUSTOMER table Continued.... CUST_NUMBER CUST_LNAME AIRCRAFT table AC_NUM MOD_CODE MODEL table MOD_CODE MOD_SEATS MOD CHG_MILE
Step by Step Solution
3.39 Rating (152 Votes )
There are 3 Steps involved in it
Based on the provided relational database schema I can help you write the SQL queries for your ... View full answer
Get step-by-step solutions from verified subject matter experts
