Contents

1. Introduction to Databases Management and Data Models
1. Introduction
2. Basic Concept and Definitions
3. Definition of DBMS
4. File Processing System Vs DBMS
4.1 Limitations of File Processing System
4.2 Comparison of File Processing System and DBMS
5. Advantages and Disadvantages of DBMS
5.1 Advantages of DBMS
5.2 Disadvantages of DBMS
6. Users of DBMS
7. View of Data and Three-Layer Architecture of DBMS
7.1 Three-Layer Architecture of DBMS
8. Data Independence
9. Overall System Structure
10. Features and Capabilities of DBMS
11. Data Model
11.1 Object Based Logical Model
11.2 Record Based Logical Model
12. Entity Relationship Model
12.1 Entity Sets
12.2 Entity Attributes
12.3 Relationship Sets
12.4 Mapping Cardinalities
13. Entity Relationship Diagram (ERD)
14. Extended Features of ERD
14.1 Specialization and Generalization
14.2 Attribute Inheritance
14.3 Aggregation
15. The Object-Oriented Model
16. Case Study for E-R Diagrams
17. Introduction to Relational Database Management Systems (RDBMS)
18. Terms
18.1 Properties of Relations
18.2 Database Schema
18.3 Why Not Put All Attributes in One Relation?
19. Keys
19.1 Primary Keys
19.2 Unique Keys
19.3 Surrogate Keys
19.4 Foreign Key
19.5 Super Key
19.6 Candidate Key
20. Relational Algebra
20.1 Basic Operations
20.2 Addition Operations

2. SQL (Structured Query Language)
1. Introduction
2. Integrity Constraints
3. Normal Form
4. Functional Dependency
5. First Normal Form
6. Second Normal Form
7. Third Normal Form
8. Boyce-Codd Normal Form (BCNF)
9. Examples
10. A Brief History of Databases
11. Structured Query Language (SQL)
12. SQL is a Standard
12.1 SQL Data Definition Language (DDL)
12.2 SQL Data Manipulation Language (DML)
12.3 Arithmetic and Aggregate Operators
12.4 SQL UPDATE Statement
12.5 SQL DELETE Statement
13. View
14. Constraints in SQL
15. SQL Case Study: Inventory Management System