week 4 Discussion 1
Many legacy systems require normalization. Identify at least two factors that should be considered in order to produce an optimal normalized set of tables when performing normalization. Include in your discussion a detailed example on how each factor would eliminate data redundancy.
Normalization is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency.
Redundant data wastes disk space and creates maintenance problems. If data that exists in more than one place must be changed, the data must be changed in exactly the same way in all locations. A customer address change is much easier to implement if that data is stored only in the Customers table and nowhere else in the database. Another example is do not use multiple fields in a single table to store similar data. For example, to track an inventory item that may come from two possible sources, an inventory record may contain fields for Vendor Code 1 and Vendor Code 2.
Optimal database design recognizes proper organization of table structures and relationships. Suggest at least two methods that can be used to improve the design of a database system.
If we are going to develop Database, we might as well make it look good. By doing this, we can improve the database ability to provide information and to enhance the operational characteristics. It is important to understand that normalization cannot be relied on to make designs by itself but will need to by create separately. The following two methods can be used to improve the design of database system.
Evaluate Primary Key Assignments
When adding specific entities to a database, it's important to understand the overall concept of how these entities are affecting the rest of the database. You will need focus down on specific entities, usually the
Normalization is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency.
Redundant data wastes disk space and creates maintenance problems. If data that exists in more than one place must be changed, the data must be changed in exactly the same way in all locations. A customer address change is much easier to implement if that data is stored only in the Customers table and nowhere else in the database. Another example is do not use multiple fields in a single table to store similar data. For example, to track an inventory item that may come from two possible sources, an inventory record may contain fields for Vendor Code 1 and Vendor Code 2.
Optimal database design recognizes proper organization of table structures and relationships. Suggest at least two methods that can be used to improve the design of a database system.
If we are going to develop Database, we might as well make it look good. By doing this, we can improve the database ability to provide information and to enhance the operational characteristics. It is important to understand that normalization cannot be relied on to make designs by itself but will need to by create separately. The following two methods can be used to improve the design of database system.
Evaluate Primary Key Assignments
When adding specific entities to a database, it's important to understand the overall concept of how these entities are affecting the rest of the database. You will need focus down on specific entities, usually the