# 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?