Create Grocery Management System   ERD and Relational skimma.

according to code for My sql Language . create table and becarefull connect to foreign key and primary key.

code is run successful. 

 1) Grocery Store 

store_id ,name location ,contact_number 

2) Employee

 employee_id ,name ,position ,contact_number, email ,salary, address ,sex 

3) Order

 Order_id, Total price, Order, date 

4) Order Line 

orderline_id 

order_id 

product_id

 quantity price 

5) Supplier 

supplier_id,name,sex ,contact_person, contact_number ,email

 6) Inventory

 inventory_id ,product_id, quantity 

7) Product 

product_id, name, category, price, description

 8) Cashier

 cashier_id, name, contact_number, email, salary 

9) Customer 

customer_id ,name, address, sex ,contact_number, email 

10) Promotion

 promotion_id ,name, start_date ,end_date, description 

11) Payment

 payment_id, order_id, amount, payment_date, payment_method