200 likes | 543 Views
Mama's Love Bakery Employee and Supplier Record Tracker. Co, Roxanne De Leon, Gelvin Dela Cruz, Shannen Rose Haw, Michael. Mama’s Bakery. Background of Mama’s Bakery Organizational Chart Business Process Mama’s Bakery’s problem. Background of Mama’s bakery. Location: Manila
E N D
Mama's Love Bakery Employee and Supplier Record Tracker Co, Roxanne De Leon, Gelvin Dela Cruz, Shannen Rose Haw, Michael
Mama’s Bakery Background of Mama’s Bakery Organizational Chart Business Process Mama’s Bakery’s problem
Background of Mama’s bakery • Location: Manila • Products: Bread and some grocery items • Owner: Robin De Leon • Employees: • Total of 6 sales lady and 7 bakers each bakery
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 • The customer picks out the bread he/she wanted to buy. • The saleslady assists him/her and passes the packaged bread to the cashier. • The customer then pays to the cashier. • 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 Objectives Scope 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: Java • RDBMS: mySQL • Users: • 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 Record Sample Receipt