Quiz 2 Open Book Section

This exam is given in two parts. The closed book section of this exam is to be worked without reference to any other written information other than the exam. You must turn in the closed book section of the exam before consulting your book and notes.

Question 1 and only (60 points)

Start with a table, that could be used to track university book orders, that has nine columns.

Attribute	Purpose	Example value
Department	Academic department	CSCI
Course	Course number, within department	343
Section	Section number, for a course	001
Instructor	Section instructor	D Brock
Phone	Instructor's phone number	x5161
Textbook	Course textbook	Database Systems: A Practical ...
Author	Textbook author	Connolly, Begg, and Strachan
Publisher	Textbook publisher	Addison-Wesley
ISBN	ISBN id	0-201-34287-1

Here are a few useful facts to use in normalization:

All sections of a course use the same texbook.
Different sections of a course may be taught by different instructors.
The ISBN will determine a book title, author, and publisher.
Different editions of a book will have different ISBN's.

Subquestion 1.A

What are the possible candidate key sets for the table?

Subquestion 1.B

Is the table in First Normal Form? If so, why? If not, how could it be put into First Normal Form?

Subquestion 1.C

What are the dependencies in the table? You may need to make some assumptions in answering this question. Please state your assumptions clearly.

Subquestion 1.D

Is the table now (after possible processing in Subquestion 1.B) in Second Normal Form? If so, why? If not, how could it be put into Second Normal Form?

Subquestion 1.E

Is the table now in Third Normal Form? If so, why? If not, how could it be put into Third Normal Form?

Subquestion 1.F

Is the table now in Boyce-Codd Normal Form? If so, why? If not, how could it be put into Boyce-Codd Normal Form?

Subquestion 1.G

What is your name?