HW1 - EECS 484 Homework #1 Question 1: Consider the...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
EECS 484 – Homework #1 Question 1 : Consider the following ER Diagram, which associates actors and movies. Which of the following statements is true? (Select all that apply.) a) An actor can star in multiple movies. b) Each actor has to star in a movie. c) Every movie has a star. d) A movie can have no more than one starring actor. Explain your answer: Question 2 : Define the terms physical data independence and logical data independence in the context of relational databases.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Question 3: All of the following questions refer to this ER diagram, which describes a music database. (a) Suppose that a band wants to create a “greatest hits” album containing their most successful songs from past albums. Does this database design allow us to represent this situation? Why or why not? No! This diagram does not allow a song to appear on more than one album. (Notice that there is a key constraint, denoted by an arrow from Songs to Appears.) (b) Suppose that you have noticed that musicians often keep multiple addresses due to touring. Does this
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

HW1 - EECS 484 Homework #1 Question 1: Consider the...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online