Đồ án, luận văn, do an, luan van

Database Management System - Chapter 11: Stored Procedures and Triggers
Outline 1. Database programming language background 2. Stored procedures 3. Triggers Motivation for Database Programming Languages A procedural language with an interface to one or more DBMSs. Interface allows a program to combine procedural statements with nonprocedural database access. Customization Batch processing Complex operation...
48 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 863 | Lượt tải: 0
Database Management System - Chapter 10: Application Development with Views
Background Creating views and using views Processing queries that reference views Updatable views Data requirements for hierarchical forms Data requirements for reports
36 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 866 | Lượt tải: 0
Database Management System - Chapter 9: Advanced Query Formulation with SQL- Part 2
Before beginning the animation, let's examine a SELECT statement containing a Type II nested query. Execution model of the Type II Nested query: - More complex execution model: nested loops - Nested query executes one time for each row in the outer query Example query: - Retrieve faculty who are not students - Type II nested query impleme...
6 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 973 | Lượt tải: 0
Database Management System - Chapter 9: Advanced Query Formulation with SQL - Part 1
Outer 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: 886 | Lượt tải: 0
Database Management System - Chapter 8: Physical Database Design
Overview 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: 921 | Lượt tải: 0
Database Management System - Chapter 7: Normalization of Relational Tables
Modification 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: 900 | Lượt tải: 0
Database Management System - Chapter 6: Developing Data Models for Business Databases
Guidelines 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: 890 | Lượt tải: 0
Database Management System - Chapter 5: Understanding Entity Relationship Diagrams
Notation 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: 874 | Lượt tải: 0
Database Management System - Chapter 4: Query Formulation with SQL
1. 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: 1111 | Lượt tải: 0
Database Management System - Chapter 3: The Relational Data Model
Relational 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: 908 | Lượt tải: 0