Term Project Guidelines (Due 12th week) 6th August 1159PM Complete this project either individually or in group of two. 1 Student: Min 5 Tables, 2 Students: min 10 Tables in the database Min 10 rows in each table 1. Choose a project of your choice e.g. e-Commerce, Car Rental etc. Search Google for ideas. 2. Create an initial database design (ER Model) for your project. 3. Generate business rules from the ER Model. 4. Indicate attributes, entities, primary key and relationships. 5. create all the tables using the information provided in the ER model. 6. Display all the table in table format with the data type and data description, length, default value – OR describe each column of the table as per the below format. Example Table Name: Attribute Description Key Type/ Constraint Data Type Filed length 7. Create and execute all the SQL statements needed to add the constraints 8. Create and alter the tables based on the needs (min 7 tables: 1 Student, min 10 tables: 2 Students, min 10 data rows in each table) 9. Save the changes permanently to the database 10. Insert appropriate values in all the tables 11. Query your database: Design and execute 5 SQL statements that involve these 5 operations – DML, Operators, Functions, Joins, and Grouping. (Hint: Ask a question and write an SQL to answer your question involving the above mentioned 5 clauses) 12. Document your work in word document. Rubrics 5% – ER model 5% – Table creation 5% – Query (DML, operators, Functions, joins, grouping) Examples: e-Commerce. Car Rental.