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

1. 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.
2. Given a Table named “Employees”, where the following data is stored: employee_id, employee_name, department, work_role, employee_boss_name.
3. 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.
4. Given a Table named “Students” where the following data is stored: student_id, student_name, birth_date, course_name, course_score, teachers_name.
5. 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

Answer rating: 100% (QA)

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 the full answer