Please note the last requirement, copy and paste from otherposts will be incorrect. The television show Saturday
Fantastic news! We've Found the answer you've been seeking!
Question:
Please note the last requirement, copy and paste from otherposts will be incorrect.
Transcribed Image Text:
The television show Saturday Night Live (SNL) needs help designing its database. The show stores information about its shows, cast members, guests and sketches. Draw an ER diagram describing the SNL database for the scenario described below. Assume that the only business rules that hold are those stated below, and that no additional business rules hold. • An SNL show is uniquely identified by a combination of season and sequence number. Each show airs live on a particular date (don't worry about whether the year of the date matches the show's season.) The TV network may decide to rerun a popular show, and a rerun may take place on one or several dates. All dates on which a show airs must be recorded in the database. A given show will have at most one re-run per date, but it is possible that two shows could be re-run on the same date (e.g., during a Best of SNL special). • Each show features a host, uniquely identified by the host's name. There is exactly one host per show. SNL only records hosts in their database who hosted at least one show. A host can perform in a sketch (but doesn't always). A sketch doesn't always have a host that performs in it. • A show features a series of sketches (always at least one sketch), described by their titles. A sketch is performed during exactly one show. The associated show entity and the sketch title uniquely identify the sketch. Sketches are written by one or several writers and performed by one or several cast members. Each writer has written zero or more sketches (zero because there could be a new writer). Each cast member has performed in zero or more sketches (zero because there could be a new cast member). • You may assume that writers and cast members are uniquely identified by their names. • Each cast member has at least one address and at least one phone number. In principle, two or more cast members could have the same phone number. For the purpose of this exercise, do not represent Rerun as an entity, but do represent Writer and Host as entities. The television show Saturday Night Live (SNL) needs help designing its database. The show stores information about its shows, cast members, guests and sketches. Draw an ER diagram describing the SNL database for the scenario described below. Assume that the only business rules that hold are those stated below, and that no additional business rules hold. • An SNL show is uniquely identified by a combination of season and sequence number. Each show airs live on a particular date (don't worry about whether the year of the date matches the show's season.) The TV network may decide to rerun a popular show, and a rerun may take place on one or several dates. All dates on which a show airs must be recorded in the database. A given show will have at most one re-run per date, but it is possible that two shows could be re-run on the same date (e.g., during a Best of SNL special). • Each show features a host, uniquely identified by the host's name. There is exactly one host per show. SNL only records hosts in their database who hosted at least one show. A host can perform in a sketch (but doesn't always). A sketch doesn't always have a host that performs in it. • A show features a series of sketches (always at least one sketch), described by their titles. A sketch is performed during exactly one show. The associated show entity and the sketch title uniquely identify the sketch. Sketches are written by one or several writers and performed by one or several cast members. Each writer has written zero or more sketches (zero because there could be a new writer). Each cast member has performed in zero or more sketches (zero because there could be a new cast member). • You may assume that writers and cast members are uniquely identified by their names. • Each cast member has at least one address and at least one phone number. In principle, two or more cast members could have the same phone number. For the purpose of this exercise, do not represent Rerun as an entity, but do represent Writer and Host as entities.
Expert Answer:
Answer rating: 100% (QA)
hostName Host hostName hostPhone hostAddress hostPhone Host hostAddress hosts ER Diagram seas... View the full answer
Related Book For
Systems analysis and design
ISBN: 978-0136089162
8th Edition
Authors: kenneth e. kendall, julie e. kendall
Posted Date:
Students also viewed these electrical engineering questions
-
Please don't copy and paste from "google" !!!!! - write a page or two atlest about: ( purpuse of statement ) . - i am applying for a master dgree so i need personal statement for this major (...
-
DO NOT COPY AND PASTE FROM INTERNET PLEASE I COULD DO THAT ALSO I WANT YOU TO ANSWER ME THIS QUESTION IN DETAILS PLEASE THIS IS FOR MY EXAMS Q9). What are the eleven main causes of material...
-
Please don\'t copy from internet type your own words and don\'t write in the paper please this is my request brief explanation state and explain the law of conservation of energy with an example.
-
Refer to the situation described in P 192. Assume Pastner measures the fair value of all options on January 1, 2021, to be $4.50 per option using a single weighted-average expected life of the...
-
If the Fed wants to increase the money supply with open-market operations, what does it do?
-
In problem, list the intercepts and test for symmetry. y = 3x/(x 2 + 9)
-
Widget, Corp., completed the following inventory transactions during the month of January: Requirements 1. Without resorting to calculations, determine which inventory method will result in Widget,...
-
A 500.0-g bird is flying horizontally at 2.25 m/s, not paying much attention, when it suddenly flies into a stationary vertical bar, hitting it 25.0 cm below the top (Fig. 10.63). The bar is uniform,...
-
~4~ 14) Professor What-A-Guy surveyed a random sample of 360 statistics students. One of the questions was "Will you take another mathematics class?" The results showed that 220 of the students said...
-
Procter & Gamble has been the leading soap manufacturer in the United States since 1879, when it introduced Ivory soap. However, late in 1991, its major rival, Lever Bros. (Unilever), overtook it by...
-
A pendulum clock keeps time by swinging of a uniform solid rod pivoted at one end. The angular position of the rod is given by ?t=(.175 rad) sin (p t), where t is in seconds. What is the angular...
-
What purpose does the Federal Trade Commission serve and why must business owners be educated on Federal Trade Commission practices? Consider 1 of the following sections of the Federal Trade...
-
A 50. kg person is riding a roller coaster through the top of a 30. m curve. At what speed must the person be going so that they feel weightless through the top of the curve? A rubber stopper went...
-
(a) What is the cost of heating a hot tub containing 1540 kg of water from 10.0C to 40.0C, assuming 75.0% efficiency to take heat loss to surroundings into account? The cost of electricity is...
-
A company sells two products: microwaves and toaster ovens. The expected sales for microwaves were 3,000 units; 4,000 were sold. The budgeted selling price for microwaves was $78.00; however, the...
-
1.How would you define Logistics Management and Supply Chain management? Why is it important to have an effective and agile Supply Chain in our current business climate? 2. Consider the purchase of...
-
A stationary box is exploded with pieces flying in every direction away from the blast site. Part A: What is the value for the total momentum after the explosion? Part B: How does this compare with...
-
Evaluate the integral, if it exists. Jo y(y + 1) dy
-
Why is defining classes such an important object-oriented analysis task?
-
Now Glinda and Elphaba are even more confused than before. They have three distinct options: to create a package on their own, buy commercial off-the-shelf software such as QuickBooks Pro, or...
-
The five-year-old TowerWood hotel chain needs help designing its Web site. The company maintains properties in all the large U.S. tourist communities such as Orlando, Florida (near Disney World);...
-
a. Who may bring suit under the 1934 Securities Exchange Act? b. Is the basis for action the same as in a 1933 Act suit? Explain.
-
What are the responsibilities of the plaintiff and the defendant in a 1933 Act suit?
-
Under what circumstances will a statement be presumed to be misleading?
Study smarter with the SolutionInn App