MIS3500 * Asper School of Business * Travica

1
MIS3500 Asper School of Business Travica
Exercise on Normalization - Solution
(a) Class diagram for Customer Order Management
System
Alternatives Product Fabric MM,
association class needed Product Manufacturer
MM Business rule on multiplicity 1. Each
customer places a number of orders while each
order is placed by only one customer. 2. An Order
can have many products, and each product can be
ordered many times. 3. A product is made of one
main fabric (alt. many), and a particular fabric
can be used in many products. 4. A product
belongs to one category, and each category can
have many products 5. A product is made by one
manufacturer (alt. many), and a manufacturer can
make many products.
2
(b) Schema for Customer Order Management System
Study carefully similarities and differences
between (a) and (b).