Entity Name Description Aliases Occurrence
Customer General term describing all Customer Each customer can shop at one or
customers many stores. They place orders and
do returns, and are served by staff
members
CustomerReturns General term describing Return Each customer return is done by one
returns made by a customer customer to one store which contains
one or many products
Inventory General term describing the Inventory Inventory of each store contains
quantity of merchadise on different quantities of many products
hand
Order General term describing Inventory Each order is placed bt one customer,
products ordered by a managed by one staff member. It
customer contains one or many products
Payment General term describing the Payment Payments are made on orders by
payment of an order customers
Product General term describing all Product Each product has it's own unique
products at JYC HardWare product number and is supplied by
one or many suppliers
PurchaseOrder General term describing orders Order Each perchase order is placed by one
placed from suppliers store to one suppler. Each order
contains one or many products
PurchaseReturn General term describing Return Each purchase return is placed by
products returned to supplier one store to one supplier. Each
return contains one or many
products
Staff General term describing all Employee Each member of staff works at one
staff employeed by JYC particular store in one particular
Hardware department Some staff supervise
other staff
Stores General term describing all Store Each store employs one or many
stores operating under JYC stafff members. Each store has one
Hardware or many customers. Stores receive
orders, receive returns, make orders,
and make returns. Each store has its
own productivity
Utilities General term describing the Utilities Each store has many utilities
utilities owed by JYC HardWare
Entity Name Multiplicity Relationship Entity Name Multipicity
Staff 1…1 Manages Order 0…*
0…1 Serves Customer 0…*
0…1 Supervises Staff 0…10
Consumer 1…1 Places Order 0…*
1…1 Makes CustomerReturn 0…*
1…1 Makes Payment 0…*
Store 1…1 Employs Staff 1…100
1…1 Makes PurchaseReturn 0…*
1…1 Has Customers 1…*
1…1 Places PurchaseOrder 0…*
1…1 Pays Utilities 1…10
1…1 Has Inventory 0…*
Order 1…1 Has OrderStatus 0…2
1…1 Has Payment 0…*
1…1 Contains Products 1…*
Customer Return 1…1 Contains Products 1…*
Inventory 1…1 Contains Products 0…*
Supplier 1…1 Supplies Products 0…*
1…1 Receives PurchaseReturn 0…*
Entity Name Attributes Description
Customer CustomerNo Uniquely identifies a customer
StoreNo StoreNo customer is associated with
Fname First name of customer
Lname Last name of customer
Street Street of customer
City City of customer
PostalCode Postalcode of customer
PhoneNo Phone number of customer
Customer RegistrationNo Uniquely identifies registration of customer
Registration CustomerNo CustomerNo of newly registered customer
StoreNo Store number customer is registered at
DateRegistered Date customer is registered
Customer Return CustReturnNo Uniquely identifies the customer return number
ReturnDate Date of customer return
CustomerNo CustomerNo who return merchandise
StoreNo StoreNo to which merchandise was returned
ProductNo ProductNo(s) of returned product
QuantityReturned Quantity(ies) of returned product
Inventory InventoryID Uniquely identifies inventory
ProductNo ProductNo of referred inventory
QuantityOnHand Quantity of product on hand
Order OrderNo Uniquely identifies order
OrderDate Date order was placed
CustomerNo CustomerNo who placed order
StoreNo StoreNo the order is ordered from
ProductNo Product(s) in the order
QuantityOrdered Quantity(ies) of products ordered
MethodOfDelivery Delivery Method of order
Payment PaymentNo Uniquely describes a particular payment
PaymentDate Date of payment
PaymentMethod Method of payment
OrderNo OrderNo of payment
Product ProductNo Uniquley describes a product
ProductDescrption Description of product
SupplierNo SupplierNo(s) of product
Price Price (s) or product
PurchaseOrder InvoiceNo Uniquely identifies an order
StoreNo StoreNo of order
SupplierNo SupplierNo of order
ProductNo Product (s) ordered
QuantityOrdered Quantity (ies) of products ordered
DateOrdered Date of order
PurchaseReturn PurchReturnNo Uniquely identifies the purchase return number
SupplierNo SupplierNo for return
StoreNo StoreNo the return is from
ProductNo ProductNo(s) of returned product
QuantityReturned Quantity(ies) of returned product
DateReturned Date of return
Staff StaffNo Uniquely identifies a member of staff
StoreNo Identifies the store number of staff member
Fname First name of staff
Lname Last name of staff
Sex Gender of staff member
DOB Birthdate of staff member
Position Job title of staff member
Department Area of specialization of staff member
Stores StoreNo Uniquley identifies a store
Street Street of store
City Cisty of Store
PostalCode Postal code of store
PhoneNo Phone number of store
Supplier SupplierNo Uniquely identifies a supplier
SupplierName Name of supplier
Street street of supplier location
City city of supplier
PostalCode postal code of supplier
PhoneNo phone number of supplier
ContactPerson contact person at supplier office
Comment comment or rating of supplier
Date Type&Length Nulls Multi-valued
5 variable characters No No
5 variable characters No No
15 variable characters No No
15 variable characters No No
15 variable characters No No
15 variable characters No No
6 variable characters No No
10 variable characters (xxx-xxx- No No
xxxx)
5 variable characters No No
5 variable characters No No
5 variable characters No No
Date Yes No
5 variable characters No No
Date No No
5 variable characters No No
5 variable characters No No
5 variable characters No Yes
Number No Yes
5 variable characters No No
5 variable characters No Yes
Number No Yes
5 variable characters No No
Date No No
5 variable characters No No
5 variable characters No No
5 variable characters No Yes
Number No Yes
Pick-up or Delivery No No
5 variable characters No No
Date No No
Cash, Credit, or Debit No No
5 variable characters No No
5 variable characters No No
30 variable characters No No
5 variable characters No Yes
Currency No Yes
5 variable characters No No
5 variable characters No No
5 variable characters No No
5 variable characters No Yes
Number No Yes
Date No No
5 variable characters No No
5 variable characters No No
15 variable characters No No
15 variable characters No Yes
Number No Yes
Date No No
5 variable characters No No
5 variable characters No No
15 variable characters No No
15 variable characters No No
M or F No No
Date Yes No
30 variable characters Yes No
15 variable characters No No
5 variable characters No No
15 variable characters No No
15 variable characters No No
6 variable characters No No
10 variable characters (xxx-xxx- No No
xxxx)
5 variable characters No No
30 variable characters No No
15 variable characters No No
15 variable characters No No
6 variable characters No No
10 variable characters (xxx-xxx- No No
xxxx)
30 variable characters No No
50 variable characters Yes No