draw a relational database design. There are two steps: 1. List all the final entities or tables that you have for the database design. Show them in a 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).