Question: 4. The following table shows a relation called GRADE REPORT for a university. Your assignment is as follows: 4.1. Draw a relational schema and diagram

4. The following table shows a relation called GRADE REPORT for a university. Your assignment is as follows:

4. The following table shows a relation called

4.1. Draw a relational schema and diagram the functional dependencies in the relation.

4.2. In what normal form is this relation?

4.3. Decompose GRADE REPORT into a set of 3NF relations, and show the referential integrity constraints among relations.

I greatly appreciate the help, thanks in advance!!

StudentName StudentID CampusAddress Major Instructor Name Instructor Location Course Title CourseID Grade 168300458 Williams IS S 350 B 104 208 Brooks 208 Brooks 168300458 Williams IS IS 465 B 317 B Baker 104 Phillips Acctg IS 350 Database Mgt Codd Systems Analysis Parsons Database Mgt Codd Fund Acctg Miller Intro Mktg Bennett 543291073 543291073 B 104 Baker 104 Phillips Acet Acct 201 H 310 B 543291073 Baker 104 Phillips Acet Mit 300 B212 A StudentName StudentID CampusAddress Major Instructor Name Instructor Location Course Title CourseID Grade 168300458 Williams IS S 350 B 104 208 Brooks 208 Brooks 168300458 Williams IS IS 465 B 317 B Baker 104 Phillips Acctg IS 350 Database Mgt Codd Systems Analysis Parsons Database Mgt Codd Fund Acctg Miller Intro Mktg Bennett 543291073 543291073 B 104 Baker 104 Phillips Acet Acct 201 H 310 B 543291073 Baker 104 Phillips Acet Mit 300 B212 A

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

The following table contains sample data for parts and for vendors who supply those parts. In discussing these data with users, we find that part numbers (but not descriptions) uniquely identify...

The following table shows a relation called GRADE REPORT for a university. Your assignment is as follows: a. Draw a relational schema and diagram the functional dependencies in the relation....

. The following table shows a relation called GRADE REPORT for a university. Your assignment is as follows: a. Draw a relational schema and diagram the functional dependencies in the relation. [your...

Transform following ER diagram into 3 N F relations. In your relation, please specify the primary key, foreign keys ( if have ) , and all dependencies. Draw the relations. The following table shows a...

The following table shows a relation called GRADE REPORT for a university. Your assignment is as follows: a. Draw a relational schema and diagram the functional dependencies in the relation. [your...

Question 2 The following Table shows a relation called GRADE REPORT for a university. Grade Report Instructor Instructor StudentID StudentName CampusAddress Major CourseID CourseTitle Name Location...

Table 4-4 shows a relation called GRADE REPORT for a university. Your assignment is as follows: a. Draw a relational schema and diagram the functional dependencies in the relation. b. In what normal...

What position do you support? (A or B). What is the basis for your answer (e.g., a court decision, the language of Title VII, EEOC Guidelines)?

Conklin Corporation recorded the following activities during its first month of operations: Purchased materials costing $250,000. Used direct materials in production costing $230,000. Incurred...

Natalie had a very busy December. At the end of the month, after journalfing and posting the December transactions and acfusting entries, Natalie prepared the following Eluustedtriat batance. \ table...

What is an example of constructive feedback? provide reference