Convert an erd to a relational schemacovert the extended

Assignment Help Database Management System

Reference no: EM13380316

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

Questions Cloud

The aim of this project is to design developand evaluate a : the aim of this project is to design developand evaluate a 2d game for pc. you can choose any type of game you like

Nbspa stack evaluating the postfix expression lrm using : nbspa stack evaluating the postfix expression lrm using linked list implementationthis step will use the queue

An infix expression is one in which operators are located : an infix expression is one in which operators are located between their operands. this is how we are accustomed to

Design an improved interactive password system present your : design an improved interactive password system? present your design and describe what kind of attacks your protocol can

Convert an erd to a relational schemacovert the extended : convert an erd to a relational schemacovert the extended entity relationship diagram eerd for orthopedic alliance of

Since you have created the data objects for harbor view : since you have created the data objects for harbor view mooring you now need to create processes associated with each

Worldwide advertising inc referred to as wai has hired you : worldwide advertising inc. referred to as wai has hired you as an it consultant for implementing their windows network

1nbspunder the von neumann architecture a program and its : 1.nbspunder the von neumann architecture a program and its data are both stored in memory. it is therefore possible for

Question you have been asked to install an svn repository : question you have been asked to install an svn repository on a server. the svn will be remotely accessed using the

User Account

All Pages