• Bài giảng Database Systems - Chapter 9: Introduction to SQL Programming TechniquesBài giảng Database Systems - Chapter 9: Introduction to SQL Programming Techniques

    Summary  Assertions provide a means to specify additional constraints  Triggers are assertions that define actions to be automatically taken when certain conditions occur  Views create temporary (virtual) tables  A database may be accessed in an interactive mode  Most often, however, data in a database is manipulate via application pro...

    pdf7 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 2 | Lượt tải: 0

  • Bài giảng Database Systems - Chapter 8: SQL-99: SchemaDefinition, Constraints, and Queries and ViewsBài giảng Database Systems - Chapter 8: SQL-99: SchemaDefinition, Constraints, and Queries and Views

    Recap of SQL Queries  A query in SQL can consist of up to six clauses, but only the first two, SELECT and FROM, are mandatory. The clauses are specified in the following order: SELECT FROM

    [WHERE ] [GROUP BY ] [HAVING ] [ORDER BY ]  There ar...

    pdf13 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 4 | Lượt tải: 0

  • Bài giảng Database Systems - Chapter 7: Relational Database Design by ERand EERR-To-Relational MappingBài giảng Database Systems - Chapter 7: Relational Database Design by ERand EERR-To-Relational Mapping

    Chapter Summary  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: Ma...

    pdf6 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 1 | Lượt tải: 0

  • Bài giảng Database Systems - Chapter 6: The Relational Algebra and CalculusBài giảng Database Systems - Chapter 6: The Relational Algebra and Calculus

    QBE: A Query Language Based on Domain Calculus (Appendix C)  The language is very user-friendly, because it uses minimal syntax.  QBE was fully developed further with facilities for grouping, aggregation, updating etc. and is shown to be equivalent to SQL.  The language is available under QMF (Query Management Facility) of DB2 of IBM and...

    pdf6 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 2 | Lượt tải: 0

  • Bài giảng Database Systems - Chapter 5: The Relational Data Model and Relational Database ConstraintsBài giảng Database Systems - Chapter 5: The Relational Data Model and Relational Database Constraints

    Summary  Presented Relational Model Concepts  Definitions  Characteristics of relations  Discussed Relational Model Constraints and Relational Database Schemas  Domain constraints’  Key constraints  Entity integrity  Referential integrity  Described the Relational Update Operations and Dealing with Constraint Violations

    pdf8 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 1 | Lượt tải: 0

  • Bài giảng Database Systems - Chapter 4: Enhanced Entity-Relationship (EER) ModelingBài giảng Database Systems - Chapter 4: Enhanced Entity-Relationship (EER) Modeling

    Summary  Introduced the EER model concepts  Class/subclass relationships  Specialization and generalization  Inheritance  These augment the basic ER model concepts introduced in Chapter 3  EER diagrams and alternative notations were presented

    pdf8 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 2 | Lượt tải: 0

  • Bài giảng Database Systems - Chapter 3: Data Modeling Using the EntityRelationship (ER) ModelBài giảng Database Systems - Chapter 3: Data Modeling Using the EntityRelationship (ER) Model

    Chapter Summary  ER Model Concepts: Entities, attributes, relationships  Constraints in the ER model  Using ER in step-by-step conceptual schema design for the COMPANY database  ER Diagrams - Notation  Alternative Notations – UML class diagrams, others

    pdf8 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 1 | Lượt tải: 0

  • Bài giảng Database Systems - Chapter 2: Database System Concepts and ArchitectureBài giảng Database Systems - Chapter 2: Database System Concepts and Architecture

    Summary  Data Models and Their Categories  History of Data Models  Schemas, Instances, and States  Three-Schema Architecture  Data Independence  DBMS Languages and Interfaces  Database System Utilities and Tools  Centralized and Client-Server Architectures  Classification of DBMSs

    pdf9 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 3 | Lượt tải: 0

  • Bài giảng Database Systems - Chapter 1: Introduction: Databases and Database UsersBài giảng Database Systems - Chapter 1: Introduction: Databases and Database Users

    Summary  Types of Databases and Database Applications  Basic Definitions  Typical DBMS Functionality  Example of a Database (UNIVERSITY)  Main Characteristics of the Database Approach  Database Users  Advantages of Using the Database Approach  When Not to Use Databases

    pdf5 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 3 | Lượt tải: 0

  • Bài giảng Cơ sở dữ liệu - Chương 5 Ràng buộc toàn vẹnBài giảng Cơ sở dữ liệu - Chương 5 Ràng buộc toàn vẹn

    RBTV - Thuộc tính tổng hợp  Thuộc tính tổng hợp - Là thuộc tính có giá trị được tính toán từ các thuộc tính khác.  Khi CSDL có thuộc tính tổng hợp - RBTV bảo đảm quan hệ giữa thuộc tính tổng hợp và các thuộc tính nguồn.

    pdf40 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 2 | Lượt tải: 0