Er diagram and business rules
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
- Plain text response
- Attached file(s):
- reply.txt
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- eBusiness - What are the advantages & challenges of monitoring the effectiveness of online advertising? How, in your opinion, online advertising is received by consumers and business customers?
- eBusiness - What are the similarities & differences (and pros & cons) between traditional and online marketing?
- I/O operation & Internet security - 1.A process is said to be I/O-bound if it requires a lot of I/O operations, whereas a process that consists of mostly computations within the CPU/memory system is said to be compute-bound. If both a ...
- Explain how appropriate service levels need to be established for a network - I need a 3-4 page paper written to a networking group that explains how appropriate service levels need to be established for a network in each of the following areas: Availability Reliability ...
- eBusiness - Before developing a Website it is important to determine what functionality the customers would like. What types of market research will elicit such information from the customer base? Describe eMarke ...
