Provide the following: 1. Business Rules. 2. Entity Relationship Diagram in 3NF. 3. Relational Model (showing fields, primary keys, foreign keys and concatenated keys). 4. Justify the choices you have made. Are the entities and relationships you have chosen free of problems? What assumptions have you made? 5. CREATE TABLE queries to create each table that is in your design. 6. INSERT INTO queries to insert values into your tables (at least 5 rows per table). Higher Level – TEST and REPORTS Write queries to test the database. 7. One query should be a simple one involving one table and a selection criteria. 8. The second query should involve a join (at least 2 tables) 9. The third should be a group by query. 10. Fourth query that involves a nested query. 11. Fifth Query that involve nested query including views. Write queries to produce the following reports. 12. List of customers and their details. 13. List of properties currently owned by a specific customer of the real-estate company. 14. List of leases currently active and details of the weekly lease payments. Submission