Flower Shop

Scenario narrative

Rose from Rose's Flower Shop places her orders with suppliers of flowers for fresh flowers. She buys the flowers and then makes up the arrangements for her customers.

Suppliers receive Orders for Products. Information to be stored includes the Supplier’s name, description and price. She also keeps track of the Supplier name, phone number and email, as well as the supplier address for the order and any special notes.

KEY: Entity, Attribute, Relationship between Entities

The following relationships apply:

Each Order is placed with one Supplier, but each Supplier can have many Orders placed with them over time. For each Order there can be one or more Products (Different types of Flowers) bought, and each Product can be on many Orders.