For the database concept you have chosen for Parts 1 and 2, provide the following:

Display your entities/tables in first normal form (1NF)

Display your entities/tables in second normal form (2NF)

Display your entities/tables in third normal form (3NF) You may need to rework your relationships to achieve this. For each form, provide the tables and the defining associations.

Next, define three (3) business processes that will access a particular table and attribute. For example: A customer login process will require accessing the CUSTOMER table and retrieving the CustomerID and CustomerPassword attributes. Provide detail on what the business process is and who is involved. For each business process, provide the SQL that would need to be run to access it in the first, second, and third normal forms you provided in the previous section.

Finally, choose a database optimization strategy, whether physical or logical, and describe how it could potentially benefit any or all of your normal form examples. Provide a comparison between a use case with and without this strategy implemented.

Marksheet (PK) Student ID Semester Has Professor (PK) Professor ID Professor Name Professor Sex Professor DOB Professor Address Professor Join Date Professor Designation Professor Salary Head of Department (PK) HOD ID HOD Department HOD Name HOD Sex Years of Experience Contact Number Department (PK) (FK) Department ID Department Name NUMBERREGISTERED Student (PK) Enroll Number (PK) (FK) Student ID (FK) Department ID Student Name Student DOB Student Address Student Sex Contact Number Tea Belongs Cordinate Fees (PK) Student ID (FK) Course ID Payment Method Instructs Principal (PK) Principal ID Principal Name Principal Join Date Principal Salary Enrolled For COURSE (PK) Course ID Course Name Course Fees Marksheet (PK) Student ID Semester Has Professor (PK) Professor ID Professor Name Professor Sex Professor DOB Professor Address Professor Join Date Professor Designation Professor Salary Head of Department (PK) HOD ID HOD Department HOD Name HOD Sex Years of Experience Contact Number Department (PK) (FK) Department ID Department Name NUMBERREGISTERED Student (PK) Enroll Number (PK) (FK) Student ID (FK) Department ID Student Name Student DOB Student Address Student Sex Contact Number Tea Belongs Cordinate Fees (PK) Student ID (FK) Course ID Payment Method Instructs Principal (PK) Principal ID Principal Name Principal Join Date Principal Salary Enrolled For COURSE (PK) Course ID Course Name Course Fees