TAILIEUCHUNG - Lecture Database management systems - Chapter 5: Relational database design by ER and EER-to-relational mapping

Chapter 5 - Relational database design by ER and EER-to-relational mapping. This chapter includes contents: Mapping of regular entity types, mapping of weak entity types, mapping of binary 1:1 relation types, mapping of binary 1:N relationship types, mapping of binary M:N relationship types, mapping of multivalued attributes, mapping of N-ary relationship types, options for mapping specialization or generalization, mapping of union types (categories). | Chapter 5 Relational Database Design by ER- and EER-to-Relational Mapping 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). Step 1: Mapping of Regular Entity Types Step 1: Mapping of Regular Entity Types. ◦ For each regular (strong) entity type E in the ER schema, create a relation R that includes all the simple attributes of E. ◦ Choose one of the key attributes of E as the primary key for R. ◦ If the chosen key of E is composite, the set of simple attributes that form it will together form the primary key of R. ER DIAGRAM FIGURE Result of mapping the COMPANY ER schema into a .

• Cơ sở dữ liệu
• Database management systems
• Lecture Database management systems
• Relational database design
• EER to relational mapping
• Mapping EER model
• Regular entity types
• Lecture Database Systems
• Database systems
• Database systems concepts
• Database systems architecture
• Database languages
• Data management systems framework
• File based system
• Characteristics of the database
• Data dictionary
• Fundamentals of database management systems
• Logical database design
• Physical database design
• Object oriented database management
• Data administration
• Bài giảng Hệ quản trị cơ sở dữ liệu
• Operating systems
• Attribute alias
• Database application development process
• Data flow diagrams
• Database design
• Lecture Distributed Database Management Systems
• Distributed Database Management Systems
• Bài giảng Hệ quản trị cơ sở dữ liệu phân tán
• Transaction management
• Database consistency
• Database development
• Relational databases
• Database environments
• Object database management systems
• Object database
• Distributed database systems
• Principles of distributed database systems
• Cơ sở dữ liệu phân tán
• Peer to peer data management
• Peer reference architecture
• Web data management
• Web models
• Entity relationship model
• ER Diagram
• ER model
• Relational model
• Relational data model
• Relational database
• Relation schema
• Database definition
• Commercial applications
• File processing system
• Database architecture
• Data independence
• Conceptual schema
• Physical implementation of the database
• Physical data independence
• Cross reference matrix
• Database modeling
• Entity relationship data model
• Semantic data model
• Conceptual database design
• Data flow diagram
• E R data model
• E R database design
• Mathematical relations
• Normalization summary
• Data processing
• Consistent state of the database
• Transaction terminates
• Transaction boundaries
• Traditional file processing system
• Database approach
• Distributed computing system
• Fragmentation transparency
• Operating system
• Data modeling
• Relational data retrieval
• Relational database model
• Introduction to MIS
• Management Information Systems
• Information systems
• Database applications