Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started