98 Part I EXAM PREPARATION CHAPTER SUMMARY operations
98 Part I EXAM PREPARATION CHAPTER SUMMARY operations to print reports. Normalization can also be a detriment to server performance. In these instances, planned denormalization can provide for easier application development and better performance. To complete the logical modeling, you define the data integrity rules. As you move toward the finalization of the logical model and into the physical design, you need to make other decisions based on data types and application development. The process is never really finalized. As the database goes through its life cycle, changes will be needed to improve performance and/or meet the changing needs of the business. The next chapter elaborates on the integrity and design specifics for SQL Server. The physical foundations of database normalization, dependencies, and redundancy. After a moment of thought, you assume that the design did not even go through the process of database normalization, for if it did, all the deficiency and lack of flexibility would have been eliminated. You decide to normalize the database until you find its best fit: the third normal form (3NF). You resolve all dependencies and interdependencies and eliminate attribute redundancy. Not only do Jones and his users see a great improvement in the overall data retrieval and modification, but they also notice an immense improvement in the hard disk space the database consumes, which is due to the effectiveness of the removal of repeated data. This chapter covered a lot on data modeling and database design concepts. You should have a firm grasp that the hub of data modeling circles is attributes and relationships. Nonetheless, other concepts were also covered. Entities become tables in the physical design. Attributes become the columns of the tables. Relationships are used in the same manner in the physical database as they are in the logical model. Normalizing the ER model helps remove redundant data. This normalization, however, can cause many small entities that need complex
For high quality website hosting services please check tomcat web hosting website.