Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I would like to get help with this please be clear and thank you for the help. Produce a relational schema diagram that corresponds to

I would like to get help with this please be clear and thank you for the help.image text in transcribed

Produce a relational schema diagram that corresponds to the linked ER diagram for a database for the television show Saturday Night Live (SNL). Your relational schema diagram should include primary and foreign keys. Often-times in database system development, requirements will change after the conceptual data model has been drafted: in your relational schema diagram, add the following three additional attributes: attribute "birth date" for the relation schema Host; attribute "start date" for the relation schema Writer; and attribute "salary" for relation schema Cast Member. Please refer back to the requirements in Question 6, for additional details that may constrain the design of the relational schema model. Use the tool linked to create an image. Hints: please carefully note that rerun date", "address", and phone" are multi-valued attributes; how would those be depicted in the relational schema diagram? Also, please carefully note the many-to-many relationships; how would those be depicted in the relational schema diagram? FYI: in ERRplus, define your primary key for a relation schema before you attempt to create a foreign key relationship to the relation schema. Figure 1: ER Diagram for Question 7 Host name 1 performed in season hosted seq_num title show id featured Show live date wrote Sketch rerun date P. Writer performed in name address Cast member phone name

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

Step: 3

blur-text-image

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

Practical Oracle8I Building Efficient Databases

Authors: Jonathan Lewis

1st Edition

0201715848, 978-0201715842

More Books

Students also viewed these Databases questions