Back
Back
Back
Back
Back
Back
Back

Welcome to Live Chat

Welcome to LiveWebTutors Services, World's leading Academic solutions provider with Millions of Happy Students.

Call Back
logo

24x7 Support Available

To Get the Best Price Chat With Our Experts

chat now

In A Hurry? Get A Callback

logo

shopping cart 0

Subject Solutions Code Description Price Delete

Amount Payable : $0

continue shopping proceed to checkout

World's Leading Assignment Library

By storing information on every product and customer preference it will improve sales. Also it helps to know what type of customer is returning for another purchase. With a database this can be done w

Question Preview:

I will be making a database for a local bakery and it should help improve or fix the following: Customer and product information: By storing information on every product and customer preference it will improve sales. Also it helps to know what type of customer is returning for another purchase. With a database this can be done with ease. Organized inventory Organizing the inventory in a database can help save time for the employee if they want to check if they are out of stock and making it easy to order more inventories that way Employee management A database ...

View Complete Question >>

Question Preview:

I will be making a database for a local bakery and it should help improve or fix the following: Customer and product information: By storing information on every product and customer preference it will improve sales. Also it helps to know what type of customer is returning for another purchase. With a database this can be done with ease. Organized inventory Organizing the inventory in a database can help save time for the employee if they want to check if they are out of stock and making it easy to order more inventories that way Employee management A database will greatly help manage employee hours and making sure no employee is working overtime or cutting back on hours. Order delivery/pickup With a database we can keep track of the current, past and future orders while managing them efficiently Purchases Storing all purchases made from and to the bakery will help the business financially DBMS and IDE technology choice: DBMS: MySQL IDE: Java (eclipse) Proposed Entities in the solution: (In this section outline the entities that are relevant to the solution. While this is an early stage, there should be five to seven major entities. If not, you should consider another selection): Customer Customer ID Customer Name Address Phone Employee Employee ID Employee Name Salary Job position Supplier Supplier ID Supplier Name Contact phone Ingredient Ingredient ID Ingredient name Orders Order ID Date Order Type Inventory Item ID Name Price Item Type Purchases Purchase ID Date Price products Product ID Product Name Initial Business rules: (In this section, outline the business rules that are relevant to the problem and required to be implemented in the solution. Think about the appropriate use case as well. These may change and you are allowed to be creative if the problem you have chosen is fictional) Order entity can order at least one item from inventory entity and there can be many orders of that item Customer can request many orders and every order has one customer A supplier can send one shipment of inventory to the store and the store can have many different suppliers Employee can make purchases to many customers and customer can only purchase from one employee at a time Order can be made by pickup or delivery but not both from a single customer Product can at least have one or multiple ingredient and an ingredient can be in multiple products or none Inventory can have one or more products and only one inventory for the product I will be making a database for a local bakery and it should help improve or fix the following: Customer and product information: By storing information on every product and customer preference it will improve sales. Also it helps to know what type of customer is returning for another purchase. With a database this can be done with ease. Organized inventory Organizing the inventory in a database can help save time for the employee if they want to check if they are out of stock and making it easy to order more inventories that way Employee management A database will greatly help manage employee hours and making sure no employee is working overtime or cutting back on hours. Order delivery/pickup With a database we can keep track of the current, past and future orders while managing them efficiently Purchases Storing all purchases made from and to the bakery will help the business financially DBMS and IDE technology choice: DBMS: MySQL IDE: Java (eclipse) Proposed Entities in the solution: (In this section outline the entities that are relevant to the solution. While this is an early stage, there should be five to seven major entities. If not, you should consider another selection): Customer Customer ID Customer Name Address Phone Employee Employee ID Employee Name Salary Job position Supplier Supplier ID Supplier Name Contact phone Ingredient Ingredient ID Ingredient name Orders Order ID Date Order Type Inventory Item ID Name Price Item Type Purchases Purchase ID Date Price products Product ID Product Name Initial Business rules: (In this section, outline the business rules that are relevant to the problem and required to be implemented in the solution. Think about the appropriate use case as well. These may change and you are allowed to be creative if the problem you have chosen is fictional) Order entity can order at least one item from inventory entity and there can be many orders of that item Customer can request many orders and every order has one customer A supplier can send one shipment of inventory to the store and the store can have many different suppliers Employee can make purchases to many customers and customer can only purchase from one employee at a time Order can be made by pickup or delivery but not both from a single customer Product can at least have one or multiple ingredient and an ingredient can be in multiple products or none Inventory can have one or more products and only one inventory for the product

View Less >>

Solution Preview

Some of the important business rules that needs to be followed in designing the database are listed below:

  • A customer can order multiple times and every order is done by only one customer.
  • An employee can deliver many orders and an order can be delivered by only one employee

question Get solution

$30

Orginal Price : $39.0

Pay Now

Upload Assignments

250 words

side

Get Your Assignment

Don’t delay more, place your order now. Quick assignment help will be offered to you.

Order Now

CUSTOMER REVIEWS

Excellent

logo

Based on 702 reviews See all reviews here

One of the Best Service

I trust LiveWebTutors for my assignments because of their ability to deliver the perfect assignments time and again. Only a few of my assignments required minor revisions. The rest assured it is the best assignment writing service in the market.

Elizabeth
Sydney

Great Service and on time

I felt so exhausted and burdened with the large number of assignments I had to write and desperately needed someone to help me with all the writing and there was LiveWebTutors company on the internet. They finished my assignments before the due date and also offered me a first-timer discount.

Christina
Perth

One of the Best Assignment Provider

I ordered my Mathematics and Marketing assignments from them last month. I received the content on the set date. Most importantly, the assignments were well-written and plagiarism free. I scored a top grade for the assignment written by them. They are a reliable company.

Oli
Brisbane

Very Helpful Customer Service

I was quite unsure about getting my assignment written online but after coming across LiveWebTutors.com, all my worries have vanished. The quality of the assignments written by their writers is just invincible. Their customer support is very polite and helpful. You should try their service at least once

Kabir
Adelaide