1 / 2

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

MIS3500 * Asper School of Business * Travica Exercise on Normalization - Solution. (a) Class diagram for Customer Order Management System. * made of 1. __ Fabric ___ FabricID FabName FabDescription. _Customer _ CustomerID CLastName CFirstName Address City State PostCode

nevan
Download Presentation

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

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MIS3500 * Asper School of Business * Travica Exercise on Normalization - Solution (a) Class diagram for Customer Order Management System * made of 1 __Fabric___ FabricID FabName FabDescription _Customer_ CustomerID CLastName CFirstName Address City State PostCode CTel 1 places * ___Order___ OrderNumber OrderDate EstRecDate ActDecDate __Product__ ProductID PName ListPrice * is for * * belongs to 1 _Category__ CategoryID CatName CatDescription * made by 1 _OrderProduct__ Quantity Discount _Manufacturer_ ManufacturerID MName MTel 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 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. _Category__ CategoryID CatName CatDescription __Product__ ProductID PName CategoryID FabricID ListPrice ManufactD * 1 (b) Schema for Customer Order Management System _Customer_ CustomerID CLastName CFirstName Address City State PostCode CTel ___Order___ OrderNumber CustomerID OrderDate EstRecDate ActDecDate 1 1 1 * __Fabric___ FabricID FabName FabDescription * 1 * 1 _Manufacturer_ ManufacturerID MName MTel * _OrderProduct__ OrderNumber ProductID Quantity Discount * Study carefully similarities and differences between (a) and (b). Run normalization test: 1NF – are there repeating sections in any table? 2 NF – in tables with combined keys (OrderProduct), do non-key attributes depend on the entire key? Is there a partial functional dependence between some non-key attribute? If yes, it’s not 2NF. 3 NF – do non-key attributes depend on the key only? Is there any dependence between non-key attributes (transitive dependence)?

More Related