Question: Using the Chen method, please list the entities, list attributes, list the business rules if desired, draw the ERD with relations between entities, and identify
Using the Chen method, please list the entities, list attributes, list the business rules if desired, draw the ERD with relations between entities, and identify the primary keys and the secondary keys.
Jessica just graduated from Laurentian with a BBA. She wants to start her own flower business. She always dreamed of having a flower shop. She found online two suppliers, one in the US and one in Mexico that will provide her with many different varieties of flowers at a great discount price, 2 shipments a week at great prices. She has an agreement with her suppliers to order different species of flowers from each at great guaranteed prices.
She found a store, downtown Sudbury, that is already fully equipped and belonged to a retired barber. She invests a 20 000$ loan from the bank to adapt it to her needs, add fridges and equipment she will need. Jessica plans on selling her flowers arrangements for various traditional events, such as weddings, birthdays, funerals and parties. She wants to work with flowers available at any given season. So her arrangements will evolve with what her suppliers provide every week. She wants to develop customer loyalty programs by capturing customer data in her database. She asks you to develop a database for her that will track her customers, her sales and her various flower arrangements. She plans on having this database on a website, to allow for online orders and online payment and to display pictures of her flower arrangements.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
