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...
-
Reconsider Prob. 1440. Determine the required properties using EES (or other) software instead of the psychrometric chart. What would the property values be at a location at 1500 m altitude?
-
Mark each statement True or False. Justify each answer. Every subspace is a flat.
-
What makes a question bad? Develop three examples of bad questions. Rewrite your examples so they could be judged as good questions.
-
The employees of Black Cat Designs are paid on a semimonthly basis. Compute the FICA taxes for the employees for the November 30, 2015, payroll. All employees have been employed for the entire...
-
By increasing the areas of the zinc and copper plates in the Daniell cell, we can increase the amperage of the current flowing through the circuit without affecting the cell's voltage. (a) Why does...
-
Yolanda has the option of investing in two different mutual funds. The return in the random walk fund tends to fluctuate wildly, earning substantial positive returns one year only to realize negative...
-
Market Entry Plan: Strategy and Entry Mode As a business organization enters new foreign markets, decisions must be made regarding various organizational factors. In this module, your goal is to...
-
Scott placed a business auto in service on January 1, 2019 and drove it 4,000 miles for business (equally over the course of the year), 3,250 miles for commuting, and 4,500 miles for nonbusiness...
-
Meals and Entertainment expense includes $2,500 related to golf greens fees for entertaining clients, $1,000 for business meals provided by restaurants, and $900 for the bagels and doughnuts once a...
-
Look at the text below. If there is an error with subject-verb agreement, select the incorrect verb and type it correctly. Otherwise, submit the text without making any changes. Financial advisors...
-
Hi, what is the Total Marginal cost per CPT code for the below scenario? Calculate the costs Show your calculations Scenario : Assume that during the FY2016 year, Camden Health LLC historical costs...
-
GREENE CORPORATION Directions Read the scenario, then answer the question that follows. Scenario The Greene Corporation's historical scrap rate is 6% (units required over BOM units). Assuming the 6%...
-
Calculate the lower and upper limit 95% CI. In a matched case-control study or estrogen use and endometrial cancer: Controls Estrogen use + 17 10 Cases Estrogen use + Estrogen use - Estrogen use - 76...
-
Doorharmony Company makes doorbells. It has a weighted- average cost of capital of 5% and total assets of $ 5,900,000. Doorharmony has current liabilities of $ 750,000. Its operating income for the...
-
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,...
-
The percentage of heights between 148 centimeters and 170 centimeters
-
The percentage of heights between 159 centimeters and 165 centimeters
-
In this section, it was noted that the standard deviation of sample means is s/1n. In that expression, what does s represent and what does n represent?
Study smarter with the SolutionInn App