TAILIEUCHUNG - Lecture Fundamentals of database systems: Chapter 5 - Emasri, Navathe

In this chapter, The contents concentrate on describing the basic principles of the relational model of data, begin by defining the modeling concepts and notation of the relational model, discussion of relational constraints that are considered an important part of the relational model and are automatically enforced in most relational DBMSs, defines the update operations of the relational model,. | Relational Model Concepts Relational Model Constraints and Relational Database Schemas Update Operations and Dealing with Constraint Violations The relational Model of Data is based on the concept of a Relation The strength of the relational approach to data management comes from the formal foundation provided by the theory of relations We review the essentials of the formal relational model in this chapter In practice there is a standard model based on SQL -this is described in Chapters 8 and 9 Note There are several important differences between the formal model and the practical model as we shall see Copyright 2007 Ramez Elmasri and Shamkant B. Navathe lide 5- 3 Copyright 2007 Ramez Elmasri and Shamkant B. Navathe lide 5-4 A Relation is a mathematical concept based on the ideas of sets The model was first proposed by Dr. . Codd of IBM Research in 1970 in the following paper A Relational Model for Large Shared Data Banks Communications of the ACM June 1970 The above paper caused a major revolution in the field of database management and earned Dr. Codd the coveted ACM Turing Award Informally a relation looks like a table of values. A relation typically contains a set of rows. The data elements in each row represent certain facts that correspond to a real-world entity or relationship In the formal model rows are called tuples Each column has a column header that gives an indication of the meaning of the data items in that column In the formal model the column header is called an attribute name or just attribute Copyright 2007 Ramez Elmasri and Shamkant B. Navathe lide 5- 5 Copyright 2007 Ramez Elmasri and Shamkant B. Navathe lide 5- 6 1 Attributes Relation Name STUDENT Tuples Name Ssn Home_phone Address Office_phone Age Gpa Benjamin Bayer 305-61-2435 373-1616 2918 Bluebonnet Lane NULL 19 Chung-cha Kim 381-62-1245 375-4409 125 Kirby Road NULL 18 Dick Davidson 422-11-2320 NULL 3452 Elgin Road 749-1253 25 Rohan Panchai 489-22-1100 376-9821 265 Lark

• Cơ sở dữ liệu
• Database systems
• Fundamentals of database systems
• Relational model concepts
• Relational database constraints
• Relational model constraints
• Relational database schemas
• 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
• The relational data model
• Database design
• Database programming techniques
• 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