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

 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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!