TAILIEUCHUNG - Database Systems: Lecture 3 - Nguyen Thanh Tung

Database Systems: Lecture 3 - EER Model presents about Limitations of Basic Concepts of the ER Model, Enhanced-ER (EER) Model Concepts, Subclasses and Superclasses, Specialization and Generalization, Specialization / Generalization Hierarchies, Lattices and Shared Subclasses. | EER Model Outline Limitations of Basic Concepts of the ER Model Enhanced-ER (EER) Model Concepts Subclasses and Superclasses Specialization and Generalization Specialization / Generalization Hierarchies, Lattices and Shared Subclasses Categories Formal Definitions of EER Model Database Design Modeling Tools Reading: [1]: Chapter 4, [2]: Chapter 12 Limitations of Basic Concepts of the ER model Since the 1980s there has been an increase in emergence of new database applications with more demanding requirements Basic concepts of ER modeling are not sufficient to represent requirements of newer, more complex applications Response is development of additional ‘semantic’ modeling concepts Enhanced-ER Model Concepts Includes all modeling concepts of basic ER Additional concepts: subclasses/superclasses, specialization/generalization, categories, attribute inheritance The resulting model is called the Enhanced-ER or Extended ER (E2R or EER) model It is used to model applications .

• Cơ sở dữ liệu
• Database Systems
• EER Model
• Formal Definitions of EER Model
• Database Design Modeling Tools
• Enhanced ER (EER) Model Concepts
• Basic Concepts of the ER Model
• Lecture Database Systems
• Database systems concepts
• Database systems architecture
• Database languages
• Data management systems framework
• Introduction to Database Systems
• Database system concepts
• Entity Relationship model
• Database security
• Distributed database systems
• Principles of distributed database systems
• Cơ sở dữ liệu phân tán
• Parallel database systems
• Load balancing
• Database architecture
• Database approach
• Database management systems
• Lecture Database management systems
• File based system
• Characteristics of the database
• Data dictionary
• Database integration
• Schema matching
• Fundamentals of database systems
• The relational data model
• Database design
• Database programming techniques
• Relational database constraints
• Database System
• Relational databases
• Relational database design algorithms
• Relational database systems
• Computer networks
• Practical Database Design
• Physical Database Design in Relational Databases
• An Overview of Database Tuning in Relational Systems
• Physical Database Design Decisions
• Data models
• Hierarchical model
• Designing a set of relations
• Relational decompositions
• Relational database schema
• Database users
• Database applications
• Typical DBMS functionality
• Databases and database users
• Relational calculus
• Physical database design
• Concurrency control techniques
• Database recovery techniques
• Distributed databases
• Multivalued dependencies
• Fundamentals of database management systems
• Logical database design
• Object oriented database management
• Data administration
• Design problem
• Dimensions of the problem
• Database development
• Database environments
• Object database management systems
• Object database
• Bài giảng Hệ quản trị cơ sở dữ liệu
• Operating systems
• Attribute alias
• Lecture Database system concepts
• Database system architectures
• Relational database design