Threesuns

Email

Contact

All Semesters

Semesters

All Courses

Courses

Database Design

CSYS2643

3 credits

Labs

Business Rules, Views, and Integrity

Lab

100 points

Requirements

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

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.