Question: how to draw ERD modeling based on this. You are the accountant working for a large brick-and-mortar flower store and your boss recently chartered you

how to draw ERD modeling based on this. how to draw ERD modeling based on this. You are the accountant

You are the accountant working for a large brick-and-mortar flower store and your boss recently chartered you to start an AIS project that would take the flower shop online. You are now tasked with building a data model that supports the business of an online flower store. Your boss browsed a few online flower shops and have decided 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 occasions. 3. 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 delivery. In analyzing the business, you have also found the following information about the product: 1. 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). 2. For each order, a customer may order more than one product but each order will be delivered to only one receiver in one location. 3. The delivery address may not be the same as the customer's billing address. You need to complete the following tasks: 1. The Business Rules (30%): State your business functions and assumptions based on the requirements and information that you have gathered about the store and its product. 2. 3. The ERD diagram (70%): Identify major entities, their identifiers, attributes, and relationships. Indicate the cardinalities for both sides of each relationship. Draw an E-R diagram using word processing or any drawing software

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!