DATABASE NORMALIZATION - Instructions: Normalize the following tables according to the following:

1. Refer to Table 1, and convert the said table into 1NF.

2. Refer to Table 2, and convert the said table into 2NF. Additional tables can be formulated or added if necessary.

Please upload the photo of your solution to this activity.

 

Transcribed Image Text:

Table 1: Student Info Student Number First Name Last_Name Subjects Enrolled LN-001121 Francis Fernandez NET 101,IM 102,WS_101 LN-001101 Via Mae Alejandro WS_101 LN-002314 Char Mae Choresca IM 102, CC_106 Table 2: Score Table Score_ID Student_ID Student_Name Subject_ID Subject_Title Teacher 1 1001 Rafael Fernandez IM-102 DBMS-2 JET Web Systems 2 1002 Mark Beaver Vargas WS-101 and MCL Technologies 3 1003 Rene Bautista IM-102 DBMS - 2 JET Table 1: Student Info Student Number First Name Last_Name Subjects Enrolled LN-001121 Francis Fernandez NET 101,IM 102,WS_101 LN-001101 Via Mae Alejandro WS_101 LN-002314 Char Mae Choresca IM 102, CC_106 Table 2: Score Table Score_ID Student_ID Student_Name Subject_ID Subject_Title Teacher 1 1001 Rafael Fernandez IM-102 DBMS-2 JET Web Systems 2 1002 Mark Beaver Vargas WS-101 and MCL Technologies 3 1003 Rene Bautista IM-102 DBMS - 2 JET