tailieunhanh - Lecture Fundamentals of Database Systems - Chapter 7: Relational database design by ER-and EERR-to-Relational mapping

Chapter 7 discusses how to design a relational database schema based on a conceptual schema design. This chapter presented a high-level view of the database design process, and in this chapter we focus on the logical database design or data model mapping step of database design. We present the procedures to create a relational schema from an Entity-Relationship (ER) or an Enhanced ER (EER) schema. | DATA B A sE SYSTEMS FOURTH EDITION ELMASRI NAVATHE Chapter 7 Relational Database Design by ER- and EERR-to-Relational Mapping PEARSON Addison Wesley Copyright 2004 Pearson Education Inc. Chapter Outline ER-to-Relational Mapping Algorithm Step 1 Mapping of Regular Entity Types Step 2 Mapping of Weak Entity Types Step 3 Mapping of Binary 1 1 Relation Types Step 4 Mapping of Binary 1 N Relationship Types. Step 5 Mapping of Binary M N Relationship Types. Step 6 Mapping of Multivalued attributes. Step 7 Mapping of N-ary Relationship Types. Mapping EER Model Constructs to Relations Step 8 Options for Mapping Specialization or Generalization. Step 9 Mapping of Union Types Categories . Elmasri Navathe Fundamentals of Database Systems Fourth Edition Chapter 7-3 Copyright 2004 Ramez Elmasri and Shamkant .