2a. 1NF
| S_NUM | S_NAME | CRSE_NUM | CRSE_DESCR | GRADE | ADV_NAME | ADV_OFFICE |
| 12345 | Don Brewse | ECON 241 | Macroeconomics | B | Kominski | KOM-203H |
| 12345 | Don Brewse | QM 261 | Intro Stat. I | C | Kominski | KOM-203H |
| 12345 | Don Brewse | ACCT 211 | Acounting Princ. | B | Kominski | KOM-203H |
| 12345 | Don Brewse | INFS 220 | Intro to Micros | A | Kominski | KOM-203H |
| 12345 | Don Brewse | ENG 211 | Literature | B | Kominski | KOM-203H |
| 24356 | Jan Himmel | INFS 272 | Cobol | B | Coronado | BMOM-123D |
| 24356 | Jan Himmel | HIST 202 | AmericanHistory | A | Coronado | BMOM-123D |
| 24356 | Jan Himmel | MATH 344 | MGMT Calculus | A | Coronado | BMOM-123D |
| 24356 | Jan Himmel | ACCT 212 | Accounting Princ. | C | Coronado | BMOM-123D |
| 24356 | Jan Himmel | MGMT 361 | Management Princ. | A | Coronado | BMOM-123D |
PK = S_NUM, CRSE_NUM
Dependency Diagram
2b) 2NF Tables
STUDENT (S_NUM, S_Name, Adv_name, Adv_Office)
COURSE (CRSE_NUM, Crse_Desc)
GRADE (S_NUM*, CRSE_NUM*, grade)
3b) 3NF (Remove Transitive Dependency in STUDENT)
STUDENT (S_NUM, S_Name, Adv_name*)
COURSE (CRSE_NUM, Crse_Desc)
GRADE (S_NUM*, CRSE_NUM*, grade)
ADVISOR (Adv_Name, Adv_Office)
{If you add a new attribute, ADV_Num, as PK, that
is OK - as long as you also use ADV_NUM as the FK in STUDENT)}