Answer the following questions. a) State the normal form of the above table. Explain your answer...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Answer the following questions. a) State the normal form of the above table. Explain your answer with reasons. (3 marks) b) Convert the table into a relational schema. Identify the primary key(s) and partial dependencies and/or transitive dependencies. (6 marks) c) Normalize the relational schema in (b) until third normal form (3NF). Show all your work. Table 2: ORDER DATA Table Customer Order ID Order Date Customer Menu Name Quantity Phone Name Staff ID and Name Number Fish 012- 11 30/06/2022 2 William 301 Willy Burger 34567899 012- 11 30/06/2022 Benjo 2 William 301 - Willy 34567899 Chicken 012- 12 30/06/2022 1 Andrew 302 Wendy Burger 1122334 Mutton 012- 13 07/08/2022 Kebab 1 Zach 301 Willy 5555555 Burger Chicken Double 012- 13 07/08/2022 3 Zach 301 Willy Cheese 5555555 Burger Answer the following questions. a) State the normal form of the above table. Explain your answer with reasons. (3 marks) b) Convert the table into a relational schema. Identify the primary key(s) and partial dependencies and/or transitive dependencies. (6 marks) c) Normalize the relational schema in (b) until third normal form (3NF). Show all your work. Table 2: ORDER DATA Table Customer Order ID Order Date Customer Menu Name Quantity Phone Name Staff ID and Name Number Fish 012- 11 30/06/2022 2 William 301 Willy Burger 34567899 012- 11 30/06/2022 Benjo 2 William 301 - Willy 34567899 Chicken 012- 12 30/06/2022 1 Andrew 302 Wendy Burger 1122334 Mutton 012- 13 07/08/2022 Kebab 1 Zach 301 Willy 5555555 Burger Chicken Double 012- 13 07/08/2022 3 Zach 301 Willy Cheese 5555555 Burger
Expert Answer:
Answer rating: 100% (QA)
a The given table is not in 1NF as all the attributes are not atomic The attribute Staff ID and Name ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these programming questions
-
This is JavaScript. Plz only do it if you know it. Createe a class called Residence which can be aggregated into the class Employee Residence streetName: String cityName: String zipCode: String...
-
Answer the following questions based on the information presented for Cloud 9 in Appendix B of this book and in the current and earlier chapters. You should also consider your answers to the case...
-
Introduction This research paper mainly focuses on history of evolvement of normalization from a set of relation schemas, along with sequential normalization forms with suitable examples. This paper...
-
2. The long-term loan from World Bank had been taken out on 1 April 2018 to fund the company. According to the loan agreement, five annual installments of R36 000 are to be paid each year commencing...
-
To foster teamwork and a culture of quality improvement, a new director of an ambulatory care center in a hospital has begun holding twice monthly management team meetings, consisting of several...
-
Jack Fuller estimates that the break-even point for EM5, a standard electrical motor, is 500 motors. For any motor that is not sold, there is an opportunity loss of $15. The average sales have been...
-
The sudden bursting of a cycle tyre is an (a) Isothermal process (b) Isochoric process (c) Isobaric process (d) Adiabatic process.
-
The Reliance Manufacturing Company produces an aircraft part. The company can produce the part entirely at a flexible work center with multiple computerized machines. The company has four work...
-
On January 1, Wei Company begins the accounting period with a $44,000 credit balance in Allowance for Doubtful Accounts. a. On February 1, the company determined that $9,600 in customer accounts was...
-
1. Which pricing tactics does each company utilize? Evaluate the effectiveness of each one of these tactics for the particular pizza chain. 2. How might the current price wars change the pricing...
-
Dr. D. wants to prevent addiction in his patients. Mr. Bondman decides to completely block a neurotransmitter that should reduce or eliminate the chances of Bongman developing addictions. Dr. D....
-
Giving customers what they want, Starburst candy will produce limited edition bags of All Pink a. Does the news clip imply that Starbursts goal is customer satisfaction and not profit maximization?...
-
A Personal Care Study conducted by TABS Analytics shows that Walmart has a 19.4 percent share of the $40 billion personal care market, while grocery stores Kroger and Publix have a 16.6 percent...
-
Biofuels to combat global warming and cut carbon emissions are diverting corn from food to fuel, and a World Resources Institute report says meeting a 20 percent bioenergy target in 2050 would need...
-
Describe the link between web site design and supporting customers through stages of the buying process.
-
Chinese exports of pharmaceutical products and health supplements worldwide jumped 3 percent to $56 billion last year. Chinese pharma exports to the U.S. rose 4 percent. Questions are being asked in...
-
Which of the following is not a section of the Institute of Internal Auditors? International Standards for the Professional Practice of Internal Auditing? Performance Standards. Independence...
-
Catherine (aged 42) and Johnson (aged 45) have been married for 12 years. Johnson is a project manager of an event company at a monthly salary of $55,000 with an additional one-month salary of...
-
Clifford Johnson has a limited partnership investment and a rental condominium. Clifford actively manages the rental condominium. During 2012, his share of the loss from the limited partnership was...
-
Mike sells his home to Jane on April 2, 2012. Jane pays the property taxes covering the full calendar year in October, which amount to $2,500. How much may Mike and Jane each deduct for property...
-
Laura is a single taxpayer living in New Jersey with adjusted gross income for the 2012 tax year of $35,550. Laura's employer withheld $3,300 in state income tax from her salary. In April of 2012,...
-
Pegasus Veterinary Hospital (PVH) is a partnership of five veterinarian surgeons who specialize in treating horses. PVH is located in a $25 million facility on 20 acres of land, employing over 40...
-
A tender evaluation method specifies 60% price and 40% quality. What is the weighted score of a tender that scored 80 points (out of 100) for price and 60 for quality?
-
You are a recently appointed purchasing manager who is overseeing terms and con- ditions of contract for an important international purchase with a UN country. What rules should you be particularly...
Study smarter with the SolutionInn App