Reference no: EM132218800

Assignment - Musica Case Study

Tasks -

1. Create an MS Word document named "Your Name - Your Student Number - Musica.docx"

2. Create an ER Diagram from the above scenario:

a) Create this ER Diagram with Lucidchart or another piece of software. Hand-drawn diagrams will not be accepted.

b) Only use "crow's foot notation".

c) Mark cardinality and resolve any relationship problems that are revealed.

d) Mark existence, likely primary keys and likely foreign keys.

e) Be sure to include your name and student number within the drawing.

f) Include all attribute fields that you believe would be useful.

g) Insert that ER Diagram into your Word document. You could do this by taking a screenshot of the diagram and pasting it in, or by exporting the diagram as an image and the inserting it.

3. Draw dependency diagram to use the 1NF, 2NF and 3NF.

Attachment:- Case Study.rar