Honelp with Normalization.

[gammaman]

I need some help with some homework I have on the Normalization Process. I have made a very valid attempt and would appricaite it if I could get some help and guidance.

Original Record:
{ID > Name, ID > Major, CrsID > CrsName, CrsID > CrdHr, CrsName > CrdHr, CrsID,Sec > Instr, CrsID,Sec > Loc, ID,CrsID,Yrsec > Grade}

1. Convert the record to first normal form

R1(CrsID,ID,YrSec,Grade)
R2(CrsID,Sec,Instr,Loc)
R3(CrsName,CrdHr)
R4(CrsID,CrsName)
R5(ID,Name,Major)

[gammaman]

Can someone please help. Just let me know if I am in 1st NF or not.

[rmiao]

The only thing that is required for a table to be in 1NF is to contain only atomic values (intersection of each row and column should contain one and only one value). You can check your table to find out if it's 1NF or not.

[gammaman]

OK let me try again and share my thought process. Just let me know if my understanding is correct.

ID goes to both name and major, this can be combined

R1(ID,Name,Major)

Same for CrsID to crsName and CrdHr

R2(crsid,crsName,CrdHr)

The rest would all stay as they meet First NF so we would have

R1(ID,Name,Major)
R2(CrsID,crsName,CrdHr)
R3(CrsName,CrdHr)
R4(CrsID,Sec,Loc)
R5(ID,CrsID,Yrsec,Grade)

[J013]

I think what rmaio is saying is that you need to look at the values in the table and not just the field names to determine if the table is in the 1NF or not. 1NF's main rule is that there are no repeating groups. So in order to identify this you need to look at the data in the table to see if there are any repeating groups.

What you are trying to do is closer to 3NF. If your requirement is to be 1NF compliant, you may already be there, but you need to look at the data in the table to ensure that.

Database normalization

First normal form