Question: 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

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 form is this relation?
c. Decompose GRADE REPORT into a set of 3NF relations.
d. Draw a relational schema for your 3NF relations and show the referential integrity constraints.
e. Draw your answer to part d using Microsoft Visio (or any other tool specified by your instructor).

TABLE 4-4 Grade Report Relation Grade Report StudentlD StudentName CampusAddress Major CourselD CourseTitle 168300438 Williams 168300458 Williams $43291073 Saker 543291073 Baker 543291073 Baker Name Location Grade 208 Brcoks 208 Brocks 04 Philps 104 Phillips 04 Phillips 8 104 IS165 Systems Analyss Parsns B317 104 H 310 Bennett B212 IS IS 350 Database Acctg S 350 Databuse Mgt Codd Acctg Ar20 Fnd Acctg cctg Mkgt 300 irtro Mktq Miller

Step by Step Solution

★★★★★

3.59 Rating (170 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Functional dependencies b The relation is currently i... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

613-CS-DB (1685).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Figure shows a grade report that is mailed to students at the end of each semester. Prepare an ERD reflecting the data contained in the grade report. Assume that each course is taught by one...

The Public Safety office at Millennium College maintains a list of parking tickets issued to vehicles parked illegally on the campus. Table 4-6 shows a portion of this list for the fall semester....

For each of the following E-R diagrams from Chapter 2: I. Transform the diagram to a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema):...

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

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

Kollins Kids, Ltd. began the current year with 320,000 common shares outstanding and issued an additional 120,000 shares on August 1. The firm has $ 8,000,000, 5% convertible bonds outstanding at the...

Trevor is a 50 percent partner in the Dalmatian Partnership. His basis in his partnership interest is $30,000 at the end of the tax year but before the partnership gives Trevor a cash distribution of...

When a plant asset is acquired by the insurance of common stock in the fair value of the plant asset is not clearly determinable. The cost of the plant asset is properly measured by the power value...

Net Income (or Loss) and Retained Earnings The following information is available from the records of Prestige Landscape Design Inc. at the end of the 2010 calendar year: Accounts payable $ 5,000...

Explain why a physical OID must contain more information than a pointer to a physical storage location.

If physical OIDs are used, an object can be relocated by keeping a forwarding pointer to its new location. In case an object gets forwarded multiple times, what would be the effect on retrieval...

Define the term dangling pointer. Describe how the unique-id scheme helps in detecting dangling pointers in an object-oriented database.

Number of Hours Worked An economic researcher is collecting data about grocery store employees in a county. The data listed below represents a random sample of number of hours worked by 40 employees...

A factory manufactures two types of pipes made from different materials: Type A and Type B. Both types are expected to have a diameter of 675 millimetres. A sample of five pipes of each type is...

We wish to estimate what percent of adult residents in a certain county are parents. Out of 200 adult residents sampled, 112 had kids. Based on this, construct a 95% confidence interval for the...