1 / 17

Beehive Florist

Beehive Florist. By: Mayra Valencia, Joe O’Brien, Jessica Valdovinos , & Kevin Kozlowski. The Company. Beehive Florist proudly serves the Baytown area . Family owned and operated.

mili
Download Presentation

Beehive Florist

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. Beehive Florist By: Mayra Valencia, Joe O’Brien, Jessica Valdovinos, & Kevin Kozlowski

  2. The Company • Beehive Florist proudly serves the Baytown area. • Family owned and operated. • We are committed to offering only the finest floral arrangements and gifts, backed by service that is friendly and prompt. “We always go the extra mile to make your floral gift perfect.”

  3. Services • We specialize in the following services:Large inventory of fresh flowers • Tropical • Plants • European/dish gardens • Contemporary and traditional arrangements • High-style floral arrangements • Silk arrangements • Dried floral arrangements • Weddings • Funeral designs • Extensive gift line • Gourmet and fruit baskets • Gift baskets • Greeting cards • Candles

  4. Find the Beehive Here Contact Info: Hours: Mon.- Fri.: 9:00 a.m. to 5:00 p.m. Saturdays: 9:00 a.m. to 1:00 p.m. Sundays : CLOSED Address: 201 W. Baker Rd. Baytown, TX 77521 Phone: (281) 427-0533  (800) 872-4483 Email: sales@beehiveflorist.com

  5. http://www.beehiveflorist.com/

  6. The Innovation • Due to the increasing demand on the upcoming holiday for flower orders, new efficient IT will be needed in order to keep up with the business’ demand. • Using the ACCESS Database, it would be easier to keep up with flower orders. • Smartphone integration will enable faster contact with the drivers and efficient delivery to the customers.

  7. Entities • Customer Information • Order & Details • Invoice Information • Drivers

  8. Entities & Attributes

  9. Local Design 1 Customer M Order M Makes Requires 1 1 Driver Makes 1 Invoice

  10. Physical Design Customer Information Orders & Details Invoice Information Drivers: (Bee ID, Last Name, First Name, Street, City, State, Postal Code, Telephone Number) ( Bee ID, Order #, Item Number, Item Price, Delivery Date, Delivery Address, Delivery City, Delivery State, Delivery Postal Code, Delivery Driver ID, Delivered) (Invoice ID, Order #, Amount Owed, Paid) (Delivery Driver ID, Last Name First Name, Van’s License Plate, Smartphone Number)

  11. Entity Relationships

  12. Customer Information

  13. Orders & Details

  14. Invoice

  15. Drivers

  16. Form Sample

  17. Report Sample

More Related