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.

View More Free Quizzes
Related BrainMass Solutions

  • database requirements

    2) Draft an ER diagram with entities and relationships 3) Rework and Refine the ER diagram 4) Add key attributes to the diagram 5) Add non-key attributes 6) Add business and integrity rules 3rd Question: Data can be managed within a

  • Database Design

    ConceptDraw - cross platform software for creating ER (Entity-relationship ) Diagrams DB Visual ARCHITECT - Support UML Class Diagram and ERD ER/Studio - robust, easy-to use ER modeling tool from Embarcadero.

  • Mangement Analysis: Entity Relationship Diagram

    Following is the ER-diagram for given scenario: Please See the ER-diagram in the attachment. The diagram shows that main entities for the scenario are AlohaPets Company, pet owners and events.

  • Crow's Foot ERD

    Please find in the attached file the ER diagram created base on the problem description. This response provides guidelines on producing a data model segment on the Crow's Foot ERD segment.

  • Entity Relation Diagram for the given problem.

    The ER diagram is given in the Excel sheet along with the description. The Excel file shows the entity relationship diagram (ER diagram) for the given problem statement.

  • Entity-relationship diagram using the conceptual data model

    Please find the ER diagram with the given details in Visio and as PDF format. ER shapes are available in Vision 2010. There are different ER formats, please check with the Study Text as well.

  • ER Diagram: Tables, Attributes and Relationships

    Create an ER diagram based on the attachment that shows all of the tables, attributes, and relationships.

  • ER Diagram Developed

    130423 ER Diagram Developed Develop an ER diagram for the following: A database used in an order-entry system is to contain information about customers, items, and orders. The following information is to be included: ?

  • Explains why REA diagrams are not appropriate

    In the above section, the applicability of the REA diagram and its rules for designing an REA diagram are also been elaborated.

View More Related Solutions