Explore BrainMass

Explore BrainMass

    Er diagram and business rules

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    © BrainMass Inc. brainmass.com May 24, 2023, 1:20 pm ad1c9bdddf

    Solution Summary

    Er diagram and business rules are shown.