Transcript Sweet Bakery

Sweet Bakery
By:
Priscilla
Tarra
Yaraneth
Company
• Family owned and operated
• Our specialty is personalized cupcakes
• Our cupcakes are made by our talented
bakers, which is we guaranteed the best
quality
• sweet cupcakes are new in town
• Now serving Pearland area.
Services
•
•
•
•
•
•
•
•
•
•
•
Sweet cupcakes is a specialty cupcake service:
Everything is made fresh
You choose the color, size, and flavor of your order
Fresh fruit and decadent candies used only
Hand whipped cream and real butter-cream
Giant cupcakes
Cakes made of cupcakes
Free delivery with purchase of gift card
Birthdays
Holidays
Gift baskets
Contact Info:
• Address:
• Corner of Hwy 288 & FM 518,
Pearland, Texas 77584
MON-SAT, 10am - 9pm|SUN,
11am - 7pm Phone:
• 713-341-0704
Email:
• [email protected]
•Due to the growing demand of more celebration of birthday
parties, holidays and gift baskets, new research in mixing,
forming, baking and drying to maximize profitability.
•Develop and demonstrate new efficient IT processes that will
enhance the business
•Access database incorporated in our business will enable the
us to keep up with the cupcake orders
•Viable business strategies implemented would to validate
ingredients and test ingredient changes, test machinery and
processing techniques, and then produce market samples for
testing
Entities
•
•
•
•
•
Customers
Orders and Details
Products
Invoice
Payments
Entities & Attributes
Customers
Order and
Details
Products
Invoice
Payments
Customer
ID
Order ID
Product ID
Invoice
ID
Payment ID
Last Name
Order Date Description
Invoice
Amount
Payment Type
First Name
Quantity
Item Price
Date
Amount Paid
Address
Occasions
Quantity
Amount
Paid
Date Paid
City
Delivery
Service
State
Zip Code
Home #
Cell #
Customer
1
Has
Order
Makes
M
Logical Design
1
Has
Invoice
M
Products
Makes
Has
Order
Details
1
Payment
Physical Design
• Customer(Customer ID, Last name, First
Name, Address, City, State, Zip Code, Home #,
Cell #)
• Order and details(Order ID, Product ID order
date, quantity, occasions, Customer ID)
• Products(Product ID, Descriptions, Quantity,
Item Price)
• Invoice(Invoice ID, Invoice AMT, Date, Amount
Paid, Order ID)
• Payment(Payment ID, Payment type, Amount
Paid, Date Paid, Invoice ID)