Decompose the dependency diagram in Problem to create table structures that are all in 3NF and...

 

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

Based on the provided relational database schema I can help you write the SQL queries for your ... View the full answer