Question: 3) The Grade Report Table below shows a relation called Grade Report for a university. For this relation: a. Draw a relational model and diagram

3) The Grade Report Table below shows a relation called Grade Report for a university. For this relation: a. Draw a relational model and diagram the functional dependencies in the relation. b. In what normal form is this relation in? c. Decompose Grade Report into a set of 3NF relations. d. Draw a relational model for your 3NF relations and show the referential relationships.

StudentID

StudentName

CampusAddress

Major

CourseID

CourseTitle

Instructor Name

Instructor Location

Grade

168300458

Williams

208 Brooks

IS

IS 350

Database Mgt

Codd

B104

A

168300458

Williams

208 Brooks

IS

IS 465

Systems Analysis

Parsons

B317

B

543291073

Baker

104 Phillips

Acctg

IS 350

Database Mgt

Codd

B104

C

543291073

Baker

104 Phillips

Acctg

Acct 201

Fund Acctg

Miller

H310

B

543291073

Baker

104 Phillips

Acctg

Mkgt 300

Into Mktg

Bennett

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 Databases Questions!

Q:

The Grade Report Table below shows a relation called Grade Report for a university. For StudentID StudentName CampusAddress Major CourseID 168300458 Williams 208 Brooks IS IS 350 168300458 Williams...

Q:

DATABASE MANAGEMENT Table below 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...

Q:

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...

Q:

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...

Q:

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...

Q:

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...

Q:

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...

Q:

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...

Q:

The table below shows a relation called GRADE REPORT for a university. a. List the functional dependencies in the relation. b. In what normal form is this relation? c. Decompose GRADE REPORT into a...

Q:

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....

Q:

Placer Corporation acquired 80 percent of Billings Company's voting common stock on January 1, 20X4. Placer and Billings reported total revenue of $410,000 and $200,000 and total expenses of $320,000...

Q:

Refer to Exercise 12.46. How could you find out whether calcium caused the lower death rates associated in this study with its use? Describe the design of a study assuming you had 300 women to work...

Q:

pf 1 - exam - english 6 2 of 7 0 1 : 3 7 : 0 5 Question: 5 6 - 3 7 Yolanda joined Montreal Financial in July 1 9 7 9 . Her employment was terminated on November 3 0 , 2 0 1 3 and she was paid a $ 6 6...

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

3. How would this philosophy fit in your organization?

Q:

2. What elements of more contemporary views of culture and change are expressed here?

Q:

3. What information do participants need?