The following assignment is to be drawn using Gliffy. Identify and label all functional dependencies and primary keys in each FD diagram. Label all keys correctly in the schema.

Normalize the following relation to 3^rd normal form. Identify & draw the complete FDs in 1^st, 2^nd, and 3^rd normal form. Don't forget the schema!

Application Summary: clients rent properties from their owners for a determined amount of time. This is the entity taken from the ERD, which shows the client who rented the property (along with other info about the rental that must be recorded). Primary keys for the entity are identified on the diagram below. (Do not add or delete any attributes or keys).

CName Clients Last Name PAddress propertys address OName owners name OPhone owners phone RentStartDate when client moves in RentEndDate when client moves out (not predetermined) RentAmt the value that the property is rented

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. Do not draw over-top the dependency lines; color-code lines (or change the line type) to make them easy to follow. After completing the diagrams, answer all questions and upload your diagrams.