06.07.10 - 08.01.10
Business Rules, Views, and Integrity
Objective: To identify business rules, views, and to review database integrity
pastdue
Business rules are identified | 30 pts |
Validation tables are identified | 20 pts |
Views are identified | 30 pts |
Database has good integrity | 20 pts |
Total | 100 pts |
For this lab you will need to begin by identifying any business rules that exist within your database project. Record these rules and include it in the materials you turn in for this lab.
If your business rules involve the creation of any new validation tables, include them in your relationship diagram from the previous lab and resubmit it with this lab.
Next, you will need to identify any needed views for the project. Record these views in your relationship diagram and submit it with the materials for this lab.
Perform a final review of the integrity and design of your database and submit any changes that need to be made from previous labs.