Geo and Sally’s Flower Shoppe began 10 years ago as a small local flower shop by

Question

Geo and Sally’s Flower Shoppe began 10 years ago as a small local flower shop by two friends who loved creating beautiful flower arrangements for a reasonable price. Over time, Geo and Sally’s customer base began to expand as local customers told friends and family members around the country about the wonderful arrangements Geo and Sally could create for a very reasonable price. Besides flower arrangements, customers were interested in purchasing the unique pots they used for the arrangements, floral and garden accessories, garden flowers, vegetable plants, bushes, and even smaller trees. In addition to family customers, the business has expanded to include several small and even a few larger businesses in the local area. Through all of the expansion, flower arrangements remain the mainstay and primary profit center for the business. Geo’s brother Sammy suggested Geo and Sally set up an Internet storefront to sell more flower arrangements, which they did last year. They now find themselves owners of an ever-expanding Internet business with a loyal local customer base at their shop in Denver, Colorado. The shop itself has grown from the initial 500 square foot modified living room of an old home Geo used to live in to a new 6,000 square foot facility the company moved into two years ago. It includes a 1000 square foot showroom where they can display a variety of unique flower arrangements and containers. Arrangements in the showroom that do not sell within three days must be replaced so only the best items are seen and purchased by the large walk-in customer base. Geo and Sally’s information and data storage needs have exceeded the capacity of the current system. Sammy told Geo that he and Sally need to hire a consulting group to help them to implement a modern database system for accounting, payroll, inventory control, and sales:

The diagram should include classes, attributes, and relationships necessary to store all the information required to implement a successful system.

A list of class and attributes for this case study. Sample below:

Class

Attributes

Customer

C_Number (PK)

C_Lname

C_Fname

C_Address 1

C_Address 2

C_City

C_State

Class

Attributes

Customer

C_Number (PK)

C_Lname

C_Fname

C_Address 1

C_Address 2

C_City

C_State

Explanation / Answer

Employee_ID (PK)

FirstName

LastName

Sex

Dob

Date_of_Hired

Job Title

Salary

FlowerName (PK)

Quantity

CustomerName

CustomerAddress

Amount

Amount_Status

FlowerName (PK)

QuantityPurchased

Flowersold

Stackavailable

FlowerName (PK)

TotalStock

CustomerName

QuantitySold

Amount

AmountStatus

Class Attributes Payroll

Employee_ID (PK)

FirstName

LastName

Sex

Dob

Date_of_Hired

Job Title

Salary

Accounting

FlowerName (PK)

Quantity

CustomerName

CustomerAddress

Amount

Amount_Status

Inventory

FlowerName (PK)

QuantityPurchased

Flowersold

Stackavailable

Sale

FlowerName (PK)

TotalStock

CustomerName

QuantitySold

Amount

AmountStatus

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.