cs411-f09-mt-sol - FALL 09 MIDTERM SOLUTION Problem 1 1)...

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

View Full Document Right Arrow Icon
FALL 09 MIDTERM SOLUTION Problem 1 1) FALSE 2) TRUE 3) TRUE 4) FALSE 5) TRUE 6) FALSE 7) FALSE 8) FALSE 9) TRUE 10) FALSE Problem 2 a) See Figure 1. People Email Owns Figure 1: Problem 2a b) See Figure 2. Customers Accounts Has Branch Figure 2: Problem 2b c) See Figure 3. d) 1. ER-style approach: Account(AccountID , Balance) CheckingAccount(AccountID , Overdraft) 1
Background image of page 1

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

View Full DocumentRight Arrow Icon
Account AccountID Balance CheckingAccount Overdraft isa Figure 3: Problem 2c 2. Object-Oriented approach: Account(AccountID , Balance) CheckingAccount(AccountID , Balance, Overdraft) e) The Object-Oriented approach uses the least amount of storage since each object can only belong to a single table. While in the ER approach, CheckingAccount may store fewer attributes, but all its tuples are repeated in Account. f) 1. Manufacturer is nothing but a name and it’s at the “one” end of any relationship, hence it should not be an entity set. 2. See Figure 4. Beers Name ManfName Figure 4: Problem 2f Problem 3 a) (3 points) 1 point for identifying both update and delete anomaly, 1 each for examples. 1. Update anomaly: A doctor may have more than one patient, so an update anomaly may result if a
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.

This note was uploaded on 02/17/2012 for the course CS 411 taught by Professor Winslett during the Fall '07 term at University of Illinois at Urbana–Champaign.

Page1 / 4

cs411-f09-mt-sol - FALL 09 MIDTERM SOLUTION Problem 1 1)...

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