Given the sample records in the CHARTER table shown, do the following:

 Table - CHARTER

Attribute Name	Sample Value	Sample Value	Sample Value	Sample Value
CHAR_TRIP	10232	10233	10234	10235
CHAR_DATE	15-Jan-2022	15-Jan-2022	16-Jan-2022	17-Jan-2022
CHAR_CITY	STL	MIA	TYS	ATL
CHAR_MILES	580	1,290	524	768
CUST_NUM	784	231	544	784
CUST_LNAME	Brown	Hanson	Bryana	Brown
CHAR_PAX	5	12	2	5
CHAR_CARGO	235 lbs.	18,940 lbs.	348 lbs.	155 lbs.
PILOT	Melton	Chen	Henderson	Melton
COPILOT		Henderson	Melton
FLT_ENGINEER		O’Shaski
LOAD_MASTER		Benkasi
AC_NUMBER	1234Q	3456Y	1234Q	2256W
MODEL_CODE	PA31-350	CV-580	PA31-350	PA31-350
MODEL_SEATS	10	38	10	10
MODEL_CHG_MILE	$2.79	$23.36	$2.79	$2.79

In your group, you will need to submit the following for the above table:

1. Write the relational schema and draw the dependency diagram for the table structure. Make sure that you label all dependencies. Draw the Dependency Diagram that is in 3NF for each relation. For each relation show the level of Normalisation achieved, and for any not in Third Normal Form, explain why. Discuss PK and FK for each relation.
   
   
2.  Relational data structures (Data Dictionary) that translates the above ER diagram, which includes :
3. 
   
   1. relation names,
   2. attribute names and field types
   3. primary keys identified
4. Team contribution statement

Answer rating: 100% (QA)

To create a relational schema and dependency diagram for the given CHARTER table we first need to id... View the full answer