Scribd
Upload
23 views1 page

Comp 2350

The document outlines a database schema for a Food Chain Company and Shopping Center, detailing various entities such as customers, stores, products, sales, and staff. Key attributes include IDs for customers, stores, products, and sales, along with relevant information like names, descriptions, prices, and staff details. It also categorizes staff into full-time, casual, and part-time with associated salary structures.

Uploaded by

pinlun1412
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
23 views1 page

Comp 2350

The document outlines a database schema for a Food Chain Company and Shopping Center, detailing various entities such as customers, stores, products, sales, and staff. Key attributes include IDs for customers, stores, products, and sales, along with relevant information like names, descriptions, prices, and staff details. It also categorizes staff into full-time, casual, and part-time with associated salary structures.

Uploaded by

pinlun1412
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Food Chain Company Shopping Center

*C_ID *Center_ID

Name Name

Date Service Phone Number

Amount CM Phone Number

Location_ID

Store

*S_ID Location

C_ID *Location_ID

Stores Address

Location_ID Length

Product_Bundle Type

Product B_ID

*P_ID P_ID Sales

C_ID Name *Sale_ID

Name P_ID

Description Date

Sale Price Time

Cost Price Total

Tax

Discount

Person_ID

Food Item Cold Drink SunDry

Size Temperature Weight Sales_Item

Weight *Sale_ID

Type Items

Discount

Staff

*Person_ID Staff_Manager

C_ID *Person_ID

Name Start_Date

Email

Date

Full Time Casual Part Time

Salary Base_rate Per Hour Rate


Start_Date
Start_Date Per Week Rate
Loading_Per
superannuation superannuation

You might also like