Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. You have been called upon to do some conceptual data modeling for the Seattle Summer Concert Series (SSCS). [Seattle Summer Concert Series (SSCS) business

1. You have been called upon to do some conceptual data modeling for the Seattle Summer Concert Series (SSCS).

[Seattle Summer Concert Series (SSCS) business scenario]

  • The concert season indicates the season when a series of concerts is performed. The attributes of concert season are seasonID and opening date. Season ID uniquely identify each concert season.
  • A concert is a performance that consists of one or more compositions. The primary key of concert is concert number, and an additional attribute is concert date.
  • The composition entity tracks the compositions to be performed at each concert. Information tracked on each composition includes compositionID (Primary Key), composer name (First name, Last name), and composition name.
  • Conductors conduct concerts. The SSCS tracks conductor names (First name, Last name) and conductor IDs. Conductor ID uniquely identifies each conductor.
  • Soloists perform compositions during concerts. The two attributes for soloists are soloist ID (Primary key) and soloist name (First name, Last name).
  • Each composition may need multiple soloists, or may not require any soloists. A soloist may perform multiple compositions, or may not perform any compositions. In each concert season, at least one or more concerts are scheduled. A particular concert is scheduled for only one concert season. For each concert there is one and only one conductor. A conductor may conduct many concerts, or may not conduct any at all. A concert includes the performance of one or more compositions. A composition may be performed at one or more concerts, or may not be performed at all.

1

1. Prepare an ERD based on the scenario. (2.5 points)

  • Indicate the primary key for each entity in your ERD.
  • Clearly show all other attributes of all the entities in the ERD If a scenario doesnt specify an

identifier, make one for each entity.

  • Show all the cardinalities.
  • Please write down any assumptions you make.

2

2. Convert the ERD you have drawn in section 1 into relations. Indicate the primary key and foreign key in each table and show referential integrity constraints using arrows. (2.5 points)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

OCA Oracle Database SQL Exam Guide Exam 1Z0-071

Authors: Steve O'Hearn

1st Edition

1259585492, 978-1259585494

Students also viewed these Databases questions

Question

Explain how SIHRM is linked to different global business strategies

Answered: 1 week ago