Education help

Hi, just doing an introductory course to database design using Oracle 8i and was wondering
if some of you may be able to assist with one of my assignments. I am going to be posting my findings later today after some study, but I am interested in how 'others' attempt to answer. To me this is the best form of study group :) Anyway here goes:

For the relation below:

Book (CallNo, Title, Author, CopyNo, BorrowerName, BorrowerNo, WhereHeld)

Where WhereHeld is the name of a library,

(a) State any reasonable assumptions.

(b) Give functional dependencies based on your assumptions.

(c) Convert the relation to 1NF to 3NF (1NF, 2NF and 3NF)
Received on Tue Apr 16 2002 - 06:39:44 CEST