Create an E-R Diagram based on MySQL database that I created using the guidelines in the instruction.

Design and Implementation (Cameron Mims) Perform the conceptual database design using Entity-Relationship model. You must submit the Entity-Relationship diagram of your database. In the E-R diagram, 1, there must be at least 4 entities; 2, there must be at least 2 one-to-many/one-to-one relationships; 3, there must be at least 1 many-to-many relationship. Convert your E-R diagram to logical database model. You are to design the table structure, including all needed attributes for each table. You must submit the relational database schema, which consists of the description of all tables, constraints in your database. For each table, please specify the primary key and foreign keys. Implement your design using any DBMS. You are required to create all the tables and develop queries in the target DBMS. You must generate and load appropriate, consistent data into your database. One option listed below, 1, MySQL: for this option, you must submit the DDL statements you used to create the tables, to define the constraints, and the SQL statements for all the queries; *Some of the instruction may already be included in the asset inventory.sql file*