Samantha is a small e-commerce owner who would like a database to keep track of her clients and see what her product is most profitable. She also wants to keep track of the supplier so she can know what material is in high demand.
2- Stakeholder Analysis
Owner: She has access to all the website settings. She can make all the changes that the business needs to grow.
Supplier: Provides the appropriate material to make the jewelry.
Customer: Needs access to the website and the ability to place an order.
3-Solution Objectives
Digital tracking of supplier
Track the best customer
Find out the best product on the site
Improve price update
Improve customer service
Which customers bought more gold charms than silver ones?
Delete customers from the new table in the prior exercise who have spent more than $100 in the past year.
Calculation; Add up, how much have Samantha made of selling only the neckless
Create at least 2 views, (make a question for this query)