mama's love bakery employee and supplier record tracker

Mama's Love Bakery Employee and Supplier Record Tracker

Co, RoxanneDe Leon, Gelvin

Dela Cruz, Shannen RoseHaw, Michael

Mama’s BakeryBackground of Mama’s BakeryOrganizational ChartBusiness ProcessMama’s Bakery’s problem

Background of Mama’s bakery

Location: ManilaProducts: Bread and some grocery itemsOwner: Robin De LeonEmployees:

Total of 6 sales lady and 7 bakers each bakery

Organizational Chart

Business Process

Store hours: 4:00 am to 12:00 midnight Two shifts:

4:00am to 2:00pm 2:01pm to 12:00 midnight

The employees have to log in and out before proceeding to their job or at the end of their shift

Types of Employees Cashier Saleslady Bakers

Master Baker Helper

Business Process

1. The customer picks out the bread he/she wanted to buy.

2. The saleslady assists him/her and passes the packaged bread to the cashier.

3. The customer then pays to the cashier.

4. The Cashier stores the money and if there’s a change, it will be given to him/her.

Mama’s Bakery’s problem

The company needs a database to record their supplier information.

The company needs a database to record their employee information.

Objectives, Scope and Limitations

ObjectivesScope and Limitations

Objectives

To create an adequate supplier and employee database for the company.

To design the program so that it is secure and user-friendly.

To design the program around existing processes so that there can be ease in transition.

Scopes and Limitations

Language: JavaRDBMS: mySQLUsers:

Owner Employees

Scopes and Limitations

Features Password Protected (password supplied by the

company) suggestions on additions or deductions to

employee salary based on a performance factor (determined by the authorized users of application)

Scopes and Limitations

Contents of the database Names Positions Salary-related information Supplier names Products supplied Product prices

Scopes and Limitations

Limitations Will not place product orders with suppliers Nor take orders from customers A managerial application Not transactional

Scopes and Limitations

Upon Request: Printing support Web service

Appendix

Sample Employee RecordSample Receipt

Sample Employee Record

Sample Employee Record

Sample Receipt with Supplier Data