Convert table to 3nf and represent answer in dbdl

Assignment Help Database Management System

Reference no: EM1363919

The table shown below lists sample dentist/patient appointment data. A patient is given an appointment at a specific time and date with a dentist located at a particular office. On each day of appointments, a dentist is allocated to a specific office for that day. (20 pts.)

Staff No Dentist Name Pat. No. Pat. Name Appointment Office
Date Time

S101 T. Smith P100 G. White 9/12 10:00 L15
S101 T. Smith P105 J. Bell 9/12 12:30 L15
A264 M. Sagaria P108 I. McKay 9/12 10:00 L10
A264 M. Sagaria P108 I. McKay 9/14 14:15 L10
V555 R. Plevin P105 J. Bell 9/14 16:30 L15
V555 R. Plevin P110 P. Wax 9/15 18:00 L13

A. Give examples of insertion, deletion and update anomalies with the above table.

B. Convert the table to 3NF. Represent your answer in DBDL. (i.e. Give table name and fields. Underline the primary key. Draw an entity-relationship diagram showing all relationships.)

Identify any assumptions you made that will assist in my understanding of your solution.

Reference no: EM1363919

Questions Cloud

Environment crisis or hype for the market : do you believe that there really is an environmental crisis or do you believe that there is "hype" to create demand and profits in certain markets?

What is the electric field vec e : What is the electric field vec E. What is force vec F on a -1.0 nC charge placed at the midpoint.

Informative and persuasive speeches : What are the differences between informative and persuasive speeches? Can an informative speech be persuasive? Can a persuasive speech be informative? Why or why not?

Policies causing problems for certain groups : Present one policy specifically targeted towards one group in society that created issues for other groups.

Convert table to 3nf and represent answer in dbdl : Convert the table to 3NF. Represent your answer in DBDL. (i.e. Give table name and fields. Underline the primary key. Draw an entity-relationship diagram showing all relationships.)

Difference between tax refund and tax benefit : What are the chances that a company will have 20 years of losses to actually use a loss carryforward (and still be in business)? How do accounting principles support holding an asset on the balance for this long?

Negotiation - coalitions and multiple parties : Compare and contrast the central route to influence vs. the peripheral route to influence. When is each appropriate? Give an example where you have seen or used each.

Find the magnitude of velocity of canoe relative to river : two students stand poised to leap off a high dive structure into teh swimming pool below. Student B is twice as massive as student A. Find the magnitude of velocity of canoe relative to river.

Role of financial manager in maximizing shareholder value : Discuss the role of the financial manager in maximizing shareholder value within today's financial markets and what would be the manager's viewpoint vs. an employee or stockholder viewpoint regarding maximizing share value?

User Account

All Pages