Employeeld OfficeNumber EM32221 EM32222 EM32222 EM32221 OF004 OF003 OF004 OF003 Office Address 123 Glades Rd, Boca...

Transcribed Image Text:

Employeeld OfficeNumber EM32221 EM32222 EM32222 EM32221 OF004 OF003 OF004 OF003 Office Address 123 Glades Rd, Boca Raton, FL 456 University Rd, Davie, FL 123 Glades Rd, Boca Raton, FL 456 University Rd, Davie, FL Name Mary Jane Peter Parker Peter Parker Mary Jane 2.) Is this table in 1NF, and why? If not, transfer the table to INF. 3.) Is this table in 2NF, and why? If not, transfer the table to 2NF. Role Sales Supervisor Sales Associate Sales Associate Sales Supervisor HoursWorked 40 35 45 42 Employeeld OfficeNumber EM32221 EM32222 EM32222 EM32221 OF004 OF003 OF004 OF003 Office Address 123 Glades Rd, Boca Raton, FL 456 University Rd, Davie, FL 123 Glades Rd, Boca Raton, FL 456 University Rd, Davie, FL Name Mary Jane Peter Parker Peter Parker Mary Jane 2.) Is this table in 1NF, and why? If not, transfer the table to INF. 3.) Is this table in 2NF, and why? If not, transfer the table to 2NF. Role Sales Supervisor Sales Associate Sales Associate Sales Supervisor HoursWorked 40 35 45 42

Answer rating: 100% (QA)

Solution Yes this table is in 1NF because each cell contains only atomic values and there are no rep... View the full answer