create a database model consisting of 1) a summary of the relationships between the entities with a chart showing relationship(parent, child), cardinality

2) a crow's foot ER diagram for the design using Power Architect.