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_CODE varchar(20) PRIMARY KEY NOT NULL, 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 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 )

question : 1. Construct an E-R diagram representing the conceptual design and Relational schema.of the database..

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