Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question (1) (15+15 30 points) (a) (15 points) You need to draw an ER diagram that is derived from the following requirements . The collection

image text in transcribed
Question (1) (15+15 30 points) (a) (15 points) You need to draw an ER diagram that is derived from the following requirements . The collection consists of albums. . An album is made by exactly one artist. . An artist makes one or more albums. . An album contains one or more tracks . Artists, albums, and tracks each have a name. . Each track is on exactly one album. Each track has a time length, measured in seconds. . When a track is played, the date and time the playback began (to the nearest second) should be recorded; this is used for reporting when a track was last played, as well as the number of times music by an artist, from an album, or a track has been played. There's no requirement to capture composers, group members or sidemen, recording data or location, the source media, or any other details of artists, albums, or tracks. (b) in orel that you would implement above ERD and requirements into MyGQL (15 points) In order that you would implement above ERD and requirements into MySQL database (tables), you need to identify appropriate value of primary key foreign key, and the value of cardinalities. Also, Write MySQL code for the ER diagram (part-a) and insert at least five records in each table

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Expert Oracle Database Architecture

Authors: Thomas Kyte, Darl Kuhn

3rd Edition

1430262990, 9781430262992

More Books

Students also viewed these Databases questions

Question

Describe how to measure the quality of work life.

Answered: 1 week ago

Question

What attracts you about this role?

Answered: 1 week ago