Illustrate the process of normalizing

Assignment Help Business Management
Reference no: EM131276970

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

Questions Cloud

Determine the number of pounds of helium within it : The helium-filled blimp shown in Fig. P1.52 is used at various athletic events. Determine the number of pounds of helium within it if its volume is 68,000 ft3 and the temperature and pressure are 80 °F and 14.2 psia, respectively.
What opportunities will the migration to an ehr : Discuss the challenges of privacy and confidentiality within the history and evolution of public health informatics - what opportunities will the migration to an EHR and the implementation of a RHIO provide to address these challenges?
Application-facilitating strategy formulation : Strategic planning involves a variety of intrapersonal and interpersonal skills, and each phase of the process may require different approaches in order to be successful. This Application Assignment asks you to consider what the most critical skil..
Why the phrase specific problem is important : Explain why the phrase "specific problem" is important to the definition of marketing research and how this phrase relates to justifying the existence of marketing research in the MIS.
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.
Determine the gage pressure of the gas : The density of oxygen contained in a tank is 2.0 kg/m3 when the temperature is 25 °C. Determine the gage pressure of the gas if the atmospheric pressure is 97 kPa.
Which components would you suggest larry anderson use : Explain why you think Larry Anderson should look into doing marketing research or not doing marketing research?- Think about the components of a marketing information system.
Fertilized 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?
How much does the water in the cloud weigh in pounds : Clouds can weigh thousands of pounds due to their liquid water content. Often this content is measured in grams per cubic meter (g/m3 ). Assume that a cumulus cloud occupies a volume of one cubic kilometer, and its liquid water content is 0.2 g/m3 .

Reviews

Write a Review

Business Management Questions & Answers

  Discuss the critical management issues

Discuss the critical management issues that strategy-making brings into play

  Find an example of a leader in the public sector

Find an example of a leader in the public sector who successfully issued strategic leadership principles to effectively lead an organization as well as a example of a leader in the public sector who did not use strategic leadership principles and ..

  Clearly defining a scope

Clearly defining a scope - Why is it important for a project to have a clearly defined scope statement all parties agree with?

  Model can serve as a basis for tourism policies and planning

Using relevant example to illustrate your arguments, critically analyze the different stages of the Tourist Area Life Cycle. Discuss how the model can serve as a basis for tourism policies and planning.

  Question about public speakingcreate a six sentence speech

question about public speakingcreate a six sentence speech on eating healthy using the principles of a good persuasive

  Business failure analysis for blockbuster

Describe the role of leadership, management, organizational structure, and the culture of the organization and its departments in the failure and success of the businesses.

  Important aspects of company financial health

From the e-Activity, choose at least three (3) key ratios that, in your opinion, reflect the most important aspects of the chosen company's financial health. Provide a rationale for your opinion.

  How management role differs from working side-by-side

Explain how the management role differs from working side-by-side with the same people in a production role and how could Joe's episode have been avoided?

  Probability that the program is implemented

a. What is the probability that the program is implemented when p = .80? b. What is the probability that the program is not im- plemented if p = .70? if p = .60?

  Production and operations management

What is sub optimization and why it is a concern of Production and Operations Management?

  Describe the basic principles of ethical philosophy

Describe the basic principles of ethical philosophy as they relate to business ethics. What factors do you think are responsible for Africa's slow economic development? What can the multinationals do to help?

  Discuss the importance of legal compliance

1. Discuss the importance of legal compliance with federal employment laws and regulations as well as ethical issues that govern appraisals and performance management. Provide examples. (Your response should be at least 75 words in length.)

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