IT-330 Normalization Exercise

STUDENTID STUDENTLAST STUDENTFIRST STUDENTGENDER MAJORID MAJORNAME CLASSID CLASSNAME FACULTYID FACULTYNAME FACULTYDEPARTMENT
100 JONES ANDREW M 153 BS-CNC IT120-01 HARDWARE 777 BERISHA SIT-BX
100 JONES ANDREW M 153 BS-CNC IT-126-01 SOFTWARE 777 BERISHA SIT-BX
100 JONES ANDREW M 153 BS-CNC IT-130-01 DATABASE 333 BHAGOJI SIT-NR
105 SMITH STAN M 157 BS-CIS IT-120-01 HARDWARE 777 BERISHA SIT-BX
105 SMITH STAN M 157 BS-CIS IT-170-31 CISCO 222 BOAHENG SIT-NR
110 REYES MICHELLE F 550 MS-CS CS-630-151 DBMS 111 SHAH SIT-KGS
115 CHEN XIA F 550 MS-CS CS-630-151 DBMS 111 SHAH SIT-KGS
115 CHEN XIA F 550 MS-CS CS-700-151 PROJECT 111 SHAH SIT-KGS

The given table is in First Normal Form (1NF).

  • Identify its composite PK (if you fail to identify it propoerly, your entire normalization process will fail)
  • Create an depedency diagram showing partial and transitive dependencies
  • Do the exercise to convert this table to Second Normal Form (2NF) by removing any partial dependencies
  • Now, convert your tables to Third Normal Form (3NF) by removing any transitive dependencies.
  • Write down the tables and the data records for each of the tables.

Hints:

Probable entities are

STUDENT
MAJOR
CLASS
FACULTY
REGISTRATION (Bridging-Entity)
DEPARTMENT (Maybe!)
Academic Honesty!
It is not our intention to break the school's academic policy. Posted solutions are meant to be used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly complete the form. Please provide a valid email address and we will get back to you within 24 hours. Payment is through PayPal, Buy me a Coffee or Cryptocurrency. We are a nonprofit organization however we need funds to keep this organization operating and to be able to complete our research and development projects.