Datebase Notes

Course outline

Introduction

Database concepts and architecture

Data modeling

File Organization

Relational Data Model

answers to Mid-term Exam.

SQL language

SQL queries

JDBC - database application in Java

Oracle SQL 1

Oracle SQL 2

ER-to-Relational Mapping

Normalization

more about 3NF

Lossless-join

Index Techniques

Hierarchical Database

Signature Trees

Deductive Database

Review

Review 2 (general review)

Project

Database Projects

Sample Project Report

Assignments

assignment#1

figures of Chapter 3

Answers to assignment#1

assignment#2

Answers to assignment#2

figures of Chapter 7

assignment#3

assignment#4

figures of Chapter 14

figures of Chapter 25

Sample Questions for Final Exam.

Sample Questions for Final Exam.