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

  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

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

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!