intro about db
HOW DO I DESIGN AND IMPLEMENT A DATABASE db-p2
ER model
ER activity
Entities and attributes
Activity
ER relationships
ER relationship attribute
ER conventions
Intro
superclass_subclass
OO database
Generalization_specialization
Category
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
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
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 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