Using above table answer to below question: 1. Draw a dependency diagram to show the functional...

  

Transcribed Image Text:

Using above table answer to below question: 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 Campus Majo Course_ Addres Instructo Grad r_Locati Student N Instructor Student_ID Course_title ID _Name ame r on 16830058 Williams Albury BIT ITC114 Database Sys Peter B104 HD 16830058 Williams Albury BIT ITC211 Sys Analysis John B115 543291073 Baker Wagga Acct ITC200 Database Mgt David Н310 543291073 Baker Wagga Acct Accl1 Fund Acct William A120 C 543291073 Baker Wagga |Acct Mkg21 Intro Mkt Mike Al12 P Alelu Using above table answer to below question: 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 Campus Majo Course_ Addres Instructo Grad r_Locati Student N Instructor Student_ID Course_title ID _Name ame r on 16830058 Williams Albury BIT ITC114 Database Sys Peter B104 HD 16830058 Williams Albury BIT ITC211 Sys Analysis John B115 543291073 Baker Wagga Acct ITC200 Database Mgt David Н310 543291073 Baker Wagga Acct Accl1 Fund Acct William A120 C 543291073 Baker Wagga |Acct Mkg21 Intro Mkt Mike Al12 P Alelu

Answer rating: 100% (QA)

Draw a dependency diagram to show all dependencies in the given data including the partial and transitive dependencies Normalize the table into a set ... View the full answer