Database normalization rules

  2) Explain the story behind the scenario, and all your assumptions, which are required to support relationships given above. 3) Show show entities and their attributes. Each entity should have at least three attributes. 4) Show ER diagram with correct notation (cardinality/modality). You can use any drawing software, MS Visio, www.lucidchart.com, www.draw.io , etc. In those online tool you can use "Entity Diagram" section. Make sure that you ER diagram fits one pages and seems tidy and compact. 5) Show your referential integrity rules for your scenario. (FK->PK) 6) Convert the ER diagram to tables. Show your tables with primary keys. 7) Discuss database normalization rules on your tables. Do not explain what the rules are. Instead validate if each of tables satisfies 1NF, 2NF, and 3NF. If not, normalize your tables. SQL In this part you need to demonstrate SQL operation on your project portal (phpMyAdmin). Add related SQL statement and output as screenshot into your project file. Make sure that each table at least 10 rows and each table has appropriate PK and FK assignments. 8) List each of table, such as STUDENT( CWID (PK), Name, LastName, Major (FK) ). No screenshot required, SQL statements only. 9) Give data insertion SQL statements involving at least three tables. (SQL only) 10) Give data deletion SQL statements involving at least three tables. (SQL only) 11) Give data update SQL statements involving at least three tables. (SQL only) 12) Give two SELECT statements with WHERE statement. Also show it online, a link for .php file required. Show screenshot of .php file. 13) Give two SELECT statements with GROUP BY statement. Show the resulting table (screenshot). 14) Give a SELECT statements with HAVING statement. Show the resulting table (screenshot). 15) Using two related tables (meaning logically connected with primary-key and foreign-key pairs), run a join statement to show matching rows. For instance, assume that Table A and Table B has 4 and 5 attributes respectively. Also, assume that Table A’s primary key is seen as foreign key in Table B. Use join operations to show matching rows whose primary key and foreign key is same. Give SQL statement and show the resulting table (screenshot). 16) Give a Left Join statements. Also show it online, a link for .php file required. Show screenshot of .php file.