CS340: Introduction to Database Systems

intro about db

HOW DO I DESIGN AND IMPLEMENT A DATABASE db-p2

ER activity

ER model

Entities and attributes

Activity

ER relationships

ER relationship attribute

ER conventions

Intro

superclass_subclass

OO database

Generalization_specialization

Category

Activity

Sample 1

Sample 2

DBMS Languages

RELATIONAL MODEL COMPONENTS

Constraint 1&2

Constraint 3& other constraints

Update Operations

DBMS Component modules

Strong_weak entity

DDL

Mapping step3

Mapping step 4

Mapping step 5

Mapping step 6

Mapping step 7

Mapping step 8 & 9

Activity

Turorial 1: ER Diagram

Tutorial 2: ER & EER diagram

Tutorial 3: RELATIONAL MODEL

Tutorial 5: mapping

tutorial 6: Sql

tutorial 7: advanced Sql ( Part1)

tutorial 7: advanced Sql ( Part 2)

Tutorial 8 : Normalization

tutorial:9

Sample 1

Sample 2

Part 1

Part 2

Modify Operation

Nested Queries

Nested queries p2

Correlated nested queries

Exists and Unique

Outer Join

Other types of join

Aggregation

Group By

Views

RELATIONAL ALGABRA

Sample 1

Sample 2

Sample 3

informal guidelines

Functional Dependencies

DETERMINING FD’S CLOSURE

Basic Normalization definition

part 5

part 6

part 7

part 8

part 1

part 2

part 3

part 4

Final 223

EER Final Question