Database Management System I

UNIT ID :  H7DX 04

Content

Total Hours

1. Background of the Database

1.1 Database History

1.2 Traditional File-based systems vs. Databases

1.3 Database approach

1.4 Advantages and Disadvantages of DBMS

1.5 Roles in the Database Environment(Data Administrator(DA), Database Administrator(DBA), Database Designer, Application Developer, End User)

1.6 Database Environment

1.7 The Three-level ANSI-SPARC DBMS Architecture

1.8 Introduction to database languages

1.9 Introduction to Data Modeling

1.10 Functions and Components of DBMS

10

2. The Relational Model

2.1. Introduction to Data Model

2.2. Database Terminology

2.3. Introduction to Relational Data Structure

2.4. Database Relations

2.5. Properties of relations

2.6. Relational Keys

2.7. Relational Database Schema

2.8. Integrity constraints

2.8.1. Nulls

2.8.2. Entity Integrity

2.8.3. Referential Integrity

2.8.4. General Constraints

2.9. Views

2.9.1. Terminology

2.9.2. Purpose of Views

2.9.3. Updating Views

2.10. The Relational Algebra

2.10.1. Unary Operations

2.10.2. Set Operations

2.10.3. Join Operations

2.10.4. Division Operation

2.10.5. Aggregation and Grouping Operations

15

Content

Total Hours

3. Entity Relationship Modeling

3.1. Introduction to Entity Modeling terminology(Conceptual, Logical and Physical data Model)

3.2. Keys, Attributes Entity Types

3.3. Strong and Weak Entity Types

3.4. Attributes on Relationships

3.5. Structural Constraints

3.5.1. One-to-One (1:1) Relationships

3.5.2. One-to-Many (1:*) Relationships

3.5.3. Many-to-Many (*:*) Relationships

3.5.4. Multiplicity for Complex Relationships

3.5.5. Cardinality and Participation Constraints

3.6. Problems with ER Models

3.6.1. Fan Traps

3.6.2. Chasm Traps

15

4. Normalization

4.1. Introduction to Normalization

4.2. How Normalization Supports Database Design

4.3. Data Redundancy and Anomalies

4.3.1. Insertion Anomalies

4.3.2. Deletion Anomalies

4.3.3. Modification Anomalies

4.4. Functional Dependencies

4.4.1. Characteristics of Functional Dependencies

4.4.2. Identifying Functional Dependencies

4.4.3. Identifying the Primary Key for a Relation using Functional Dependencies

4.5. The Process of Normalization

4.6. First Normal Form (1NF)

4.7. Second Normal Form (2NF)

4.8. Third Normal Form (3NF)

4.9. General Definitions of 1NF 2NF and 3NF

10

Content

Total Hours

5. Structured Query Language (SQL)

5.1. History of SQL

5.2. SQL Commands

5.3. Data Definition language(DDL)

5.4. Data Manipulation Language (DML)

5.4.1. Data Types

5.4.2. Create and Drop Database

5.4.3. Create and Drop Table

5.4.4. Create and Drop Attributes

5.4.5. Create and drop Relations

5.4.6. Create and Drop Views

5.4.7. Discretionary Access Control

10

6. Database planning Techniques

6.1. The Information Systems Lifecycle

6.2. The Database System Development Lifecycle

6.3. Database Planning

6.4. System Definition

6.5. Requirements Collection and Analysis

6.6. Database Design6.6. Database Design

6.6.1. Graphical ER Diagrams Designing tools (Workbench, Query Browsers)

6.7. DBMS Selection

6.8. Data Conversion and Loading

6.9. Operational Maintenance

15

7. Database Management System (TUTORIAL 01)

5

8. Database Management System (TUTORIAL 02)

5