Database Assignment: Based on the POS \& Stock Controller system shown below, design an appropriate ER diagram that reflects the specified system and then extract the mapped tables showing them as flat tables. A Point-of-Sale \& Stock Controller System is an information system primarily used to monitor the sales and stock activities of a company. In the POS \& Stock Controller System it is possible to have the following entities: - Product - Product Category - Product Unit - Sales - Invoice - Receive Product - Customer - Supplier - Purchase Order - User The possible relationships between them can be as follows: - The user determines the products ( 1 to N). - The user can handle multiple invoices (1 to N). - The user can manage the receiving transactions ( 1 to N). - The user can process the purchase order transactions (1 to N ). - Product belongs to a certain category ( N to 1 ). - Product has multiple product units (1 to N ). - Product has multiple receiving transactions (1 to N ). - Product is also included in the purchase order transaction (1 to N). - Purchase order will be forwarded to the supplier (1 N). - The supplier will supply the requested products (1 to N ). - Product is included in multiple sales (1 to N). - Sales produce an invoice (1 to N). - An invoice is given to the customer (1 to N). The last part of the ERD process is to add attributes to the entities as follows: Product Entity has the following attributes: - Product ID - primary key represented with underline - Code - Name - Unit Price - Unit in Stock - Discount Percentage - Re-Ordervel - Category ID - foreign key - Unit ID - foreign key - User ID - foreign key - Unit ID - primary key represented with underline - Name Sales Entity has the following attributes: - Sales ID - primary key represented with underline - Invoice ID - foreign key - Product ID - foreign key - Quantity - Unit Price - Sub Total Invoice Entity has the following attributes: - Invoice ID - primary key represented with underline - Customer ID - foreign key - Total Amount - Amount Tendered - Payment Type - Bank Account Name - Bank Account Number - Date Recorded - User ID - foreign key Receive Product Entity has the following attributes: - Receive Product ID - primary key represented with underline - Product ID - foreign key - Quantity - Unit Price - Sub Total - Received Date - Supplier ID - foreign key - User ID - foreign key Customer Entity has the following attributes: - Customer ID - primary key represented with underline - Code - Name - Contact Address Supplier Entity has the following attributes: - Supplier ID - primary key represented with underline - Code - Name - Contact - Email - Address Purchase Order Entity has the following attributes: - Purchase Order ID - primary key represented with underline - Product ID - foreign key - Quantity - Unit Price - Sub Total - Order Date - Supplier ID - foreign key - User ID - foreign key User Entity has the following attributes: - User ID - primary key represented with underline - Fullname (FirstName, MiddleName, LastName) - Contact - Designation - Account Type - Username - Password