cross popup-offer
Call Back
cross cross
logo

24x7 Support Available

call-back

To Get the Best Price Chat With Our Experts

chat now

In A Hurry? Get A Callback

Close Button
Signup/Login
Back All services Close Button

World's Leading Assignment Library

Continued assistance through writing and revision till final submission by the professional and experienced writers.

  • 10 subjects

  • 2,10,1000
    solved Questions

  • 500 Solved Questions
    Added Everyday

  • Download Solution
    in Seconds

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:

  1. 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.

  1. 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 inventorie...

View complete question »

Question Preview:

I will be making a database for a local bakery and it should help improve or fix the following:

  1. 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.

  1. 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

  1. Employee management

A database will greatly help manage employee hours and making sure no employee is working overtime or cutting back on hours.

  1. Order delivery/pickup

With a database we can keep track of the current, past and future orders while managing them efficiently

  1. 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:

  1. 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.

  1. 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

  1. Employee management

A database will greatly help manage employee hours and making sure no employee is working overtime or cutting back on hours.

  1. Order delivery/pickup

With a database we can keep track of the current, past and future orders while managing them efficiently

  1. 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

Get solution

whatappWhatsApp Order whatappWhatsApp Order

STAY UPDATED WITH LIVEWEBTUTORS

java assignment help

we provide assignment help melbourne

free turnitin report get free turnitin
Free turnitin

DMCA.com Protection Status © Livewebtutors. All Rights Reserved 2019

Arrow up