Create a new relation in the normalisation process

Assignment Help Database Management System

Reference no: EM133055137

Learning Activity: Normalization I

The following relation has been created to store data resulting from a survey conducted at hospitals on what drugs were administered after operations.

OPERATION

Hospital Number

Operation Number

Hospital Name

Hospital Type

Teaching Status

Contact Person

Operation Name

Operation Code

Procedure Group

Surgeon Number

Surgeon Specialty

Drug Name 1

Manufacturer 1

Size of Dose 1

Unit Of Measure 1

Method of Administration 1

Cost of Dose 1

Number of Doses 1

Drug Name 2

Manufacturer 2

Size of Dose 2

Unit Of Measure 2

Method of Administration 2

Cost of Dose 2

Number of Doses 2

Drug Name 3

Manufacturer 3

Size of Dose 3

Unit Of Measure 3

Method of Administration 3

Cost of Dose 3

Number of Doses 3

Operation numbers are assigned sequentially be each hospital.

Hospital Type was "P" Public and "V" for Private.

The Teaching Status field indicated whether or not the hospital was a teaching hospital.

Normalise this relation to third normal form. Whenever you create a new relation in the normalisation process, describe the reason that it was required.

Reference no: EM133055137

Questions Cloud

How much shall be the provision for liability : Milder Company has guaranteed a loan of P300,000 granted to Miller Company. How much shall be the provision for liability

Learning activity - normalization : Describe the reason that it was required. What type of anomaly is avoided with the new relation?

What affects the decision-making process : After watching the video, how do you describe the process of the decision-making process, and what affects the decision-making process?

Organization business-level strategy : Are you aware of your organization's business-level strategy? What do you do to help your firm either increase differentiation or lower costs?

Create a new relation in the normalisation process : Whenever you create a new relation in the normalisation process, describe the reason that it was required - The Teaching Status field indicated

Describe four elements of governance objectives : Describe roles and responsibilities of governance. Describe four elements of governance objectives.

What is the federal Tax Payable for St John Corporation : St. John Corporation, a Canadian controlled private corporation has Taxable Income of $250,000 in 2019, What is the federal Tax Payable for St John Corporation

Organizational structure affects innovation : Gore's Flat Structure Works Well Imagine an organization with more than 10,000 employees working in 30 countries around the world-with no hierarchy structure.

Determine the net present value of taking the investment : The new asset has 5 years of estimated useful life. Determine the net present value of taking the investment if the effective interest is 8 %

User Account

All Pages