MAN6905-Databases and Business Intelligence
“Flowers-4-Friends” is a new venture started by a group of young students, who want to setup an online flower ordering system. The website will enable customers to specify various combinations of flowers that will be delivered to a specified location and person, with an appropriate message.
The system needs to be able to store and validate customer details (provided online). Things such as the name, date of birth, phone number, and the delivery address must be entered. A valid email address must also be provided and stored, this will be used to provide a receipt of the order made and feedback on its delivery status.
The website will allow an order to be taken for bunches of flowers 24 hours of the day, 7 days a week. The order will include the preferred time of delivery, date, quantity and type of flowers to be delivered. A detailed description of the type or types of flowers that make up the bunch will be provided.
Flowers can include Roses, Tulips, Azealias, carnations and many others. The availability of the flowers depends on the season. Information on whether a type of flower is available or not will be kept up to date by the operators, based on information from their suppliers.
The flower warehouse is used to prepare the bunches of flowers for delivery. All delivery staff come to the flower warehouse to pickup their deliveries for the morning or afternoon shifts and make their deliveries as per orders. The organisers will group orders in similar areas together to minimise travel for delivery staff. Each of the delivery staff use a vehicle provided by the business which enables up to 30 bunches of flowers to be transported at any one time.
The order usually includes a message, which is usually placed with the bunch of flowers. Special instructions for the delivery staff are also provided, especially if the delivery requires special directions or specific person to be contacted and given flowers.
The young university students have asked you to come up with a data model that will enable them to store the data required for the business.
Provide the following for the new database that is in third normal form and free of anomalies:
1.Entity Relationship Diagram.
2.Relational Model (showing fields, primary keys, foreign keys and composite keys).
3.What assumptions have you made?