Fall 2017

Lab06
Business Rules, Views, and Integrity

Due: Monday November 14, 2016 11:59 PM

Lab06 - Business Rules, Views, and Integrity

Requirements

Business rules are identified30 pts
Validation tables are identified20 pts
Views are identified30 pts
Database has good integrity20 pts
Total100 pts

Resources

Objective

To identify business rules, views, and to review database integrity

Instructions

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.