Database Normalization and Logical Process Concept Paper

1403 Words6 Pages
Database Normalization and Logical Process Concept paper This short paper will explain with a simple example the process and the need of normalization in the most of the business databases. Complete proposal break down (Timeline phases, Financial phases) will be submitted per management request. Overview At first any database should be designed with the end user in mind. Logical database design, also referred to as the logical model, is the process of arranging data into logical, organized groups of objects that can easily be maintained. The logical design of a database should reduce data repetition or go so far as to completely eliminate it. The needs of the end user should be one of the top considerations when designing a database.…show more content…
Instead of one large table, there are now smaller, more manageable tables: EMPLOYEE_TBL, CUSTOMER_TBL, and PRODUCTS_TBL. The primary keys are normally the first columns listed in a table, in this case: EMP_ID, CUST_ID, and PROD_ID. The objective of the Second normal form is to take data that is only partly dependent on the primary key and enters that data into another table. Figure 3 illustrates the second normal form. According to the figure, the second normal form is derived from the first normal form by further breaking two tables down into more specific units. EMPLOYEE_TBL split into two tables called EMPLOYEE_TBL andEMPLOYEE_PAY_TBL. Personal employee information is dependent on the primary key (EMP_ID), so that information remained in theEMPLOYEE_TBL (EMP_ID, LAST_NAME, FIRST_NAME,MIDDLE_NAME, ADDRESS, CITY, STATE,ZIP, PHONE, and PAGER). On the other hand, the information that is only partly dependent on the EMP_ID (each individual employee) is used to populate EMPLOYEE_PAY_TBL(EMP_ID, POSITION, POSITION_DESC, DATE_HIRE,PAY_RATE, and DATE_LAST_RAISE). Notice that both tables contain the column EMP_ID. This is the primary key of each table and is used to match corresponding data between the two tables. CUSTOMER_TBL split into two tables called CUSTOMER_TBL andORDERS_TBL. What took place is similar to what occurred in theEMPLOYEE_TBL. Columns that were

More about Database Normalization and Logical Process Concept Paper

Get Access