数据库原理与实用技术第六章数据库设计.pdf

Chapter 6 Chapter 6 Database DesignDatabase Design 有需要word版格式的可索取 1 Database Design 关系数据库是由一组关系组成的， 那么针对一个具体问题，应该如 何构造一个适合于它的数据模式， 即应该构造几个关系，每个关系 由哪些属性组成等。这是关系数 据库逻辑设计问题。 Database Design 6.1 Introduction to E-R Concepts 6.2 Further Details of E-R Modeling 6.3 Additional E-R Concepts 6.4 Case Study 6.5 Normalization: Preliminaries 6.6 Functional Dependencies 6.7 Lossless Decompositions 6.8 Normal Forms 6.9 Additional Design Considerations Database Design Introduction Logical database design, also known simply as database design or database modeling, studies basic properties and interrelationships among data items. It is the responsibility of the database administrator (DBA) to perform this logical database design, assigning the related data items of the database to columns of tables in a manner that preserves desirable properties. Database Design Introduction The most important test of logical design is that the tables and attributes faithfully reflect interrelationships among objects in the real world, and that this remains true after all likely database updates in the future. Two common techniques covered in this chapter are used to performed the task of database design: • entity-relationship approach (or E-R approach) • normalization approach Database Design One of the major features of logical database design is the emphasis it places on rules of interrelationships between data items . Three fundamental data classification objects introduced in this section are entities, attributes, and relationships. 6.1 Introduction to E-R Concepts Entities, Attributes, and Simple E-R Diagrams  Definition 6.1.1 Entity.