I need Database Expert IT

integrity and security homework see the Lab 5 file.

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.