Recent Question/Assignment

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 above table
1. Draw a dependency diagram to show the functional dependencies in the relation
2. Decompose the GRADE REPORT relation into a set of 3NF relations
3. Draw a relational schema for your 3NF relations and show the referential integrity constraints
NOTE

Editable Microsoft Word Document
Word Count: 306 words including Diagrams and Codes


Buy Now at $19.99 USD
This above price is for already used answers. Please do not submit them directly as it may lead to plagiarism. Once paid, the deal will be non-refundable and there is no after-sale support for the quality or modification of the contents. Either use them for learning purpose or re-write them in your own language. If you are looking for new unused assignment, please use live chat to discuss and get best possible quote.

Looking for answers ?