1) (5 points) Examine the below relational schema; Apply it based on a specific context in a specific Ministry in Oman, and modify it: Replace RELATION 2 by a name of an applicable event entity (as an associative entity) and RELATION 3 by a person/concept/object entity ADD 1:1 or 1:M unary relationship to CITY or RELATION3 entity. Add different data types (char, varchar, date, integer, decimal etc.). Insert your modified relational schema as an image. 2) (20 points) WRITE a database description for each of the above relations(tables) using SQL DDL CREATE and ALTER(shorten, abbreviate or change any data name as needed in your SQL version). Don’t forget to include primary key constraints, foreign keys constraints, check constraints( for character and numeric columns with different conditions), default, unique and required constraints etc. Name table starting tbl such as tblYournameCity.
< >

3) (15 points) Add data using different ways of INSERT command (2 rows for one-side tables, and 3 rows for many-side tables).

<< PASTE your answer here including SQL INSERT command and each table view using : SELECT * from tablename>>

4) (15 points) Use SELECT statement to report three queries (with their outputs and description based on the below:
a. A query includes (1), a query includes two tables, and a query includes three tables, and a query of one table with unary relationship.
b. Each query must include conditions and order by, and select specific columns (not *).
c. Integrate calculated column, aggregated functions, group by and having, and sub query in your queries.
d. Add a new function in your query that is not covered in this course.

<< PASTE your answer here including : 1- Query one sentence description,2- SQL select statement and 3-query output>>.

Assignment will be graded based on completeness, accuracy (syntax & logic), relevancy and creativity.