Question
Database case: Anna just graduated from Laurentian with a BBA. She wants to start her own candy business. She always dreamed of having a candy
Database case: Anna just graduated from Laurentian with a BBA. She wants to start her own candy business. She always dreamed of having a candy shop. She found online two suppliers, one in the US and one in Mexico that will provide her with many different varieties of candies at a great discount price, 2 shipments a week at great prices. She has an agreement with her suppliers to order different species of candies 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 counters, shelves, jars and bottles she will need. Jessica plans on selling her candies for various traditional events, such as weddings, birthdays, kids parties, graduations, themed celebrations, and special holidays such as Halloween. She asks you to develop a database for her that will track her customers, her sales and her various candies and prices. She plans on having this database on a website, to allow for online orders and online payment and to display pictures of her various candies. 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started