Research for database management system (DBMS) ER Modeling and Relational Modeling

For ER Modeling for all three CFPs 1. Identify the entities, attributes, relationships and business rules. 2. Draw the ER diagram based on your requirement analysis in part 1 without using any ER diagram designing software. 3. Transfer your ER diagram to MySQL Workbench ER diagram. Add the screenshot/image of this diagram to your report. In order to learn how to create ER diagrams in MySQL Workbench. For Relational Modeling Use your solution for Question 1 and convert it to a Relational Model. This relational model will be in the form of a SQL script to create required tables and their attributes following the constraints. Further, you have to apply/implement this script to create these tables on your personal MySQL server. Submit all the code in a script file. your code should be on txt file • Run this script on MySQL server, either through command line interface or through Workbench query interface, and add the screenshots. Your screenshots must: 1) Show the list of tables before the script is executed. Check the MySQL manual to figure out how to see the list of tables 2) Show the script being executed, either through command line interface or through Workbench query interface 3) Show the success status of script and the list of tables after the script execution 4) The whole script must execute successfully.