Customers must register as members to place an order using our order form. Once submitted, orders will be added to a queue. The following business situation and constraints apply: customers need to provide their first name, last name, telephone number, and address when registering as members. While customers can order multiple products, they are required to order at least one product at a time. For each product they wish to purchase, customers must complete the order form again. After placing an order, customers should fill out the payment form with their bank details, the amount of money to be paid, and the date of payment.
The order details for each order consist of the order detail 'd, amount, total price, and product ID. Partner companies may have no products or multiple products, with each partner company having a uniq
...ue company name. Products have unique product IDs and names. The order detail is used to create a queue for purchasing products. A staff member can receive multiple orders, but all orders come from one staff member unless the staff member does not receive any orders. Our company has two types of employees: staff and managers, both with an employee ID, name, and phone number.
A manager is a skilled employee who can accept orders with a specific order id. An event, identified by its name, can be hosted at multiple locations, each of which has a unique name and address.
The queue database is utilized to gather a range of business-related data, including customer orders, order details, customer information, and employee information. The data requirements for the queue database are as listed below:
The tex
discusses various types of information that are important for the functioning of a company's database. These include customer details, payment information, order and product details, employee information, event preferences of customers and their associated locations. The functional requirements mentioned involve allowing customers to place orders and have them stored in the database. Administrators should also be able to input orders on behalf of customers. Additionally, the system should allow customers to update their membership information while administrators can update staff details related to customer orders.
The Delete Administrator has the ability to delete orders. System Interface Requirements: Our company's system must be able to connect to the credit card system for payment processing. Control Requirements: Customers are responsible for making payments. Customers place orders. Orders placed by customers are for events happening at a specific location. Customer orders include order details, which are used to queue products. Our partner company provides the products. Staff members receive customer orders. Payment is used to pay for these orders.
- Data Management essays
- Enterprise Resource Planning essays
- John Locke essays
- 9/11 essays
- A Good Teacher essays
- A Healthy Diet essays
- A Modest Proposal essays
- A&P essays
- Academic Achievement essays
- Achievement essays
- Achieving goals essays
- Admission essays
- Advantages And Disadvantages Of Internet essays
- Alcoholic drinks essays
- Ammonia essays
- Analytical essays
- Ancient Olympic Games essays
- APA essays
- Arabian Peninsula essays
- Argument essays
- Argumentative essays
- Art essays
- Atlantic Ocean essays
- Auto-ethnography essays
- Autobiography essays
- Ballad essays
- Batman essays
- Binge Eating essays
- Black Power Movement essays
- Blogger essays
- Body Mass Index essays
- Book I Want a Wife essays
- Boycott essays
- Breastfeeding essays
- Bulimia Nervosa essays
- Business essays
- Business Process essays
- Canterbury essays
- Carbonate essays
- Catalina de Erauso essays
- Cause and Effect essays
- Cesar Chavez essays
- Character Analysis essays
- Chemical Compound essays
- Chemical Element essays
- Chemical Substance essays
- Cherokee essays
- Cherry essays
- Childhood Obesity essays
- Chlorine essays