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

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 particular surgery. On each day of patient appointments, a dentist is allocated to a specific surgery for that day. Staff_No Dentist_Name Pat_No S1011 S1011 S1024 S1024 S1032 S1032 Tony Smith Tony Smith Helen Pearson Helen Pearson Robin Plevin Robin Plevin P100 P105 P108 P108 P105 P110 Pat_Name Appointment Data Gillian White 12-Sep-08 Jill Bell 12-Sep-08 Ian Mackay 12-Sep-08 Ian Mackay 14-Sep-08 Jill Bell 14-Sep-08 John Walker 15-Sep-08 Surgent_No Time 10.00 12.00 10.00 14.00 16.30 18.00 S15 S15 S10 S10 S15 S13 a) Describe and illustrate the process of normalizing the above table to 3NF. State any assumptions you make about the data shown in this table. b) Identify the functional dependencies represented by the attributes show in the 3NF tables. 2- Suppose that a data warehouse consists of the three dimensions time, doctor, and patient, and the two measures count and charge, where charge is the fee that a doctor charges a patient for a visit. a) Draw a star schema diagram for the above data warehouse. 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 General Management Questions!

The table shown in Table 3 lists dentist / patient appointment data. A patient is given an appointment at a specific time and date with a dentist located at a particular surgery. On each day of...

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...

The table shown in Figure 14.19 lists dentist/patient appointment data. A patient is given an appointment at a specific time and date with a dentist located at a particular surgery. On each day of...

The table shown in Figure 1 4 . 1 9 ( below ) lists dentist / patient appointment data. A patient is given an appointment at a specific time and date with a dentist located at a particular surgery....

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...

QUESTION 3 Table 5 lists patient appointment data with the dentists. A patient is given an appointment with a dentist at a specific time, date and a surgery room. On each day of patients'...

Description: The table shown in Figure 1 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 surgery....

Submitted to Management Science manuscript MS-0001-1922.65 Authors are encouraged to submit new papers to INFORMS journals by means of a style file template, which includes the journal title....

Does traditional theory correspond to parent-company or entity theory in matters related to unrealized and constructive gains and losses on intercompany transactions?

For each of the following situations indicating heightened fraud risk, discuss how a professionally skeptical auditor might interpret the situation. a. The company is not as profitable as its...

When executives are desperate to avoid a takeover, they may be forced to swallow a This involves making the firm's stock unattractive to raiders by letting shareholders buy stock at a discount

WHAT IS the cash flow statement BBINFIT ,AND HOW WE CAN ANALAYSES

7. U.S. pharmaceutical companies charge different prices for prescription drugs to buyers in different nations, depending on elasticity of demand and government-imposed price ceilings. Explain why...

3. Use the following demand schedule to calculate total revenue and marginal revenue at each quantity. Plot the demand, totalrevenue, and marginal-revenue curves, and explain the relationships...

5. Critically evaluate and explain each statement: LO12.5 a. Because they can control product price, monopolists are always assured of profitable production by simply charging the highest price...