DC10 DATABASE MANAGEMENT SYSTEMS

1. Database and Users 6 hours

1.1 Introduction

1.2 Characteristics of the Database Approach

1.3 Actors on the Scene

1.4 Workers behind the Scene

1.5 Advantages of using a DBMS

1.6 Implications of the Database Approach

1.7 When Not to use a DBMS

I [1 (1.1-1.8)]

2. Database System Concepts and Architecture 6 hours

2.1 Data Models, Schemas, and Instances

2.2 DBMS Architecture and Data Independence

2.3 Database Languages and Interfaces

2.4 The Database System Environment

2.5 Classification of Database Management Systems

I [2]

3. ER Diagrams 9 hours

3.1 Using High-level Conceptual Data Models for Database Design

3.2 Entity Types, Entity Sets, Attributes, and Keys

3.3 Relationships, Relationship Types, Roles, and Structural Constraints

3.4 Weak Entity Types

3.5 ER Diagrams, Naming Conventions, and Design Issues

I [3]

4. Record Storage and Primary File Organizations 9 hours

4.1 Introduction

4.2 Secondary Storage Devices

4.3 Parallelizing Disk Access Using RAID Technology

4.4 Buffering of Blocks

4.5 Placing File Records on Disk

4.6 Operations on Files

4.7 Heap Files

4.8 Sorted Files

4.9 Hashing Techniques

4.10 Other Primary File Organizations

I [5]

5. Relational Data Model 12 hours

5.1 Relational Model Concepts

5.2 Relational Constraints and Relational Database Schemas

5.3 Update Operations and Dealing with Constraint Violations

5.4 Relational Algebra Operations

5.5 Queries in Relational Algebra

5.6 QBE Overview

I [7, 9 (9.5)]

6. SQL 12 hours

6.1 Data Definition, Constraints, and Schema Changes in SQL

6.2 Queries in SQL

6.3 Insert, Delete, and Update Statements in SQL

6.4 Views in SQL

I [8 (8.1-8.5.3)]

7. Case Study: Oracle 6 hours

7.1 Basic Structure of the Oracle System

7.2 Database Structure and Its Manipulation in Oracle

7.3 Storage Organization in Oracle

I [10 (10.1-10.4.3)]

Text Book

I. “Fundamentals of Database Systems” by Ramez Elmasri and Shamkant B. Navathe, 3^rd Edition, Addison-Wesley 2000.