Schema:

Home Page

Schema for the one database in our system

Items(item_name: string, item_stock: integer, reorder_level: integer, unit:string, vendor_id:integer)

Vendors(id: integer, name: string, address: string)

Price(item_name: string, quantity: integer, date: date, price: integer)

has(item_name: string, requisition_number: integer, quantity_requested: integer, quantity_issued:integer)

Requisition(requisition_number: integer, date: date, department: string)

Purchase(vendor_id: integer, slip_id: integer, date: date)

included(slip_id: integer, item_name: string, cost_per_unit: integer, quantity: integer)

 

 

 

 

 

1

Hosted by www.Geocities.ws

1