Question

Attribute	Sample Value	Sample Value	Sample Value	Sample Value
pirate_num	11	22	43	54
pirate_lname	James	Connie	Arthur	Mark
pirate_dob	1823-03-25	1869-06-04	1910-11-14	1916-12-17
ship_num	38	104	89	89
ship_name	The Count's Death	The Queen's Maiden	Lady Jane's Revenge	Lady Jane's Revenge
ship_type	lugger	frigate	galleon	galleon
ship_size	17	20	28	28
rank_num	317	317	350	317
rank_desc	Captain	Captain	First Mate	Captain
salary	$900	$900	$600	$900

1. Given the structure in the table, write the relational schema and draw the dependency diagram. Label all transitive and/or partial dependencies

2. Draw the dependency diagrams that are in 3NF. (Make sure the new dependency diagrams contain attributes that meet proper design criteria)

3. Draw the relational diagram.

Answer 1

Relation Schema for the structure given in the table can be written as

Dependency Diagram:

2] 3NF Dependency Diagram:

3NF => Relationship is said to be in 3NF when it is in 2NF and no transitive dependency.

4] Relationship Diagram:

Relationship Diagram shows how entities are related to each other in a type of flow chart.