Draw dependency diagram after identifying all dependencies

Assignment Help Database Management System

Reference no: EM13192062

Convert an ERD to a relational schema

Covert the Extended Entity Relationship Diagram (EERD) for Orthopedic Alliance of Plano (OAP) described in assignment one to relations. See Lecture 5, slide 22 for relational schema.

637_Convert an ERD to a relational schema.png

Hint: Identify the foreign keys for referential integrity constraints. For example, use Nurse ID and Physician ID for the subtypes. "Interaction" relation will have a composite primary key with two attributes, both taken from the primary key of the "Drug" relation. "Offers" relation will also have a composite primary key.

Part II Data Normalization

Consider the following data structure

GRADEREPORT (Student ID, Student Name, Major, Course ID, Course Title, Instructor ID, Instructor Name, Grade)

Some clarifications:

1. Student ID is a unique identifier for student and serves as the determinant for Student Name and Major.

2. Course ID is a unique identifier for a specific section of a course and serves as the determinant for Course Title, Instructor ID and Instructor Name.

3. Instructor ID is a unique identifier for instructor and serves as the determinant for Instructor Name.

Answer the following questions:

a. In what normal form is this data structure? Justify your answer.

b. Draw the dependency diagram after identifying all dependencies in this data structure. See Lecture 6, Slide 27 for dependency diagram.

c. Convert this data structure to a set of 3NF relations. Clearly showing each step

Reference no: EM13192062

Questions Cloud

Changing out complete battery systems : There is a company from Isreal that is changing out complete battery systems for taxis in New York. Do you think this idea will work? They make the change in under 60 seconds.

Define one pipline what is the final equilibriume pressure : the second one volume is 60 and pressure 658psia we want to join them togother in one pipline what is the final equilibriume pressure?

Injured worker for medical care : When a injury is at mmi, and years later causes new impairments is workers compansation liable to injured worker for medical care?

Find an ad-valorem tax that would generate revenues : In a competitive market, the industry demand and supply curves are P=200-0.2×Qd and P=100+0.3×Qs, respectively. Can you find an ad-valorem tax that would generate $3200 of revenues for the government

Draw dependency diagram after identifying all dependencies : Draw the dependency diagram after identifying all dependencies in this data structure. See Lecture 6, Slide 27 for dependency diagram and convert this data structure to a set of 3NF relations. Clearly showing each step

Define what is the final temperature of the water : What is the final temperature of the water when equilibrium is reached? (Assume a density of 0.998 (g/mL) for water.)

What is the elasticity of demand over the range : Price Quantity demanded $200 1000 150 1400 100 1800 a. If price falls from $200 to $150, what is the elasticity of demand over this range b. As output increases from 1,000 to 1,400 what is marginal revenue

Define enthalpy delta h of the formation of liquid water : Find the enthalpy delta H of the formation of liquid water in the standard state. g) Find the value U of the molar internal energy of water at standard conditions.

By what percent did gdp decline : According to the News on page 159, (a) By what percent did GDP decline (b) How much output was lost in the $14 trillion economy (c) How much income did this represent for each of the 300 million U.S. citizens

User Account

All Pages