Draw the Crow's Foot ERD to reflect the adequately decomposed dependency diagrams you created in Q2....

 

Transcribed Image Text:

Draw the Crow's Foot ERD to reflect the adequately decomposed dependency diagrams you created in Q2. Make sure that the ERD yields a database that can track all of the data shown. Show all entities, relationships, connectivities, optionalities, and cardinalities. The initial Crow's Foot ERD is shown in Figure MODEL PK MOD CODE MOD_SEATS MOD_CHO_MLE CUSTOMER PK CUST NUM CUST_LNAME 4 1 18 destribes 116 K 11 1 18 13 T 1 AIRCRAFT PK AC NUMBER FK1 MOD CODE ed in CHARTER CHAR TRIP PK FK1 CUST_NUM FK2 AC NUMBER CHAR_DATE CHAR_CITY CHAR_MILES CHAR PAX CHAR CARGO **** PILOT COPILOT ***** FLT ENGINEER LOAD MASTER -- Draw the Crow's Foot ERD to reflect the adequately decomposed dependency diagrams you created in Q2. Make sure that the ERD yields a database that can track all of the data shown. Show all entities, relationships, connectivities, optionalities, and cardinalities. The initial Crow's Foot ERD is shown in Figure MODEL PK MOD CODE MOD_SEATS MOD_CHO_MLE CUSTOMER PK CUST NUM CUST_LNAME 4 1 18 destribes 116 K 11 1 18 13 T 1 AIRCRAFT PK AC NUMBER FK1 MOD CODE ed in CHARTER CHAR TRIP PK FK1 CUST_NUM FK2 AC NUMBER CHAR_DATE CHAR_CITY CHAR_MILES CHAR PAX CHAR CARGO **** PILOT COPILOT ***** FLT ENGINEER LOAD MASTER --