1 / 16

Orchard Palace Wedding Planner

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.

chill
Download Presentation

Orchard Palace Wedding Planner

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Orchard Palace Wedding Planner

  2. Presented by: Samiara Hoque Greg Sobanja Aaron Blevins Godwin Mariadason

  3. Contact Information 611 Baronridge Dr. Seabrook, TX. 77586 Phone: 281-457-PLAN Fax: 281-457-9917 Email: SCHOITY@yahoo.com Website: www.orchardplanner.com

  4. 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

  5. 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

  6. 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

  7. 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

  8. Entities • Customer • Designer • Food/Cake • Location • Invoice • Payment

  9. Entities

  10. Logical Design Location 1 Requires M 1 M Makes Customer Event 1 Makes 1 Invoice 1 1 Customer Makes Payments

  11. 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)

  12. Entity Relationship

  13. Database Tables

  14. CustomerForm

  15. Reports

  16. Reports

More Related