Database project proposal
Project Proposal
Template 1: Business situation
Business Name: The Queue
Business description:
The Queue is a company that provides service to customers by helping them buy products. Customers can order not only hot products that spent much time to queue, but also simple products for helping customers save their times. For example: Concert tickets, Garrett popcorn, Starbucks’ buy one free one promotion, or Jamsai books at the national book fair.
Customers can contact with our company by using our websites to ask for the information and order products. Customers must register as our members and there will be the order form to order products. Our company will receive orders and queue up for them.
Business situation and constraints:
Customer must register as company’s members by giving their information such as first name, last name, telephone number, and address. One customer can order many products but at least one product per time.
Customer need to fill in the order product’s form.
Customer has to complete the payment form after ordering products which consists of using bank, amount of money, and date.
Each order has order details that contain order detail id, amount, total price, product ID.
Each partner companies can have zero to many products. Partner companies contain only unique company name.
Products contain unique product id and product name.
Order detail uses for making a queue to buy products.
A staff can received many orders but many orders can come from only one staff or else a staff can be able not to receive any orders.
Our company has two types of employees, which are staff and manager. Both of them contain employee ID, employee name, employee phone number. Manager is an employee who has experiences.
Orders that specified by its order id can be placed or can’t be placed on only one event.
An event which is specified by its event name can be located at many locations which contain unique name and location address.
Template 1: Business situation
Business Name: The Queue
Business description:
The Queue is a company that provides service to customers by helping them buy products. Customers can order not only hot products that spent much time to queue, but also simple products for helping customers save their times. For example: Concert tickets, Garrett popcorn, Starbucks’ buy one free one promotion, or Jamsai books at the national book fair.
Customers can contact with our company by using our websites to ask for the information and order products. Customers must register as our members and there will be the order form to order products. Our company will receive orders and queue up for them.
Business situation and constraints:
Customer must register as company’s members by giving their information such as first name, last name, telephone number, and address. One customer can order many products but at least one product per time.
Customer need to fill in the order product’s form.
Customer has to complete the payment form after ordering products which consists of using bank, amount of money, and date.
Each order has order details that contain order detail id, amount, total price, product ID.
Each partner companies can have zero to many products. Partner companies contain only unique company name.
Products contain unique product id and product name.
Order detail uses for making a queue to buy products.
A staff can received many orders but many orders can come from only one staff or else a staff can be able not to receive any orders.
Our company has two types of employees, which are staff and manager. Both of them contain employee ID, employee name, employee phone number. Manager is an employee who has experiences.
Orders that specified by its order id can be placed or can’t be placed on only one event.
An event which is specified by its event name can be located at many locations which contain unique name and location address.