4. What kind of entity is EmployeeTerritories? 5. Without the entity Employe

4. What kind of entity is EmployeeTerritories?

5. Without the entity EmployeeTerritories what would the relationship between Employees and Territories be?

6. Notice the Employees entity has a relationship with itself. What is that relationship called?

7. Why does Employees have this relationship?

8. Suppose the database has been deployed and has been in use for a few months. It has been

discovered that because each shipper may have multiple phone numbers that the programmers

have been using a comma-delimited list for the phone column. For example if a shipper has

two phone numbers 555-5555 and 666-6666 the field in the phone column would be

%u201C555-5555666-6666%u201D. What normal form is the Shippers table in? Possible answers are

unnormalized 1NF 2NF and 3NF.

9. After learning about the issue another systems analyst suggests modifying the data type on the

phone column to only be able to store one phone number. Then a shipper with two phone

numbers will have two rows in the table where only the phone numbers differ. Is this a good

solution? Why/why not?

12. If the attribute IsGift were added to Order Details to indicate if the order was a gift or not what would the normalized form of Order Details
be?

13. A programmer argues that for performance reasons the Discontinued attribute from the

Products entity needs to be added to the Order Details entity while still keeping the

Discontinued attribute in Products. On page 234 in your book there are three criteria for a

good data model. Which one does this most violate?

14. In the previous scenario what normalized form will the Order Details be in if Discontinued is added to Order Details? Why?

15. Another programmer says that it would be helpful to have a CountryCode attribute added to the Employees entity to indicate the country code of a
phone number. If this change was made what would the normalized form of the Employees entity be? Why?

16. Another suggestion is for a DaysAtJob attribute to be added to the Employees table. It will be updated daily and calculated by taking the current
date and subtracting the HireDate. If this

change was made what would the normalized form of the Employees table be? Why?