3. The schema depicted in Question 2 showed a many-to-many relationship between actors and movies. However,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
3. The schema depicted in Question 2 showed a many-to-many relationship between actors and movies. However, this is not directly implementable in a relational database, so we introduce a new entity, APPEARANCE, in which each row represents an appearance of an actor a movie type of entity a. What kind of entity is APPEARANCE? Appearance is a b. What is the connectivity of the relationship between ACTOR and APPEARANCE? Many to many c. What is the connectivity of the relationship between MOVIE and APPEARANCE? d. Draw a diagram showing the updated schema, with all four entities. Show all needed attributes of the APPEARANCE entity. (You may omit other entities' attributes.) e. List the foreign key(s) in the APPEARANCE table. f. What is the primary key in the APPEARANCE table? SC150 2. Consider the following schema for a database of movies: VIE_ID STUDIO STUDIO ID STUDIO NAME produces Midterm Exam PK Barbie Oppenheimer Barbie MOVIE MOVIE ID MOVIETITLE STUDIO ID +4 STUDIO_NAME STUDIO ID 29 Warner Bros. 25 Universal 29 Warner Bros. 101 ACTOR 108 ACTOR JO a. State the four business rules that specify the connectivities of the relationships among these entities. 112 b. Consider a bad database design has the following table in it: MOVIE_TITLE ACTOR_ID ACTOR LNAME Robbie Fall 2023 ACTOR NAME ACTOR FNAME appears in Murphy Gosling ACTOR FNAME Margot Cillian Ryan Briefly describe a hypothetical situation in which you might encounter an anomaly in making a change to this database, and name the type of anomaly. 3. The schema depicted in Question 2 showed a many-to-many relationship between actors and movies. However, this is not directly implementable in a relational database, so we introduce a new entity, APPEARANCE, in which each row represents an appearance of an actor a movie type of entity a. What kind of entity is APPEARANCE? Appearance is a b. What is the connectivity of the relationship between ACTOR and APPEARANCE? Many to many c. What is the connectivity of the relationship between MOVIE and APPEARANCE? d. Draw a diagram showing the updated schema, with all four entities. Show all needed attributes of the APPEARANCE entity. (You may omit other entities' attributes.) e. List the foreign key(s) in the APPEARANCE table. f. What is the primary key in the APPEARANCE table? SC150 2. Consider the following schema for a database of movies: VIE_ID STUDIO STUDIO ID STUDIO NAME produces Midterm Exam PK Barbie Oppenheimer Barbie MOVIE MOVIE ID MOVIETITLE STUDIO ID +4 STUDIO_NAME STUDIO ID 29 Warner Bros. 25 Universal 29 Warner Bros. 101 ACTOR 108 ACTOR JO a. State the four business rules that specify the connectivities of the relationships among these entities. 112 b. Consider a bad database design has the following table in it: MOVIE_TITLE ACTOR_ID ACTOR LNAME Robbie Fall 2023 ACTOR NAME ACTOR FNAME appears in Murphy Gosling ACTOR FNAME Margot Cillian Ryan Briefly describe a hypothetical situation in which you might encounter an anomaly in making a change to this database, and name the type of anomaly.
Expert Answer:
Answer rating: 100% (QA)
The questions on the exam paper pertain to database design and the resolution of manytomany relationships between entities using an associative entity ... View the full answer
Related Book For
Smith and Roberson Business Law
ISBN: 978-0538473637
15th Edition
Authors: Richard A. Mann, Barry S. Roberts
Posted Date:
Students also viewed these programming questions
-
If the project has a higher risk profile than the company as a whole. What risk is company incurring by using the WACC as a discount rate for this project? Why?
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Suppose a town concludes that it costs on average $30.00 per household to manage the disposal of the waste generated by households each year. It is debating two strategies for funding this cost: (1)...
-
A non-conducting wall carries a uniform charge density of 8.60 %C/cm2. What is the electric field 7.00 cm in front of the wall? Does your result change as the distance from the wall is varied?
-
Moss, Inc. acquired land by issuing $665,000 of capital stock. No cash changed hands in this transaction. Will the transaction be disclosed in the company's statement of cash flows? Explain.
-
With reference to Exercise 11.9, (a) find a 95% confidence interval for the mean current density when the strain is \(x=0.50\); (b) find 95% limits of prediction for the current density when a new...
-
Microsoft and a smaller rival often have to select from one of two competing technologies. The rival always prefers to select the same technology as Microsoft (because compatibility is important),...
-
You need to calculate the stock price (per share) of RSM, a financial company. RSM has just paid $3 per share in dividends. You estimate that dividends will grow at 20% per year for the next three...
-
Using data from case exhibit 8 calculate the following:1) 2017 EVA for the North American Dermatology Division2) 2017 EVA bonus payout for a manager assuming that the managers salary is $300,000 and...
-
Consider a society S consisting of 2M students, and M schools each of size 2. Each student has a pre-schooling human capital ej. The post-schooling human capital of a student i with pre-schooling...
-
Cash Receipt Schemes and Other Asset Misappropriations, identify and describe two big data and data analytic techniques each for detecting skimming, cash larceny, and noncash misappropriations.
-
(a) Evaluate the characteristic equation of A = 2 3 -(;;) (b) Let A = 204 98 -26 -10 -134 36 14 348 -90 -36 -232 60 28 1716 -472 Find inverse of A vsing determinant (c) Diagonalize A = 5 - 6 hence...
-
1 - Give a horizontal curve with a radius of 450 m, delta angle 35 and the PI station of 15+20, compute the curve data and the station of PT. 2- A 6 horizontal curve covers an angle 68. Determine the...
-
How would a data analyst evaluate a conference call to get a feel for the sentiment of management?
-
IKEA entered the United States in 1985 and China in 1998. But the company started in 1958; why did it take so long to move into the United States and China? Why do you think IKEA is not in more than...
-
On 10 Jan, Tacoma Ltd anticipate that it will need Australian dollars (A$) in March when it orders supplies from an Australian supplier. The company purchase a future contract, specifying A$100,000...
-
Jax Incorporated reports the following data for its only product. The company had no beginning finished goods inventory and it uses absorption costing. $ 57.30 per unit $ 10.30 per unit $ 7.80 per...
-
Distinguish by example among interference with contractual relations, disparagement, and fraudulent misrepresentation.
-
Section 503A of the Food and Drug Administration Modernization Act of 1997 (FDAMA or Act), [citation], exempts compounded drugs from the Food and Drug Administrations standard drug approval...
-
Kenco Homes, Inc., sued Dale E. Williams and Debi A. Williams, husband and wife, for breaching a contract to purchase a mobile home. After a bench trial, the trial court ruled primarily for Williams....
-
What is the difference between real objects and virtual objects? Give an example for each.
-
Give a superclass for the following three classes: car, airplane, tank.
-
How do business classes differ from utility classes? Provide one example for each.
Study smarter with the SolutionInn App