CREATE TABLE users ( ID int PRIMARY KEY NOT NULL, NAME varchar(50) NOT NULL, DOB varchar(20) NOT NULL, ADDRESS varchar(100) NOT NULL, PHONE varchar(20) NOT NULL, SALARY float NOT NULL, PASSWORD varchar(20) NOT NULL )

CREATE TABLE company ( NAME varchar(50) PRIMARY KEY NOT NULL, ADDRESS varchar(50) NOT NULL, PHONE varchar(20) NOT NULL )

CREATE TABLE products ( BARCODE varchar(20) PRIMARY KEY NOT NULL, CODE varchar(10) NOT NULL, PRODUCT_NAME varchar(50) NOT NULL, TYPE varchar(20) NOT NULL, COST_PRICE float NOT NULL, SELLING_PRICE float NOT NULL, EXPIRY varchar(20) NOT NULL, COMPANY_NAME varchar(50) REFERENCES company([NAME]) NOT NULL, PRODUCTION_DATE date NOT NULL, EXPIRATION_DATE date NOT NULL, PLACE varchar(20) NOT NULL, QUANTITY int NOT NULL, )

CREATE TABLE expiry ( PRODUCT_BAR_CODE varchar(20) PRIMARY KEY REFERENCES products(BARCODE), PRODUCT_NAME varchar(50) NOT NULL, DATE_OF_EXPIRY varchar(10) NOT NULL, QUANTITY_REMAIN int NOT NULL )

CREATE TABLE sales ( SALE_ID int PRIMARY KEY IDENTITY(1,1) NOT NULL, USER_ID int REFERENCES users(ID) NOT NULL )

CREATE TABLE sales_history ( SERIAL_NO int PRIMARY KEY IDENTITY(1,1) NOT NULL, BARCODE varchar(20) REFERENCES products(BARCODE) NOT NULL, PRODUCT_NAME varchar(50) NOT NULL, TYPE varchar(10) NOT NULL, QUANTITY int NOT NULL, PRICE float NOT NULL, AMOUNT float NOT NULL, DATE varchar(15) NOT NULL, TIME varchar(20) NOT NULL, SALE_ID int REFERENCES sales(SALE_ID) NOT NULL )

CREATE TABLE login_history( SERIAL_NO int PRIMARY KEY identity(1,1) NOT NULL, USER_ID int REFERENCES users(ID) NOT NULL, TYPE varchar(20) NOT NULL, [DATE] varchar(20) NOT NULL, TIME varchar(20) NOT NULL ) CREATE TABLE purchase ( BARCODE varchar(20) PRIMARY KEY NOT NULL, NAME varchar(50) NOT NULL, TYPE varchar(20) NOT NULL, COMPANY_NAME varchar(50) REFERENCES company([NAME]) NOT NULL, QUANTITY int NOT NULL, PRICE float NOT NULL, AMOUNT float NOT NULL )

1. E-R Model Construct an E-R diagram representing the conceptual design of the database

. Be sure to identify primary keys, relationship, etc.