Please provide complete answer for all questions. Tq.

1. STUDENT_ID 1001 STUDENT_NAME STD1 COURSE_CODE DBMS COURSE_NAME DATABASE 1002 STD2 DBMS DATABASE 1003 STD3 OS OPERATING SYSTEM MALAYSIAN MALAYSIA 1004 STD4 OS OPERATING SYSTEM INDIAN INDIA CITIZEN COUNTRY INDIAN INDIA MALAYSIAN MALAYSIA Fig 2 Making use of the above given table with data in Fig 2, answer the questions given below 1. Draw the dependency diagram and identify the various dependencies for 1 NF. Also, give the relational schema. II. Create a database whose tables are in 2NF, show the dependency diagram/s. Also, give the relational schema. III. Create a database whose tables are in 3NF, show the dependency diagram /s. Also, give the relational schema. Draw an ERD for the final tables (3+3+3+2=11 Marks) IV