1. File Organization

Introduction

1.1 Physical files and logical files

1.2 File operation

1.3 Special characters in files

1.4 Fields and record organization

1.5 Types of file organization

1.6 Choosing a file organization

2. Indexed File Organization

Introduction

2.1 Overview of indexes

2.2 Types of simple level ordered indexes

2.3 Multilevel indices

3. Introduction to DBMS

Introduction

3.1 Traditional file system vs DBMS

3.2 Describing and storing data

3.3 Levels of abstraction

3.4 Data independence

3.5 Queries in a DBMS

3.6 Structure of a DBMS

3.7 Users of a DBMS

3.8 Advantages of DBMS

3.9 The Database Admisistrator (DBA)

4. Conceptual Design (E-R Model)

4.1 Introduction

4.2 Basic concepts of the E-R model

4.3 Mapping constraints for relationship types

4.4 Keys

4.5 Weak entity sets

4.6 Notations used for E–R diagram

4.7 Relationship Type of degree higher than 2

4.8 Extended E–R Features

4.9 Conceptual design using E-R

4.10 Case study

5. Relational Data Model

5.1 Relational model concepts

5.2 Reduction of E–R schema into tables

5.3 Conversion of hospital E–R schema, Gmart to their respective tabular representations

5.4 Integrity constraints 10

6. Relational Algebra

Introduction

6.1 Fundamental operations

6.2 Addition operations

6.3 Some relational algebra queries

7. Structured Query Language (SQL)

Introduction

7.1 Data definition language

7.2 Basic structure of SQL

7.3 Order by clause and simple queries

7.4 Aggregate function

7.5 Joins

7.6 Nested queries

7.7 Data manipulation language

8. Functional Dependency

Introduction

8.1 Problems caused by redundancy

8.2 Functional dependencies

8.3 Desirable properties of decomposition

8.4 Normalization