Download
1 / 16
160 likes | 327 Views
Orchard Palace Wedding Planner. Presented by: Samiara Hoque Greg Sobanja Aaron Blevins Godwin Mariadason. C ontact I nformation. 611 Baronridge Dr. Seabrook, TX. 77586 Phone: 281-457-PLAN Fax: 281-457-9917 Email: SCHOITY@yahoo.com Website: www.orchardplanner.com.
E N D
Presented by: Samiara Hoque Greg Sobanja Aaron Blevins Godwin Mariadason
Contact Information 611 Baronridge Dr. Seabrook, TX. 77586 Phone: 281-457-PLAN Fax: 281-457-9917 Email: SCHOITY@yahoo.com Website: www.orchardplanner.com
Business Background • We are located in Seabrook Area • Provide multi-cultural wedding • Offer fast and organized services for engaged couples • Affordable wedding packages for different priced budgets
Business Needs • Incorporate database to keep track of accounts payable & Receivable • Monitor appointments and arrangements • Maintain log delivery of final products • Keep track of customer information • Keep track of contracts and consumer needs
Value Added • Using Information Technology will help to build world-wide business • Create reports for decision-making process • Protection of customer financial privacy • Working with financial issues
Issues & Constraints • Sustain low employee turnover • Keeping to schedule commitments organized on time • Maintain customer base year round • Continue to provide low and competitive prices
Entities • Customer • Designer • Food/Cake • Location • Invoice • Payment
Logical Design Location 1 Requires M 1 M Makes Customer Event 1 Makes 1 Invoice 1 1 Customer Makes Payments
Physical Design Customer (Customer Id, LastName, FirstName, Address, Contact #) Event(Event Id, Floral Package #, Food/Cake, Food Type, Date) Location(Location Id, Address, City) Invoice (Invoice Id, Invoice Amount, Date, Paid) Payments (Payment Id, Total Amount, Amount Paid, Amount Due, Date Paid, PaymentType)
