Question: Given the following description, design an E / R diagram in Chen notation Description: A vinyl record collection database stores albums, information on releases of

Given the following description, design an E/R diagram in Chen notation
Description: A vinyl record collection database stores albums, information on releases of each album, and albums in collectors collections .
An album has a title, year, and length. It can be uniquely identified by an additional albumID attribute.
An albums release(s) can be identified uniquely given the release year and the album ID. Albums can have multiple releases. Other attributes for a release are the number of LPs (record discs) and a Boolean indicating true if remastered (false if not a remaster).
For example, Sgt. Peppers Lonely Hearts Club band has an initial release in 1967 and a remastered release in 1983. Both were released on one LP.
Collectors collect album releases. Each collector has a unique collectorID, name, and address. A collection can include zero to many released albums. Assume collectors have no duplicate album releases in their collection.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!