Instructions: The following functional dependencies are to be drawn using Draw.io. Identify all functional dependencies, primary keys, and hidden dependencies arrows are important. Make sure all work is clear and easy to read. Professional quality is expected. Use the methods shown in class for drawing both the dependency diagrams and the logical database schema. full functional dependency arrows are drawn above the diagram (what you start with) hidden dependency arrows are drawn below the diagram Copy and paste each complete diagram into a Word doc. Then save the doc as a .pdf file for submission.

3. Boat Registration Normalize the following relation: Boatia st Botame BoatMake Boat Model Boatength Owner Owner Address CustName Owne Phone CharterDate Amount a) Identify all functional dependencies and label them. b) Improve the relation to 2NF. Show the new FDs and all dependency arrows. Identify the primary keys. c) Improve the relations to 3NF. Show the new FDs and all dependency arrows. Identify the primary keys. d) Draw the relational schema for the final database table structure. Name each relation and identify all primary and foreign keys