1. a) What are reasons to create a VIEW.?

b) Name and state a meaningful view (Create a view named as . that includes .. ) and show the SQL code for creating the view you stated, based on the tables we have been using.

2. Can you use an UPDATE statement to assign/change values in multiple rows of a table. Show an example (state your query question based on the database you currently use and show the SQL code).

3. I did not talk about this in lecture videos: Can you find out if you may rename a column or change the its data type using ALTER TABLE statement? If yes, what is the syntax?

4. a) What are the roles of the trigger in general?

b) Given the following data model (pay attention to minimum cardinalities). What is the meaning of MINIMUM cardinality for the relationship between Director and Project?

c) How can a trigger be used do enforce referential integrity/constraint when

c1) a director record is deleted.

c2) a project record is deleted.

Just describe the roles of trigger for situations of c1 and c2, no need to show code of trigger.