Our orders are delivered strictly on time without delay 
We had the data model constructed for Garden Glory in A4. Now we need to convert it into
relational database design. There are two steps for this assignment:
1. List all the final entities or tables that you have for the database design. Show them in
structural format. We already had two entities from A4, and they are:
PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip)
and:
SERVICE (ServiceID, ServiceDate, Description, Amount, PropertyID)
Remember you might have more than six tables for database design. Why? You may
need to resolve the M:N relationships at this stage, and this adds additional intersection
tables.
2. With the entities in step 1, modify the E-R diagram you draw in A4 with Visio to turn it into
a E-R diagram for database design.
• Add appropriate attributes for each entity. Make assumptions if necessary
• Use identifying/non-identifying relationships as appropriate.
• Clearly show the PKs and FKs
• Clearly show the maximum and minimum cardinalities. Make assumptions if necessary
By doing this, you have also clearly shown the relationship (1:1, 1:M, or M:N)
