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 surgery S1011 S1011 S1024 S1024 S1032 S1032 James Bond James Bond Andrew Joe Andrew Joe Kevin King Kevin King P100 P105 P108 P108 P107 P110 Kim Su Jenny Gold Ian Chappell 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 S10 S15 S13 Required 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 Is the table in 1NF, 2NF, or 3NF If not, describe and illustrate the process of normalizing it to 3NF Show final tables with data after normalization

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

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

surgery

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

Required

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.

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

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

Show final tables with data after normalization.

Step by Step Solution

★★★★★

3.44 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

First Normal Form A table is said to be in First normal form if it contains unique value attribute T... 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

Students Have Also Explored These Related Computer Engineering Questions!

A coin on a table is given an initial horizontal velocity such that it ultimately leaves the end of the table and hits the floor. At the instant the coin leaves the end of the table, a ball is...

A block is given an initial velocity of 5.00 m/s up a frictionless 20.0° incline (Fig. P5.22). How far up the incline does the block slide before coming to rest? Figure P5.22

A carton is given an initial speed of 3.0m/s up the 22.0o Plane shown in Fig, 4-55. (a) How far up the plane will it go? (b) How much time elapses before it returns to its starting point? Ignore...

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

Fall_2016 INSS650 Assignment 4 1- Consider the following table which lists dentist/patient appointment data. A patient is given an appointment at a specific time and date with a dentist located at a...

Consider the following relation: CLASS- LIST (COURSE#, CLASS- ROOM, STUDENT#, STUDENT- MAJOR) a. Assuming that each student can have only one major is this relation normalized? If so, is it in first,...

Given the following relational DB Schema Employee (empNo, fName, lName, address, DOB, sex, position, deptNo) Department (depNo, depName, mgrempNo) Project (prjNo, prjName, deptNo) WorksOn (empNo,...

Consider the schemas for the table people, and the tables students and teachers, which were created under people, in Section 9.3.Give a relational schema in third normal form that represents the same...

How can the yield curve and duration help an investments officer choose which securities to acquire or sell?

Cora Manufacturing makes fashion products and competes on the basis of quality and leading-edge designs. The company has $2,500,000 invested in assets in its clothing-manufacturing division. The...

Explain how to establish task dependencies and identify critical paths in project scheduling software, including how to resolve scheduling conflicts.

Phil, a cash-basis taxpayer, sells the following marketable securities, which are capital assets during 2015. Determine whether the gains or losses are long-term or short-term. Also determine the net...

What is the first day that an individual could sell a capital asset purchased on March 31, 2015 and have a holding period of more than one year?

Alert Security Services Co. offers security services to business clients. Complete the following end-of-period spreadsheet for Alert Security Services Co.: Alert Security Services Co. End-of-Period...

How does a lessor treat payments received for canceling a lease?

When is the transferor of a franchise unable to treat the transfer as a sale or an exchange of a capital asset?

How Product Reviews and Ratings Influence Consumer Purchase Intentions on E-Commerce Platforms

You have just been brought in to manage a portfolio of several specialty clinics in a large multi-physician group practice that is part of the newly formed academic medical center, ECU Pirate...

Instructions The information in the module is taken from a pilot study that assessed the validity and reliability of using a self-lavaging device for cytology and HPV testing for cervical cancer...

The table shown below lists the time spent by the staff working at different branches of the restaurant. The National Insurance Number (NIN) is unique for employee contractNo hourper Week eName NIN...

xx AD Alice AcDc Acid Stes 3. An agency called Instant Cover supplies part-time/temporary staff to hotels within Scotland. The table shown below lists the time spent by agency staff working at...

help please Answer by True OR False * True False To delete a table we use: delete table tableName. The default behaviour of the ORDER BY clause is to order tuples in the Descending order...

III - Normalization - The table shown below lists information about software and the companies that developed these software. The Software D is unique for each Software. (30 points) SOFTWAREID...