Let’s suppose the product owner for the TV Guide App would like to include additional data about the cast appearing on e

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

Let’s suppose the product owner for the TV Guide App would like to include additional data about the cast appearing on e

Post by answerhappygod »

Let’s suppose the product owner for the TV Guide App would liketo include additional data about the cast appearing on episodes,so, for instance you can see which actors appeared on specificepisodes and information about those actors. Enhance your datamodel to include: Actors, who may appear on multiple episodes andeven different programs Actors may have additional facts ofinterest associated with them, such as height, weight, age,favorite food, gender, race, etc. However, the product owner forthe app isn’t sure exactly what the set of possible facts is inadvance, so they would like this part of the data model to beextensible. Also, data will not be available for every fact forevery actor.
--Draw ER diagram data model to capture the actors and thefacts about them Write a short explanation of why you’ve madespecific choices in the model (for instance, if it’s normalized,why? If not, why? If you are enforcing certain constraints,why?)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply