database project

1. Your final submission should include: a. Project description or proposal b. A complete E-R diagram c. A complete Schema diagram d. Sample SQL statements used to manage the database, including creating tables, inserting records, updating records, deleting records, and retrieving records with various SQL queries. Please suggest different scenarios where the following keywords may be used in SQL queries: IN, EXISTS, NOT EXISTS, NOT EXISTS with EXCEPT, ALL, SOME, UNIQUE, UNION, EXCEPT, INTERSECT, NATURAL JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN and etc. For each keyword in the preceding list, create at least one query. 2. Create the database in SQL Fiddle or another database system you prefer. Run all the SQL statements you created and show the execution results in the final submission. You can do screenshot of your execution which can be added into the same file of your submission. Caveats: 1. You are free to propose your own project, but make sure the project your propose is not too complex to serve as a term project in this course. 2. Your submission should only contain one file in pdf or Word. 3. You are free to discuss the project with your friends, but don’t submit the same work. No plagiarism is tolerated. Duplication detection will be applied to all submissions.