2005-fall-cs4604-midterm

2005-fall-cs4604-midterm - CS4604 Midterm October 12, 2005...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: CS4604 Midterm October 12, 2005 Please enter the following information: Name: ID: Please do not write below this line. Question Maximum Score Score 1 5 2 5 3 5 4 30 5 20 6 15 7 20 Total 100 1 1. (5 points) A relationship R connecting entity sets E and F has referential integrity from E to F , i.e., the edge connecting R and F has a rounded arrow directed towards F . Circle all the following statements that may be true: (a) R is many-many from E to F . (b) R is many-one from E to F . (c) R is many-one from F to E . (d) R is one-one from E to F . 2. (5 points) Circle True or False . A relation with two attributes A and B satisfies the functional dependency A B . Then the functional dependency B A also holds in the relation. 3. (5 points) Circle True or False . R is a many-one relationship from entity set E to entity set F . The following ODL schema correctly represents E , F , and R . class E { relationship set<F> EtoR inverse F::FtoR; } class F { relationship E FtoR inverse E::EtoR; } 2 4. (30 points) In this question, you will draw an E/R diagram to model the television show Iron Chef. Do not worry if you have not seen this show! 1 The show features a set of four Iron Chefs, each one an expert in precisely one of the following cuisines: Chinese, French, Italian, and Japanese. Iron Chefs are famous; their name serves to identify them uniquely. Each episode, identified by an episode number,famous; their name serves to identify them uniquely....
View Full Document

Page1 / 7

2005-fall-cs4604-midterm - CS4604 Midterm October 12, 2005...

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

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