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

java assignment help

© Livewebtutors. All Rights Reserved 2018

Livewebtutors
Rated 4.9/5 based on 2480 reviews
Arrow up