Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started