Previous Topic: The CA 2E Approach to Data ModelingNext Topic: Developing a Conceptual Model


Example of a CA 2E Data Model

Following is an example of a data model used by CA 2E:

A Customer is Known by a Customer code

A Customer Has a Customer name

A Customer Has an Address

A Customer Has a Credit limit

A Product is Known by a Product number

A Product Has a Product price

An Order is Known by an Order number

An Order Refers to a Customer

An Order Has an Order status

An Order Has an Order date

An Order detail is Owned by an Order

An Order detail is Known by a Line number

An Order detail Refers to a Product

An Order detail Has an Order quantity