Get fast, custom help from our academic experts, any time of day.

Place your order now for a similar assignment and have exceptional work written by our team of experts.

Secure Original On Schedule

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:

Get fast, custom help from our academic experts, any time of day.

Secure Original On Schedule