able 4-4 on page 197 shows a relation called GRADE REPORT for a university. Your assignment is as follows:Draw a relational schema and diagram the functional dependencies in the relation.In what normal form is this relation?Decompose GRADE REPORT into a set of 3NF relations.Draw a relational schema for your 3NF relations and show the referential integrity constraints (as shown in Figure 4-5 on page 163).Draw an ER-diagram for your answer to part d above.

Alright, let's break this down step by step. Step 1: Relational Schema and Functional…

Answered: able 4-4 on page 197 shows a relation…

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

Related questions

Question

able 4-4 on page 197 shows a relation called GRADE REPORT for a university. Your assignment is as follows:

Draw a relational schema and diagram the functional dependencies in the relation.
In what normal form is this relation?
Decompose GRADE REPORT into a set of 3NF relations.
Draw a relational schema for your 3NF relations and show the referential integrity constraints (as shown in Figure 4-5 on page 163).
Draw an ER-diagram for your answer to part d above.

Expert Solution