1. Using the types of entities found in the Alexamara Marina Group database (marinas, owners, boat slips, categories, and service requests), create an example of a table that is in first normal form but not in second normal form and an example of a table that is in second normal form but not in third normal form. In each case, justify your answer and show how to convert to the higher forms.
2. Determine the functional dependencies that exist in the following table, and then convert this table to an equivalent collection of tables that are in third normal form:
Marina (MarinaNum, Name, (SlipNum, Length, RentalFee, BoatName) )
3. Determine the functional dependencies that exist in the following table, and then convert this table to an equivalent collection of tables that are in third normal form:
MarinaSlip (SlipID, MarinaNum, SlipNum, Length, RentalFee, BoatName, BoatType, OwnerNum, LastName, FirstName)