Cis 109 Assignment 3

1082 words 5 pages
Logical Design
Gregory M Dowell
CIS 111
Professor Thakkar
25 February 2014

Logical Design The purpose of normalization is to create a stable set of relations is representative of the operations of an enterprise. By doing this we are able to reduce redundancy to save space and avoid inconsistencies in data. It also ensures that the design is free of certain updates, insertions, and deletion anomalies (Ricardo, 2012). With normalization as with most anything else there are advantages and disadvantages. The advantages of normalization are: ACID, which stands for atomicity, consistency, isolation, and durability. Atomicity means the transaction is a single unit. Either the entire set of actions is carried out or is not.
…show more content…
Taking into account the stages of normalization, the following is a breakdown of your organizations database to reflect the process of normalization from 1NF to 3NF. Item | Colors | Price | Tax | T-shirt | red, blue | 12.00 | 0.60 | Polo | red, yellow | 12.00 | 0.60 | T-shirt | red, blue | 12.00 | 0.60 | Sweatshirt | blue, black | 25.00 | 1.25 |

This table is not in first normal form because there are multiple items in the color field, duplicate records, and no primary key. The next table will show the database converted to first normal form. Here there are no redundant attributes. Item | Color | Price | Tax | T-shirt | red | 12.00 | 0.60 | T-shirt | blue | 12.00 | 0.60 | Polo | red | 12.00 | 0.60 | Polo | yellow | 12.00 | 0.60 | Sweatshirt | blue | 25.00 | 1.25 | Sweatshirt | black | 25.00 | 1.25 |

The previous table does not satisfy second normal form since price and tax depends on item, but not color. The following table will be able to be broken down more since the first normal form has been satisfied. Item | Color | T-shirt | red | T-shirt | blue | Polo | red | Polo | yellow | Sweatshirt | blue | Sweatshirt | black | Item | Price | Tax | T-shirt | 12.00 | 0.60 | T-shirt | 12.00 | 0.60 | Polo | 12.00 | 0.60 | Polo | 12.00 | 0.60 | Sweatshirt | 25.00 | 1.25 | Sweatshirt | 25.00 | 1.25 |

The above tables are in second normal form since all attributes now rely

Related

  • Cis 115 Week 3 Exercise Solution
    869 words | 4 pages
  • Week 3 Assignment
    1666 words | 7 pages
  • BUS610 Week 3 Assignment
    1682 words | 7 pages
  • Cis 210 Week 2 Assignment 1
    1408 words | 6 pages
  • CELTA ASSIGNMENT 3
    1151 words | 5 pages
  • LEG 500 Assignment 3
    3273 words | 14 pages
  • Bus 508 Assignment 3
    2003 words | 9 pages
  • Quality Management Assignment 3
    2082 words | 9 pages
  • Bus 207 Assignment 3
    1497 words | 6 pages
  • IS3220 Assignment 3
    990 words | 4 pages