Shop Here

Shop Here : BUI VIET PHONG STUDEN: NGUYEN XUAN DUNG Presentation date : 27/05/2009 COORDINATOR

About SHOP HERE Shop Here is a leading departmental store in New York. The store is known for quality products, affordable price range, timely services, and home delivery facility. The store has customers from all sections of the society and procures goods from various.

Concept

Entities Categories  Items  Employees  Purchase Order  Suppliers  Customers 

Atributes Categories:  Categories_ID  Categories_name

Atributes Items:       

Item_ID Item_name Category_ID Suppliers_ID Serial_number Record_level Unit_price

Atributes Suppliers       

Supplier_ID Supplier_name Address Phone_no Country_origin Shipment_method_ID Shipment_date

Atributes Employees:  Employee_ID  

Employee_name Phone_no

Atributes Purchase Order             

Purchase_order_ID Item_ID Employee_ID Customer Shipment_method_ID Shipment_date Supplier_ID Order_date Freight_Charge Unit_price Pay_ID Pay_name Total_cost

Atributes Customer:  Customer_ID  Customer_name  Address  Phone_no

E/R Diagram

Tables

Customer Items

Cust_ID

Item_ID

Cust_name

Cate_ID

Address

Serial_number

Phone_no

Record_level

Purchase Order

Unit_price

Purchase_Order_ID

Supp_ID

Item_ID Cate_ID

Categories Cate_ID Cate_name

Emp_ID Suppliers Supp_ID Supp_name Address

Employees

Phone_no

Emp_ID

Country_origin

Emp_name

Ship_ID

Phone_no

Ship_date

Ship_ID Ship_date Cust_ID Order_date Quantity Unit_price Freight_Charge Total_cost Pay_ID Pay_name

Tables after 3NF Purchase Order Purchase_Order_ID Item_ID

Shipment

Emp_ID

Ship_ID

Ship_ID

Ship_name

Ship_name Supp_ID Order_date Quantity Unit_price Freight_Charge

Payment

Total_cost

Pay_ID

Pay_ID

Pay_name

Pay_name

Developed by XONEDUNG