normalization

hi all,

i am doing an exercise on normalization and i was stuck on ..

In UNF,
primary key : student_no

In 1NF,
primary key : lease_no <- This attribute can uniquely identify a row without the attribute student_no. Is it possible to have only one key attribute for the primary key in 1NF? can i remove the student_no which is a primary key in UNF ??

if so, there will be no partial dependency exists? is it possible ?

*because all the book i read have more than one key attributes for primary key in 1NF.

Thanks.
Shawn. (novice) Received on Sun Nov 26 2000 - 17:29:37 CET