Bài giảng Database Systems - Chapter 10: Functional Dependencies and Normalization for Relational DatabasesChapter Outline Informal Design Guidelines for Relational Databases Functional Dependencies (FDs) Definition, Inference Rules, Equivalence of Sets of FDs, Minimal Sets of FDs Normal Forms Based on Primary Keys General Normal Form Definitions (For Multiple Keys) BCNF (Boyce-Codd Normal Form)
9 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 1525 | Lượt tải: 0
Bài giảng Database Systems - Chapter 9: Introduction to SQL Programming TechniquesSummary 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...
7 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 956 | Lượt tải: 0
Bài giảng Database Systems - Chapter 8: SQL-99: SchemaDefinition, Constraints, and Queries and ViewsRecap 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... 13 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 1717 | Lượt tải: 0
Bài giảng Database Systems - Chapter 7: Relational Database Design by ERand EERR-To-Relational MappingChapter 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...
6 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 997 | Lượt tải: 1
Bài giảng Database Systems - Chapter 6: The Relational Algebra and CalculusQBE: 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...
6 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 1079 | Lượt tải: 0
Bài giảng Database Systems - Chapter 5: The Relational Data Model and Relational Database ConstraintsSummary 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
8 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 1052 | Lượt tải: 0
Bài giảng Database Systems - Chapter 4: Enhanced Entity-Relationship (EER) ModelingSummary 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
8 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 912 | Lượt tải: 0
Bài giảng Database Systems - Chapter 3: Data Modeling Using the EntityRelationship (ER) ModelChapter 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
8 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 1348 | Lượt tải: 0
Bài giảng Database Systems - Chapter 2: Database System Concepts and ArchitectureSummary 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
9 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 1057 | Lượt tải: 0
Bài giảng Database Systems - Chapter 1: Introduction: Databases and Database UsersSummary 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
5 trang | Chia sẻ: vutrong32 | Ngày: 17/10/2018 | Lượt xem: 1027 | Lượt tải: 0Chia sẻ:
