databases lab 5

Overall: Individually, you will be modifying the lab from last week (Lab 4, bank lab) by examining the system your group turned in last week and evaluating it for integrity and security

1- Take your design and discuss about how you could better enforce referential integrity in terms of semantic data integrity. For this portion I would like an explanation.

2- Add three constraints of your choice (that make sense) in your system and explain WHY you have added those constraints. For this portion I would like code and an explanation

3- Write a trigger to meet a business need. For this portion I would like code and an explanation of why the trigger meets the business need.

4- Write a security plan based on the four areas we went over in class. For this portion I would like an explanation.

Please notice that you will be graded MORE on your explanations than the code itself

Make sure I have access to view your instance!

Deliverables:

Outlined above. Each section is worth 25 points. For each section, the explanation portion is worth 15 points with the code being worth 10 points.