Show final tables with data after normalization

Assignment Help Other Subject

Reference no: EM131453557

Question: The table shown below lists dentist-patient appointment data. A patient is given an appointment at a specific time and date with a dentist. On each day of patient appointments, a dentist will perform specific surgery (such as Implant S10, Root Canal S15) for that day.

StaffNo

Dentist Name

PatNo

PatName

Appointment Date & Time

SurgeryNo

S1011

S1024

S1032

James Bond

Andrew Joe

Kevin King

P100

P105

P108

P107

P110

Kim Su

Jenny Gold

Ian Chappell

John Spooner

Frank Holey

1/9/05 10.00

1/9/05 12.00

1/9/05 10.00

2/7/05 14.00

2/7/05 16.30

2/7/05 18.00

S10

S15

S10

S15

S13

Evaluate if the table shown above is normalized, if not describe and illustrate the process of normalizing the table shown above to third normal form. State any assumptions you make about the data shown in this table.

1. Is the table in 1NF, 2NF, or 3NF?

2. If not, describe and illustrate the process of normalizing it to 3NF.

3. Show final tables with data after normalization.

Reference no: EM131453557

Questions Cloud

Discuss about the case : focused ear exam : When you ask him how he's been spending his summer, James responds that he's been spending a lot of time in the pool.

Report of marketing fundamentals about grilled.com : Prepare a report of Marketing fundamentals - In these we got three sections each should be of 800 words or above and 4th section conclusion can be less words.

Using the profitability index when evaluating projects : Gold Mining, Inc. is using the profitability index (PI) when evaluating projects.

Calculate financial ratios : Spread 3 years of financials for the company using Excel. Do actual fiscal year-ends, not estimated.

Show final tables with data after normalization : The table shown below lists dentist-patient appointment data. A patient is given an appointment at a specific time and date with a dentist

What is the effective annual percentage rate : You put your money in a passbook savings account in which the interest rate is 4.2% per year compounded daily. What is the effective annual percentage rate?

Artistic engineer or an articulate organizer : By using your two to three word statements that are your tagline and brand, create a 30-second elevator speech (pitch) where you will sell your most valuable.

How does telemedicine differ from the traditional medicine : How does telemedicine differ from the traditional medicine?What are other legal or ethical issues involved in telemedicine?

What are some response activities that organizations use : Discuss some major factors. What are some response activities that organizations use? What about these specific activities is beneficial to the organizations?

User Account

All Pages