Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Engineering Mathematics, Enhanced

Authors: Erwin Kreyszig

10th Edition

1119446848, 9781119446842

More Books

Students also viewed these Mathematics questions

Question

1. What will happen in the future

Answered: 1 week ago

Question

3. Avoid making mistakes when reaching our goals

Answered: 1 week ago