Build a Website

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. For DVD rental system and library mangement system, with the complete E-R diagram, complete schema diagram.