Question: Translating some statements to database tables and apply the requirements below. I need help defining: primary keys , eliminate duplicate data , eliminate unnecessary dependancies
Translating some statements to database tables and apply the requirements below.
I need help defining: primary keys, eliminate duplicate data, eliminate unnecessary dependancies and apply 3 rules of normalization 1NF - 2 NF - 3NF for the following statements:
-Each statement is a different, unrelated and independent table
- Given a Table named “Sales”, where the following data is stored: sale_id, customer_name, customer_address, product_id, product_description, sold_amount, product_unit_price. Apply the 3 rules of normalization 1NF - 2 NF - 3NF.
- Given a Table named “Employees”, where the following data is stored: employee_id, employee_name, department, work_role, employee_boss_name.
- Given a Table named “Invoices”, where the following data is stored: invoice_number, date, customer, customer_address, customer_city, product_id, product_description, amount, product_unit_price.
- Given a Table named “Students” where the following data is stored: student_id, student_name, birth_date, course_name, course_score, teachers_name.
- Given a Table name “Projects” where the following data is stored: project_id, project_name, project_description, department, name_of_person_responsible, salary_of_person_responsible
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Lets analyze each statement and apply the rules of normalization Statement 1 Sales Primary Key Choose saleid as the primary key Eliminate Duplicate Data No specific information on duplicate data but t... View full answer
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
