exe normalization solution 2012

							                                MIS3500 * Asper School of Business * Travica
                                   Exercise on Normalization - Solution

  (a) Class diagram for Sales Management System


                                                                      * made of 1
                                                                                   __Fabric___
        _Customer_ 1 places *   ___Order___             __Product__
                                              * has *                      *       FabricID
        CustomerID              OrderNumber             ProductID
                                                                                   Description
        LastName                Date                    CategoryID
        FirstName               EstRecDate              FabricID    * belongs to 1
        Address                 ActDecDate              ManufactID                    _Category__
        City                    Deposit                 ListPrice                     CategoryID
        State                   DoD                                                   Description
                                                                *
        PostCode                                                    made by
        Phone                                                          1 _Manufacturer_
                                       _OrderProduct__
                                                                          ManufacturerID
                                       Quantity
                                                                          Name
                                       Discount
                                                                          Phone
                                       SalePrice
Alternatives:
Product : Fabric = M:M, association class needed
Product : Manufacturer = M:M

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 on many times.
3. A product is made of one main fabric (alt.: many), and a particular fabric can be used in may 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.
(b) Schema for Sales Management System




                                                                               _Category__
       _Customer_            ___Order___   1    1 __Product__                  CategoryID
       CustomerID            OrderNumber          ProductID                    Description
       LastName              CustomerID           CategoryID
       FirstName             Date                 FabricID                       __Fabric___
       Address               EstRecDate           ListPrice                      FabricID
       City                  ActDecDate           ManufactD                      Description
       State                 Deposit
                             DoD                                *
       PostCode
                                                                    1
       Phone                                                            _Manufacturer_
                                       _OrderProduct__                  ManufacturerID
                                       OrderNumber                      Name
                                       ProductID                        Phone
                                       Quantity
                                       Discount
                                       SalePrice




     Study carefully similarities and differences between (a) and (b).