$1.$ Collect and describe the requirements details of your selected application.

$2.$ Draw the appropriate ER$/$EER representation of your application.

$3.$ Design the relational schema of your application based on your ER$/$EER

representation. All constraints $($Keys$,$ Integrity, Referential, $...)$ should be clearly

stated.

$4.$ Select a DBMS System $($Oracle$,$ Mysql$,$ SQL Server, online SQL interpreters...$)$ to

create your relations schemas and populate them with at least $10$ tuples for each

relation.

$5.$ Design different SQL queries $($at least $10$ covering the different features of SQL$).$ Run

these queries on the selected DBMS and present the results. Your queries should

involve most of the relations your de