Problem Description You will be designing a functioning online shopping system for an online business. This particular business doesn't have a physical store and functions entirely online. For this reason it is very important for them to have a well-designed web page. The online shopping system should have the following functions. Note that some functions are different from the shopping system introduced in the lecture. 1) The shopping system has two roles of users: customers and managers. 2) Customers can view all products. 3) Customers can register and sign up the website. 4) After signing up, customers can add interested products to the cart. Customers can view the cart and process the order or empty the cart. Managers can do all what customers do. 5) 6) In addition, after signing up, managers can add or delete products, view the customer list and the order list (having all orders by customers). Task 3: Designing a database for your website Designing a database consists of 4 basic steps. Problem Description Entity Relationship Diagram 2) Identify the attributes in the problem description. Table Design Task 3.1: Complete the following questions according to the problem description 1) Identify the possible entities in the problem description. 3) Identify how the entities relate to each other (the relationships) 4) Identify what attributes could be used as primary keys for each entity. Task 3.2: Create an ER diagram Database Implementation Task 3.3: Convert the ER Diagram into a Table This is a step by step process: 1) Create one table per entity. 2) Each attribute of the entity is represented as a column in the table. 3) Define the primary key columns (underline them) 4) Add the foreign keys.