Reference no: EM13950379
Develop a database in MS Access and a set of reports to support a business like Amazon.com. The following business rules should be addressed.
· Customer's may order multiple items
· Customer browsing should be monitored so they can be emailed relevant advertising.
· Track inventory (Books, authors, publishers, availability)
· Support customer reviews of books
· Customer may have multiple credit cards on file
· Customers may have a wish list
· Customers can be friends of other customers, and view comments on wish list of their friends.
The following reports should be developed:
· List customer names and email addresses from the customer with the most sales to the least.
· List all books where quantity on hand is below 5.
· Report on books purchased by other customer's who purchased the same book as a particular customer.
· List a customer's friends and their wish list items showing Title, price and availability
· List book titles and total revenue from highest revenue producer to lowest
|
Create a violation of 1st normal form
: Find or create an example of a violation of a normal form that you would allow, tell why you are allowing the violation and explain how you would protect against anomalies.
|
|
Analyze of the following issues- fraternities and sororities
: Use all three perspectives (functionalism, conflict, and interactionism) to analyze one of the following issues: Fraternities and sororities, social networking sites, or employer/employee relations. Write a 700- to 1,050-word essay that includes di..
|
|
A new form of teeth whitening strips
: GoodBite is interested in selling a new form of teeth whitening strips. They dissolve in your mouth and leave less of a gunky residue feeling than current competitors' products do. Whitestrips seem to appeal to people 20-29 years old. Competitors' d..
|
|
Determine the change in exergy
: 1. Consider 100 kg of steam initially at 20 bar and 240°C as the system. Determine the change in exergy, in kJ, for each of the following processes:
|
|
Develop a database in ms access and support business
: Customers can be friends of other customers, and view comments on wish list of their friends.
|
|
Decision-maker such as your supervisor or ceo
: Beginning in Week 2, you will work through the weekly research stages and writing process toward the creation of an 8-12-page formal report. Topic suggestions are provided; however, if there is a topic you'd like to use that is not on the list, pl..
|
|
Prepare a determination and distribution of excess schedule
: Prepare a determination and distribution of excess schedule for the investment (a value analysis is not needed). Prepare all the eliminations and adjustments that would be made on the 20X1 consolidated worksheet.
|
|
How does imposing height restrictions affect emissions
: Draw a graph showing the shape of the housing price curve in a monocentric city with and without height restrictions, How does imposing height restrictions affect emissions?
|
|
Additional context for our mission and vision
: Adding some additional context for our Mission and Vision. Its basically a verbal of my thought process, to help bridge it into our paper - instead of our just the statements themselves.
|