TAILIEUCHUNG - Lecture Database management systems - Chapter 3: The enhanced entity - relationship (EER) model

Chapter 3: The enhanced entity - relationship (EER) model. This chapter presents the following content: EER model; Subclasses, superclasses and inheritance; specialization and generalization; constrains and characteristics; union. | Chapter 3 The Enhanced Entity - Relationship (EER) Model EER Model The basic concepts of ER modeling are not powerful enough for some complex applications. The Enhanced ER model is the extension of the original ER model with new modeling constructs. EER Model Include all modeling concepts of basic ER Additional concepts: ◦ Subclasses/superclasses ◦ Specialization/generalization, ◦ Categories, attribute inheritance Iƒt is used to model applications more completely and accurately if needed It includes some object-oriented concepts, such as inheritance Outline Subclasses, Superclasses and Inheritance Specialization and Generalization Constrains and Characteristics Union Subclasses, Superclasses In many cases an entity type has numerous subgroupings of its entities that are meaningful and need to be represented explicitly because of their significance to the database application. Ex: EMPLOYEE may be further grouped into: ◦ SECRETARY, ENGINEER, TECHNICIAN, Based on the EMPLOYEE’s Job ◦ MANAGER EMPLOYEEs who are managers ◦ SALARIED_EMPLOYEE, HOURLY_EMPLOYEE Based on the EMPLOYEE’s method of .

• Cơ sở dữ liệu
• Database management systems
• Lecture Database management systems
• The enhanced entity
• Relationship model
• EER model
• Type inheritance
• 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
• Relational database design
• EER to relational mapping
• Mapping EER model
• Regular entity types
• 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