Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(requirements): Getemtobuyit Company wants you to develop a customer database. They want to store all purchasers' orders and the products on each order. Shoppers of
(requirements): Getemtobuyit Company wants you to develop a customer database. They want to store all purchasers' orders and the products on each order. Shoppers of their company should be able to see all of their orders and every item on each order including the vendor of each product. Getemtobuyit would love to know via this database who their favorite product suppliers and best-selling products are at any point. For customers, Getemtobuyit Company would like to know common demographic type information. That is First Name, Last Name, Address, State, ZIP. In addition, they would like to be able to filter the data based on Gender, Race, and Age in the future. Each order should have a unique order number that the company will generate and also the date of the order. It will be important in the future to sort all orders based on their status (In Process, Shipped, Delivered). Each product should contain the name of the product, the cost of the product to Getemtobuyit and the retail price that it is being sold to the public. In addition, they will need to know how many of the items are in inventory and what category the product falls
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