4.8 Identify the foreign keys in this schema. Explain how the entity and referential integrity rules apply to these relations.4.9 Produce some sample tables for these relations that observe the relational integrity rules. Suggest some generalconstraints that would be appropriate for this schema.4.10 Analyze the RDBMSs that you are currently using. Determine the support the system provides for primary keys,alternate keys, foreign keys, relational integrity, and views.4.11 Implement the above schema in one of the RDBMSs you currently use. Generate two user-views that areaccessible and updatable as well as two other user-views that cannot be updated.166 | Chapter 4 The Relational Model