The process of identifying entities and attributes is the key to creating a logical data design. This activity provides a real-world example of use case requirements that you will analyze to identify entities and attributes. In each of the two exercises in this activity, you analyze a single aspect of a logical data design. At the end of each exercise, the class will discuss the design you derived. | Activity Deriving Entities and Attributes from Data Requirements The process of identifying entities and attributes is the key to creating a logical data design. This activity provides a real-world example of use case requirements that you will analyze to identify entities and attributes. In each of the two exercises in this activity you analyze a single aspect of a logical data design. At the end of each exercise the class will discuss the design you derived. Objectives After completing this activity you will be able to Identify and derive data entities from use cases. Identify attributes of the derived data entities. Before You Begin This activity will take place in small groups with a class discussion following each exercise. To complete this activity each group will need a flip chart and markers. Prerequisites To complete this activity you need the data requirements generated in the activities of Module 3. Time to complete this activity 25 minutes 14 Activity Deriving Entities and Attributes from Data Requirements Exercise 1 Identifying Data Entities In this exercise you will identify data entities from a set of use cases data requirements and scenarios. Identify data entities 10 minutes 1. Refer to the data requirements generated in Activity . 2. Review the following relationships. If necessary review the case study in the Appendix for additional information. Consultants contract with particular clients clients can have more than one consultant working for them. Consultants complete timesheets for hours worked at a client s site billable hours and hours spent on administrative tasks nonbillable hours . For purposes of this exercise assume that each timesheet is for one client only. Consultants must bill their time to an appropriate job and supply a valid task description along with any expenses incurred that need to be billed back to the client. Managers must approve completed timesheets. Administrative assistants create invoices from the .
