Q: Consider the following Report: Student

STUDENT DETAILS STUDENT No. STUDENT NAME STUDENT ADDRESS COURSE ENROLLED MODE OF STUDY LECTURER NUMBER LECTURER NAME ACADEMIC RECORD: S1234567 Poindexter Jones 23 Wide Road, Kew, 3101 BSc Internal AS200 Guiseppe Bloggs SUBJECT CODE SUBJECT NAME YEAR/ SEMESTER GRADE CS830 Introduction to Databases 2020/1 A CS891 Computing Fundamentals 2020/1 B Based on the above, provide the answers to the following question: (1) Normalize the student report to arrive at a suitable database design which satisfies the third normal form, clearly show the stages UNF (Un-normalized = Raw relations), INF. 2NF, 3NF. Indicate the PK and FKS. STUDENT DETAILS STUDENT No. STUDENT NAME STUDENT ADDRESS COURSE ENROLLED MODE OF STUDY LECTURER NUMBER LECTURER NAME ACADEMIC RECORD: S1234567 Poindexter Jones 23 Wide Road, Kew, 3101 BSc Internal AS200 Guiseppe Bloggs SUBJECT CODE SUBJECT NAME YEAR/ SEMESTER GRADE CS830 Introduction to Databases 2020/1 A CS891 Computing Fundamentals 2020/1 B Based on the above, provide the answers to the following question: (1) Normalize the student report to arrive at a suitable database design which satisfies the third normal form, clearly show the stages UNF (Un-normalized = Raw relations), INF. 2NF, 3NF. Indicate the PK and FKS