To do this homework, you need to know how to use MS Visio to draw the related diagrams.
I. Suppose you have the ERM shown in the following Figure. How would you convert this model into an ERM that displays only 1:M relationships? (Make sure you create the revised ERM) (30 pts)
( use Microsoft Visio to draw the ERM and Copy/Paste the diagram to this document, otherwise half of the credits will be deducted)
Solution:
II. Use the database shown below to answer the questions:
1. Identify the primary keys: (10 pts)
Solution:
2. Identify the foreign keys: ( 10 pts)
Solution:
3. Create the ERM:
(Hints: a typical ERM looks like:
)
( use Microsoft Visio to draw the ERM and Copy/Paste the diagram to this document, otherwise half of the credits will be deducted) (30 pts)
Solution:
4. Create the relational diagram to show the relationship between DIRECTOR and PLAY entities. ( Hints: a typical relational diagram looks like
)
(use Microsoft Visio to draw the ERM and Copy/Paste the diagram to this document, otherwise half of the credits will be deducted) (20 pts)
Solution: