Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 3: (Exercise#28 Page#242 in 6th Edition) Consider the following ER diagram for the MOVIES database, by given the constraints, respond to the following statements

image text in transcribedimage text in transcribed

Question 3: (Exercise\#28 Page\#242 in 6th Edition) Consider the following ER diagram for the MOVIES database, by given the constraints, respond to the following statements with True, False, or Maybe. Assign a response of Maybe so statements that, while not explicitly shown to be True, cannot be proven False based on the schema as shown. a. There are no actors in this database that have been in no movies. b. There are some actors who have acted in more than ten movies. c. Some actors have done a lead role in multiple movies. d. A movie can have only a maximum of one lead actor. e. Every director has been an actor in some movie. f. No producer has ever been an actor. g. A producer cannot be an actor in some other movie. h. There are movies with more than a dozen actors. i. Some producers have been a director as well. j. Most movies have one director and one producer. k. Some movies have one director but several producers. l. No movie has a director that also acted in that movie. Question 4: The following ER diagram is part of database of cars insurance company; try to write down its requirements that described the company (miniworld): Question 5: Create an ER or EER model for the following case studies: - Identify the relationship type, the participating entity types, and the attributes of each entity type, the primary key, the cardinality ratio, and participation constraints. - Make any assumption you need. CASE\#1: The Motor Vehicle Branch administers driving tests and issues driver's licenses. Any person who wants a driver's license must first take a learner's exam at any Motor Vehicle Branch. If he fails the exam, he can take the exam again any time after a week of the failed exam date, at any branch. The system requirements are: - The driver identified by his SSN, and he has name, birth date, and address which contain from his city and phone number. - A driver takes exam in one branch, the exam date, exam score, and exam time must be recorded. Any driver must take at least one exam. And he must own at least one license. - Each branch identified by branch id, branch name, branch address. A branch may issue at least one license we need to keep track on the issue date for each license issued. - Each license has license number, license class, and license expiry. Each license issued by one and only one branch and it owned by one and only one driver

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

PostgreSQL Up And Running A Practical Guide To The Advanced Open Source Database

Authors: Regina Obe, Leo Hsu

3rd Edition

1491963417, 978-1491963418

More Books

Students also viewed these Databases questions