Question:1. Design a conceptual schema through ER diagrams for all the given scenarios. It is necessary to specify all entities, attributes, constraints, relationships and all the concepts that you have studied in Chapter 03. Mention the diagramming software that you have used for the assignment. If you had to make assumptions concerning the requirements, state them clearly. Mention constraints (business rules) apparent from the requirements that you are unable to model via your ERD. Statement: The Coke Studio music company wants to efficiently manage the record of their music library. They want to store and manage their music collection (e.g., MP3, CD, or vinyl). The music collection consists of various albums and each album is made by the musician. Every musician that records at Coke Studio has a CNIC, a name, an address, and a phone number. A musician makes one or more albums that further contain one or more tracks. Each album has exactly one musician who acts as its producer. A musician may produce several albums, of course. Each album that is recorded on the Coke Studio label has a title, a copyright date, a format, and an album identifier. Each track belongs to exactly one album which has a time length, measured in seconds. Each track recorded at Coke Studio has a title and an author. Every instrument used in tracks at Coke Studio has a name, for instance, guitar, synthesizer, and flute. Each musician may play several instruments, and several musicians may play a given instrument.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Question:1. Design a conceptual schema through ER diagrams for all the given scenarios.

It is necessary to specify all entities, attributes, constraints, relationships and all the concepts

that you have studied in Chapter 03.

Mention the diagramming software that you have used for the assignment.
If you had to make assumptions concerning the requirements, state them clearly.
Mention constraints (business rules) apparent from the requirements that you are unable to

model via your ERD.

Statement:

The Coke Studio music company wants to efficiently manage the record of their music library.

They want to store and manage their music collection (e.g., MP3, CD, or vinyl). The music

collection consists of various albums and each album is made by the musician. Every musician

that records at Coke Studio has a CNIC, a name, an address, and a phone number. A musician

makes one or more albums that further contain one or more tracks. Each album has exactly one

musician who acts as its producer. A musician may produce several albums, of course. Each album

that is recorded on the Coke Studio label has a title, a copyright date, a format, and an album

identifier. Each track belongs to exactly one album which has a time length, measured in seconds.

Each track recorded at Coke Studio has a title and an author. Every instrument used in tracks at

Coke Studio has a name, for instance, guitar, synthesizer, and flute. Each musician may play

several instruments, and several musicians may play a given instrument.

Expert Solution

Step by step

Solved in 4 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions