Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
omairbang
Starting Member
3 Posts |
 Posted - 2013-11-05 : 13:38:14
|
| Can someone please help, been stuck on the conversion part.Given the following database:For each table show in what normal form(1NF, 2NF, 3NF)the table is and if not in 3NF, convert them to 3NF (show intermediate work or explain why they are in 3NF).Student(stno, name,addr) stno is the primary keyStaff(sno,name,addr) sno is the primary keyFaculty(fno,name,rank,addr,socsecnum) fno,name is the primary key, fno is uniqueSection(cname,secnum,room_no,location) cname,secnum is primary keyCourse(cname, nounit,dept) cname is the primary key |
|
|
|
|
|
|
|
Normalization