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 ER 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 releases 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 and a remastered release in 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
