Assignment $4\mathrm{.}2(50$ marks$)$

Formulate the following integrity constraints as triggers in SQL Server SQL:

a$)$ When a new review is registered, update the number of review count for the corresponding business. If a review is submitted by a user who has already reviewed for that business, older reviews to be ignored and only the latest review from each user should be considered for the business calculating the number of reviews. $(30$ marks$)$

b$)$ Implement a rule that users can only leave a review for a business if they have at least one friend who has also reviewed that business. This rule should only apply to new reviews and should not affect any existing reviews already recorded in the database. $(20$ marks$)$In this assignment, you will implement several queries and triggers in SQL for the Yelp Edmonton database created in Assignment $3.$ Here are once more the database tables:

Please formulate the triggers describe above. ONE TRIGGER PER QUESTION! and provide test cases that will pass and fail the trigger the database schema is given. IF U CANT DO IT PLS DONT TAKE THE QUESTION THIS IS MY FOURTH TIME ASKING FOR THIS.