Please use "Clothing retail store "data set to answer the following questions. You can post screenshots of the commands or working.

Please!! Thanks

Project 1: Application Description: Write a report on description of the application, its functions and the information that you expect from it, in high level (1 marks) Design the ER model: that has different type of entity relationships (1:1, 1:N, N:M) (1.5 marks)

Schema design: Use Oracle SQL Developer to create the tables derived from ER/EER diagram and submit the source code with screenshot of your tables (1.5 marks) Database construction:Populate the tables of database by using SQL commands (1.5 marks)

Designing Simple Quarries: Prepare at least 8 simple queries (at least one for each of your tables) and show the snapshots of their results. In general, you have to produce professional report results for queries. The query results should show records in collections with meaningful titles and proper format. (1.5 marks)

Designing Advanced Quarries: Prepare at least 6 advanced queries to retrieve data from two or more collections. All queries should have clear and nice formatted results. (1.5 marks)

Updating and deleting database content: Prepare at least 4 commands for updating different collections and the same for the other 4 deleting database content commands. (1.5 marks)