Database Systems

                                         BS 4 A&B

• Week1

  • Introduction

• Week2

  • HR Sample Schema

  • Oracle Installation & Introduction

    • • Guide

      • Sample Schema

  • SQL-Data Retrieval (Specify rows, specify columns)

• Week3

  • SQL-Data Retrieval (Arithmetic, Null)

  • DB Architecture

  • Assignment 01: DBMS Configuration

• Week4

  • DB-Data Models 

  • ACID

  • Activity: Mapping of a DB into three tier schema

• Week5

  • ER Modeling (Basics)

  • Project Initialization - Proposal

• Week6

• Week7

• Week8

• Week9

• Week10

• Week11

• Week12

• Week13

• Week14

Term-Project

Software

• Oracle DBMS

Books & References

• Database System - Catherine Ricardo

• An introduction to database systems - CJ Date