Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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.

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.

Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
9th Edition
ISBN:9781337669405
Author:FARRELL
Publisher:FARRELL
Chapter7: File Handling And Applications
Section: Chapter Questions
Problem 6PE
See similar textbooks
icon
Related questions
Question

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

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

that you have studied in Chapter 03.

  1. Mention the diagramming software that you have used for the assignment.
  2. If you had to make assumptions concerning the requirements, state them clearly.
  3. 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.
Transcribed Image Text: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
steps

Step by step

Solved in 3 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Enhanced ER Model
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
SEE MORE TEXTBOOKS