CPSC 304 2005 MIDTERM 1 SOLUTIONS

Eaandbformtheprimarykeyofrthefollowingisa

Info iconThis preview shows page 1. Sign up to view the full content.

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

Unformatted text preview: e to store certain information unless some other, unrelated, information is stored as well. False. An update anomaly is if one copy of such repeated data is updated, an inconsistency is created unless all copies are similarly update. What is described is an insertion anomaly (see textbook page 607) Given the table R(a,b,c) (i.e., a and b form the primary key of R), the following is a valid table definition. CREATE TABLE S ( a INTEGER, d INTEGER, e INTEGER, PRIMARY KEY (d), FOREIGN KEY (a) references R) False. A foreign key must reference all of a key – in this case it must reference a,b h. In ER diagrams, aggregation may be used instead of a ternary relation if we need to impose additional constraints True. See slides or page 45 in the book True False True False True False Page 2 Name Student No 2. {14 marks} Consider the schema R = (A, B, C, D, E, F) together with the functional dependencies: AàB DEàF BàC a. {10 marks} Is R(A, B, C, D, E, F) in BCNF? If so, say why. If not, decompose this relation into BCNF using t...
View Full Document

Ask a homework question - tutors are online