tailieunhanh - Activity 7.2: Determining Data Integrity Implementations

In this activity, you will evaluate a physical design for the Ferguson and Bardell, Inc. case study and then determine areas within the physical design where data integrity requirements and business rules should be implemented with the methods presented in Module 7, Implementing Data Integrity. | Activity Determining Data Integrity Implementations In this activity you will evaluate a physical design for the Ferguson and Bardell Inc. case study and then determine areas within the physical design where data integrity requirements and business rules should be implemented with the methods presented in Module 7 Implementing Data Integrity. Objectives After completing this activity you will be able to Identify areas where data integrity should be enforced. Choose a method for implementing business rules and data integrity requirements. Before You Begin This activity will take place in small groups with a class discussion following the activity. Prerequisite To complete this activity you will need the Completion of Activity . Time to complete this activity 30 minutes 44 Activity Determining Data Integrity Implementations Exercise 1 Determining Integrity Implementations In this exercise you will examine the physical design provided determine areas in the design where data integrity should be enforced and determine how it should be enforced. Identify areas where data integrity should be enforced 1. Join the group to which the instructor assigned you. 2. With your group study the physical data design on the next page. 3. Based on the business rules and data integrity requirements specified in Activity identify how the data integrity requirement can be implemented for each rule in the following table. 4. Supply a reason for each answer in the table. Data integrity rule Implementation Description Timesheet must contain an existing employee client job and task. Contract cannot exist without a valid employee and client relation. Each job entry must have an associated task assignment. Job cannot be created without a default task. Valid date must be specified for each timesheet and for each time entry that a consultant makes. All consultants expenses must be formatted correctly and they must be a positive amount. Employee billing rate must be updated. When .