D VIEW TIONE LO3: Produce a DML constructs to implement a relational data model 104: Generate DDL constructs to implement a business solution OM Scenario You have recently been appointed as database designer for Plug-Ins Electronics. Plug-Ins is electronics shop that sells a variety of electronic items. It is located in Mankchool. DubaiUAE. It is a family firm that has been in existence for 7 years and selling their products to customers in the local area. The business has been doing well and until now it has recorded sales and customer information manually by hand. However, the sales are increasing, and the owner now needs to start tracking details about the customer orders, staff products, deals and suppliers In Assignment 1, the owner of Plug-Ins has asked you to design a relational database that will store and record the business information. The owner of Plug-Ins Electronics has reviewed your design documentation and provided you with some feedback. As a continuation to the Design you have presented for Plug-Ins Electronics, the manager has asked you to further implement your documented data model on an actual DBMS server system. You are required to create the database, all the tables in your model along with any constraints, indexes, views etc I Task 2-Implement and execute the following SQL queries in your database. Add a product. 2 Update the price for a specific product name. 3 Check the product availability for a specific enquiry 4 Place order for a product Cancel an order Count the number of orders for a specific date range. Retrieve the contact details of a customer. 8 Check for order details on a specific date, payments received and its requirements: Generate report of products with quantity less than 5. 10 Generate the monthly report about total sales This database should be created using MySQL Database and then be populated using valid data as per the requirements