In this activity, you will evaluate a set of data requirements from the Ferguson and Bardell, Inc. case study to determine areas where possible data integrity issues might arise. You will then formulate a set of data integrity requirements that must be followed by the development team for the Ferguson and Bardell, Inc. solution. | Activity Identifying Data Integrity Requirements In this activity you will evaluate a set of data requirements from the Ferguson and Bardell Inc. case study to determine areas where possible data integrity issues might arise. You will then formulate a set of data integrity requirements that must be followed by the development team for the Ferguson and Bardell Inc. solution. Objectives After completing this activity you will be able to Identify areas where data integrity and validity are required. Specify data integrity requirements as they relate to data requirements. Before You Begin This activity will take place in small groups with a class discussion following each exercise. Prerequisites To complete this activity you will need the Data requirements generated in Activity . Existence and relationship requirements generated in Activity . Time to complete this activity 25 minutes 40 Activity Identifying Data Integrity Requirements Exercise 1 Determining Data Validity Requirements In this exercise you will identify data validity requirements for the Ferguson and Bardell Inc. case study. Identify data validity requirements 1. Join the group to which you have been assigned by the instructor. 2. With your group examine the physical data design on the next page. 3. Consider the data requirements specified in Activity . 4. Look for areas in the solution that depend upon data being in a certain format or within a range of values. These areas are data validity requirements. Your group should attempt to find five to seven data validity requirements. 5. Document each data validity requirement and its reason in the following table. Note There may be more rows in the table below than data validity requirements. Only fill in information that you find. i Data validity requirement Description Timesheet must report positive billable hours. Because a timesheet is a revenuegenerating document it must report a positive dollar amount. Invoice cannot bill for negative
