Pete's Lebanese Bakery
Pete's Lebanese Bakery is a small family run business located in Kenmore NY. Due to its small size it previously operated on a paper based delivery, scheduling, and product ordering system. This posed a problem if an order sheet was lost and was time consuming in that hard copies of orders had to be sorted through and organized each business day.
To relieve this issue our group has created a database which allows Pete's Lebanese Bakery to store their employee information, restaurant information, as well as delivery schedules. The database contains a calling list of restaurants, mailing list, delivery personnel information, invoices, and an order schedule as well as delivery schedule. Our maintenance strategy will be to back up our database to a server at the end of every month. At the end of each year we will remove outdated information/customers from our database. A future enhancement to our database will be to show products sold as well as profits from non-delivery purchases as well as add tracking.
To relieve this issue our group has created a database which allows Pete's Lebanese Bakery to store their employee information, restaurant information, as well as delivery schedules. The database contains a calling list of restaurants, mailing list, delivery personnel information, invoices, and an order schedule as well as delivery schedule. Our maintenance strategy will be to back up our database to a server at the end of every month. At the end of each year we will remove outdated information/customers from our database. A future enhancement to our database will be to show products sold as well as profits from non-delivery purchases as well as add tracking.