Assignment title: Information
Task Table 1: GRADE REPORT relation Student_ID Student_Name Campus_Address Major Course_ID Course_title Instructor_Name Instructor_Location Grade 16830058 Williams Albury BIT ITC114 Database Sys Peter B104 HD 16830058 Williams Albury BIT ITC211 Sys Analysis John B115 D 543291073 Baker Wagga Acct ITC200 Database Mgt David H310 D 543291073 Baker Wagga Acct Acc11 Fund Acct William A120 C 543291073 Baker Wagga Acct Mkg21 Intro Mkt Mike A112 P Using Table 1: GRADE REPORT relation above 1. Draw a dependency diagram to show the functional dependencies in the relation 2. Decompose GRADE REPORT into a set of 3NF relations 3. Draw a relational schema for your 3NF relations and show the referential integrity constraints NOTE Manually drawing the dependency diagram or the relational schema is NOT acceptable.