Database Management System - Chapter 9: Advanced Query Formulation with SQL - Part 1Outer join problems Type I nested queries Type II nested queries and difference problems Nested queries in the FROM clause Division problems Null value effects
37 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 521 | Lượt tải: 0
Database Management System - Chapter 8: Physical Database DesignOverview of Physical Database Design File Structures Query Optimization Index Selection Additional Choices in Physical Database Design
70 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 507 | Lượt tải: 0
Database Management System - Chapter 7: Normalization of Relational TablesModification anomalies Functional dependencies Major normal forms Relationship independence Practical concerns Modification Anomalies Unexpected side effect Insert, modify, and delete more data than desired Caused by excessive redundancies Strive for one fact in one place
36 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 550 | Lượt tải: 0
Database Management System - Chapter 6: Developing Data Models for Business DatabasesGuidelines for analyzing business information needs Transformations for generating alternative designs Finalizing an ERD Schema Conversion Characteristics of Business Data Modeling Problems Poorly defined Conflicting statements Wide scope Missing details Many stakeholders Requirements in many formats Add structure Eliminate irrelevant...
38 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 508 | Lượt tải: 0
Database Management System - Chapter 5: Understanding Entity Relationship DiagramsNotation basics Understanding relationships Generalization hierarchies Business rule representation Diagram rules Alternative notations
46 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 498 | Lượt tải: 0
Database Management System - Chapter 4: Query Formulation with SQL1. Background 2. Getting started 3. Joining tables 4. Summarizing tables 5. Problem solving guidelines 6. Advanced problems 7. Data manipulation statements What is SQL? Structured Query Language Language for database definition, manipulation, and control International standard Standalone and embedded usage Intergalactic database speak
45 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 588 | Lượt tải: 0
Database Management System - Chapter 3: The Relational Data ModelRelational model basics Integrity rules Rules about referenced rows Relational Algebra Tables Relational database is a collection of tables Heading: table name and column names Body: rows, occurrences of data
43 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 534 | Lượt tải: 0
Database Management System - Chapter 2: Introduction to Database Management (tt)Development Alternatives Difficulties Operational system is produced late Rush to begin implementation Requirements are difficult to capture Alternative methodologies Spiral approaches Rapid application development Prototypes may reduce risk
27 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 503 | Lượt tải: 0
Database Management System - Chapter 1: Introduction to Database ManagementFirst course in database management Practical textbook Fundamentals of relational databases Data modeling and normalization Database application development Database administration and database processing environments Detailed material
28 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 545 | Lượt tải: 0
Bài giảng Cấu trúc dữ liệu và Giải thuật - Ngăn xếp và Hàng Đợi - Phạm Ngọc Nam1. Stack (Ngăn xếp) Giới thiệu Các thao tác cơ bản Các ứng dụng 2. Queue (Hàng Đợi) Giới thiệu Các thao tác cơ bản Ứng dụng
30 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 885 | Lượt tải: 1
