You are the accountant working for a large brick-and-mortar flower store and your boss have recently chartered you to start the project that would take the flower shop online. You are now tasked with build a data model that supports the business of an online flower store. Your boss browsed a few online flower shops and have decided the some basic requirements:1. Online store must be able to support 2 types of customers, business and retail.2. Customers must be able to choose flower based on different occasions3. Customer should be able to determine whether flower is a gift, place a note with each order, delivery options, and specifies the exact date for the deliveryYou need to do the following tasks: 1. State your business functions and assumptions. For example, to support searching flower by occasion, many flowers can be used for one occasion (such as birthday) and one flower may be suitable for several occasions (such as birthday and mother’s day). For each order, a customer may order more than one product but each order will be delivered to only one receiver in one location. (30%) 2. Build an E-R model. Identify major entities, their identifiers, attributes, and relationships. Indicate cardinalities for both sides of each relationship. Draw an E-R diagram using word processing or any drawing package. (70%)
Youare the accountant working for a large brick-and-mortar flower store and your boss have recently chartered you to start the project that would…
Give us your instructions.
Select the type of service you need: writing, calculations, or programming. We’ve created an intuitive order form that tells you what information to enter and where, so make sure to fill out each required field. Also, make your requirements as specific as possible. Don’t rush! Take your time and explain everything in detail how it works.
Proceed to checkout and enter your credit card details or PayPal login, how to pay. Follow the payment provider’s instructions to confirm the transaction.
Now your order is in our system! We’ll start processing it right away.