Education Help

From: Warren <nospam_at_you.com>
Date: Tue, 16 Apr 2002 14:41:16 +1000
Message-ID: <3cbbab73$0$9991$afc38c87@news.optusnet.com.au>

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 Mon Apr 15 2002 - 23:41:16 CDT