Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Questions 1-7 will all deal with normalizing a table based on the following information. You have been asked to review a database design for an

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribedimage text in transcribed

image text in transcribed

Questions 1-7 will all deal with normalizing a table based on the following information. You have been asked to review a database design for an organization that has been having problems with data quality. Upon inspecting the database, you see a single Orders table: OrderLineltems(Orderld, OrderLine, EmpEmail, Phone, Productld, FirstName, LastName, ProdName, Quantity, UnitPrice, Discountl, Discount2, Discount3, DatePlaced, SalesChannel) Discussion with a subject matter expert reveals the following functional dependencies Orderld, OrderLine> any other attribute in the table, but perhaps transitively OrderId DatePlaced Orderld SalesChannel EmpEmail FirstName EmpEmail LastName EmpEmailPhone ProductldProdName Productld UnitPrice The subject matter expert tells you that the discount attributes represent places to record discounts that can be applied to the line items in an order. There can be multiple discounts applied to each line item, with no maximum number of discounts, and many line items won't have any discounts at all. Also, it doesn't really matter whether a given discount gets recorded in Discount1, Discount2, or Discount3, as they all mean the same thing 1. What is the highest normal form satisfied by the OrderLineltems table as it is depicted above? a) First Normal Form b) Second Normal Form c) Third Normal Form d) This table does not meet the criteria of any of the normal forms

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook Of Database Security Applications And Trends

Authors: Michael Gertz, Sushil Jajodia

1st Edition

1441943056, 978-1441943057

More Books

Students also viewed these Databases questions

Question

10. What is meant by a feed rate?

Answered: 1 week ago