What are the special guidelines for naming

This preview shows page 7 - 11 out of 11 pages.

7.What are the special guidelines for naming relationships?
RUNNINGHEAD: IST 7000 DATA MANAGEMENT WEK 2 ASSIGNMENTSnot Assignment). The name states the essence of the interaction between the participating entity types, not the process involved (e.g., uses an Employee is Assigned To a project, not an Employee is Assigning a project).oYou should avoid vague names, such as Has or Is Related To. Use descriptive, powerful verb phrases, often taken from the action verbs found in the definition ofthe relationship.8.There is a bulleted list associated with Figure 2-22 that describes the entities and their relationships in Pine Valley Furniture. For each of the 10 points in the list, identify the subset of Figure 2-22 described by that point. Entities PRODUCT, PRODUCT_LINE; relationship Includes Entities CUSTOMER, ORDER; relationship Submits Entities ORDER, PRODUCT; associative entity Order_Line Entities CUSTOMER, SALES_TERRITORY; associative entity Does_business_in Entities SALESPERSON, SALES_TERRITORY; relationship Serves Entities PRODUCT, RAW_MATERIAL; relationship Uses Entities RAW_MATERIAL, VENDOR; relationship Supplies Entities WORK_CENTER, PRODUCT; associative entity Produces_In Entities EMPLOYEE, WORK_CENTER; associative entity Works_In Entity EMPLOYEE; relationship Supervises, Is_supervised_by
RUNNINGHEAD: IST 7000 DATA MANAGEMENT WEK 2 ASSIGNMENTS9.Because Visio does not explicitly show associative entities, it is not clear in Figure 2-22 which entity types are associative. List the associative entities in this figure. Why are there so many associative entities in Figure 2-22?
RUNNINGHEAD: IST 7000 DATA MANAGEMENT WEK 2 ASSIGNMENTS

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture