1 / 23

Tropical Sense

Tropical Sense. By: Stephanie Peter & Ira Leigh IV. Contact Information. Tropical Sense Located : 15378 Bay Area Blvd, Houston, TX, 77063 Phone: 281-283-9000 Email: Tsense@hotmail.com Website: www.Tropicalsens.com. Business Background. Located in Clear Lake Texas

etana
Download Presentation

Tropical Sense

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. Tropical Sense By: Stephanie Peter & Ira Leigh IV

  2. Contact Information Tropical Sense Located : 15378 Bay Area Blvd, Houston, TX, 77063 Phone: 281-283-9000 Email:Tsense@hotmail.com Website: www.Tropicalsens.com

  3. Business Background • Located in Clear Lake Texas • Been in business for about 1 year in America • Provides affordable selections of tropical plants of variouscolors and species for: • Interior decorating • Landscaping • Weddings/Events

  4. Needs • Client information is being manually recorded • Products are book cataloged, need to be computerized. • Monetary transaction done by simple cash register • Need to monitor market demand to keep track of slow seasons

  5. Requirements • Apply computerized database to keep track of client information and transactions • Create website for efficient advertising and instant access to clients.

  6. Business Value • The new system that is implemented will lower expenses allowing more time to focus on the new technology . • This will increase sales, overall customer satisfaction • and service efficiency.

  7. Special issues • System must be built to enable all user to access information efficiently • Focus on customer demand for up coming seasons

  8. Entities • Customer • Order • Services • Employee • Invoices • Payments

  9. Entities and Attributes

  10. Entities and Attributes Cont

  11. LOGICALDESIGN Ismadefor l Is made on l l Payment Invoice M makes Customer l M Order M l requires Is done by M Services M Employee

  12. PHYSICAL DESIGN Customer ( Customer ID,LName, FName, Address, City, Zipcode, Telephone ) Order ( Order ID, Customer ID, Service ID, Employee ID , Date, Quantity, Species,) Service ( Service ID, Order ID, Service Type, Cost) Order –Service (Order ID, Service ID) Employees( Employee ID, L Name, F Name, Address, City, Zip Code, Telephone Number Invoices( Invoice ID, Order ID, Amount Billed, Date Billed) Payments (Payment ID, Invoice ID, Amount Paid, Date Paid, Balance)

  13. Relationships

  14. Payment BalanceReport

  15. Customer Information Form

  16. Employee Information Form

  17. Services Form

  18. Customer Query

  19. Employee Query

  20. Order service Query

  21. Relationship Marco

  22. Tables & Forms Switchboard

  23. Report & Queries Switchboard

More Related