Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Investigate the following table recording the information of Adidas sales data and answer the following questions. Question 1 [6 marks] Will this table satisfy 1NF,
Investigate the following table recording the information of Adidas sales data and answer the following questions. Question 1 [6 marks] Will this table satisfy 1NF, 2NF, and 3NF? Explain why. Give examples for insertion anomaly, deletion anomaly and update anomaly that may happen when using this table to record data. Using https://erdplus.com, let's redesign it into two or more tables in the third normal form. You are asked to: a) Present your entity-relationship diagram (ERD). b) Present the generated relational schema. The primary key and possible foreign keys of each table should be shown. c) Present the generated SQL statements to create the tables with the appropriate data type set for each attribute
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