IT 111 Database Design and SQL Assignment 5 Instructions: Based on your solution for Assignment 3 and the solution that is posted in Week 2-Weekly Activities, do the following: 1. Create the ERD for this solution using VISIO. 2. Add the appropriate attributes for each entity in VISIO. 3. Identify the correct datatype for each attribute and note them by the attribute name. 4. Apply the Primary key to each entity by identifying the key in VISIO for each entity. Complete all using VISIO and upload the .vsdx file via the assignment manager. Problem (requirements): Getemtobuyit Company wants you to develop a customer database. They want to store all purchasers' orders and the products on each order. Shoppers of their company should be able to see all of their orders and every item on each order including the vendor of each product. Getemtobuyit would love to know via this database who their favorite product suppliers and best-selling products are at any point. For customers, Getemtobuyit Company would like to know common demographic type information. That is First Name, Last Name, Address, State, ZIP. In addition, they would like to be able to filter the data based on Gender, Race, and Age in the future. Each order should have a unique order number that the company will generate and also the date of the order. It will be important in the future to sort all orders based on their status (In Process, Shipped, Delivered). Each product should contain the name of the product, the cost of the product to Getemtobuyit and the retail price that it is being sold to the public. In addition, they will need to know how many of the items are in inventory and what category the product falls in. For example, electronics, food, clothes, etc. For the supplier, the need to know the name, and complete address of each. In addition, the contact name and contact information for each sunglier is noodod