Assignment:
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