Database Answers City Temple.

Printer Printer-friendly version.

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
UML Class Diagram for Shopping Carts
    Contact us if you would like an Access Database.

    These Business Rules define the conditions that the Database must meet ...
    1. A Customer can be associated with many Shopping Carts.
    2. A Preferred Customer is a Subtype of Customer.
    3. A Preferred Customer can be associated with many Credit Cards.
    4. A Credit Card can be associated with one, and only one, Preferred Customer.
    5. A Shopping Cart can be associated with one, and only one, Credit Card.
    6. A Shopping Cart can be associated with many Items to Purchase.
    7. An Item to Purchase can be associated with one and only one Product.
    8. A Product can be associated with many Items to Purchase.

    UML Class Diagram for Shopping Cart


    Barry Williams
    18th. May 2003
    Principal Consultant
    Database Answers

     
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map