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

Question

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-5555,666-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?

Explanation / Answer

Employee Territories Use This function enables you to display all territories assigned to an employee. If a sales representative is assigned to several territories, you can set one of these territories as a default territory. If, for example, an activity or a campaign is entered in CRM Mobile for this employee, the default territory is automatically proposed. In CRM Enterprise, territory determination is used to propose a territory in a business transaction. For more information, see Territory Determination in the Business Transaction. Prerequisites Territories and territory hierarchies are maintained in CRM Enterprise. Features In CRM Enterprise you can specify

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.