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 conceptsthat 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 tomodel 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 musiccollection consists of various albums and each album is made by the musician. Every musiciathat records at Coke Studio has a CNIC, a name, an address, and a phone number. A musicianmakes one or more albums that further contain one or more tracks. Each album has exactly ormusician who acts as its producer. A musician may produce several albums, of course. Eachalbumthat is recorded on the Coke Studio label has a title, a copyright date, a format, and an albumidentifier. Each track belongs to exactly one album which has a time length, measured inseconds.Each track recorded at Coke Studio has a title and an author. Every instrument used in tracks aCoke Studio has a name, for instance, guitar, synthesizer, and flute. Each musician may playseveral instruments, and several musicians may play a given instrument.

We need to make ER diagram using above statement. See below step diagram.

Answered: Question:1. Design a conceptual schema…

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 musicia
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 or
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 a
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 3 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