Purchase Solution

Er diagram and business rules

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution

Solution Summary

Er diagram and business rules are shown.

Purchase this Solution

Free BrainMass Quizzes
Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Javscript Basics

Quiz on basics of javascript programming language.

C# variables and classes

This quiz contains questions about C# classes and variables.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.