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 Mankhool, Dubai, UAE. 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

Task 1 - Implement the Database based on your Design Documents.

Create a database using MySQL Database that stores complete Business-related information. This database should aim to have all the following requirements:

a. Create as many tables you need as per your design for Plug-Ins Electronics.

b. Insert valid records for all the tables.

c. Primary keys need to be created if required.

d. Foreign keys should be used to link tables, with appropriate referential action.

e. Integrity constraints developed.

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 Mankhool, Dubai, UAE. 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 a. Task 1 - Implement the Database based on your Design Documents. Create a database using MySQL Database that stores complete Business-related information. This database should aim to have all the following requirements: Create as many tables you need as per your design for Plug-Ins Electronics. b. Insert valid records for all the tables. C. Primary keys need to be created if required. d. Foreign keys should be used to link tables, with appropriate referential action. Integrity constraints developed. e