Describe and illustrate the process of normalizing

Assignment Help Business Management
Reference no: EM131278557

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

Pat_Name

Appointment

Data               Time

Surgent_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

Gillian White

Jill Bell

Ian Mackay

Ian Mackay

Jill Bell

John Walker

12-Sep-08      10.00

12-Sep-08      12.00

12-Sep-08      10.00

14-Sep-08      14.00

14-Sep-08      16.30

15-Sep-08      18.00

S15

S15

S10

S10

S15

S13

Describe and illustrate the process of normalizing the above table to 3NF. State any assumptions you make about the data shown in this table.

Identify the functional dependencies represented by the attributes show in the 3NF tables.

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.

Draw a star schema diagram for the above data warehouse.

Reference no: EM131278557

Questions Cloud

Demonstrate knowledge of hydrograph analysis : To demonstrate knowledge and understanding of hydrograph analysis, water supply, distribution system and practical application of the rainfall measurement in hydrological studies.
Determine the flowrate and the velocity of the exiting jet : Determine the flowrate and the velocity of the exiting jet if the thrust is to be 300 lb. Neglect the momentum of the water entering the pump.
What costume design tells the viewer about that character : For this Journal Assignment *find an image or link of a play, film or television show *select one character and discuss what the costume design tells the viewer about that character, Remember, costumes involve more than actual attire (or lack there ..
Show transactions on the us balance of payments accounts : How each of the given transactions show up on the U.S. balance-of-payments accounts?- Payment of $50 million in Social Security to U.S. citizens living in Costa Rica.
Describe and illustrate the process of normalizing : Describe and illustrate the process of normalizing the above table to 3NF. State any assumptions you make about the data shown in this table. Identify the functional dependencies represented by the attributes show in the 3NF tables.
Describe the public image of your company : Write a paper that has two parts. Part 1 will explain public relations. Part 2 will describe the public image of your company. Use current articles (no more than 12 months old). Cite your sources. Your paper should be single spaced and approximate..
What new training programs and processes would you propose : As the HRD manager for your organization, what new training programs and processes would you propose to senior management to develop effective training and conflict resolutions methods.
Egg versus the egg of the surrogate : What are your thoughts on couples using family members to be the surrogate mothers? Does it make a difference if the couple is using their own fertilized egg versus the egg of the surrogate?
Set up the double entry accounts : Set up the double-entry accounts showing the appropriate debits and credits associated with the following transactions:

Reviews

Write a Review

 

Business Management Questions & Answers

  Manufacturer of snowmobiles

Sharon Inc., a manufacturer of snowmobiles has detected asbestos, a hazardous material, in the insulation of its factory. A complete strip and repair job will have to be done at a considerable cost.

  Present value of all three future benefits

Del Monty will receive the following payments at the end of the next three years: $12,000, $15,000, and $17,000. Then, from the end of the 4th through the end of the 10th year, he will receive an annuity of $18,000 per year. At a discount rate of ..

  Explain how the distribution strategy fits the product

Discuss whether a push or pull strategy will be used, justify your rationale. Explain how the distribution strategy fits the product / service, target market and overall marketing strategy for the corporation.

  How can you contribute to the success of the effort

How can you contribute to the success of the effort? How might you use critical success factors to identify important system requirements?

  Versification is a means to reduce risk

Versification is a means to reduce risk

  Calculate the present value of net benefits

Calculate the present value of net benefits assuming that the benefits are realized at the end of each of the three years.

  Describe an ethical dilemma that you faced in the workplace

Describe an ethical dilemma that you faced in the workplace and how you responded. Analyze whether your decision was economically, legally, and ethically responsible and defend your response.

  Different ways of enhancing country economy

What are the different ways of enhancing country's economy and please describe them.

  How can cheryl smith help managers at west

How can Cheryl Smith help managers at West

  The challenges of succession planning in turbulent times

The Challenges of Succession Planning in Turbulent Times

  What source of power does chris have

If you were the dean of SAS, knowing that the VP does not want to set a college wide policy, and Chris appealed to you, what would you do? Would you develop a school wide policy for SAS?

  Are people living in a relationship based governance system

Illustrate what is your opinion of Gap international's having code of conduct for its supplier? Illustrate what would Milton Friedman say? Contrast his view with Archie Carroll's view.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd