Designing a database requires an understanding of the business functions you want to model. It also requires an understanding of the database concepts and features that you want to use to represent those business functions. Make sure that you accurately design the database to model the business, because it can be time-consuming to significantly change the design of a database after you implement it. A well-designed database also performs better.
View a one hour presentation that introduces the normalization rules. The video includes an example of applying the rules to a simple database design.
Describes the purpose of the database and how it affects the design. Provides guidelines for creating a database plan to fit your purpose.
Describes the characteristics of Online Transaction Process (OLTP) and Decision Support applications and their effect on the design considerations for a database.
Describes database normalization rules that help prevent mistakes in the database design.
Describes how to help protect the data integrity of the database.
Describes how to use extended properties to add descriptive or instructional text, input masks, and formatting rules as properties of objects in a database or of the database itself.
Provides procedures for estimating how large the database will be when it is filled with data.
Describes how to use files and filegroups to manage database growth, enhance backup and restore strategies, and improve database performance.