Introduction to Database Management Systems
COP-4710 -- Spring 2020
Instructor: Dr. Jai Navlakha
General Instructions
Grading Policy
Syllabus
Course-Outcomes
ASSIGNMENTS
Assignment-1
Assignment-2
COMPANY DATABASE FOR WinRDBI
Assignment-3
COMPANY Database - DDL
Assignment-4
Assignment-5
Assignment-6
NOTES AND VIDEOS
NOTES - DB DESIGN - 1
NOTES - DB DESIGN - 2
VIDEO - TUPLE REL. CALC.
VIDEO - TRC - DOMAIN REL. CALC.
VIDEO - DB DESIGN GUIDELINES
VIDEO - FUNCTIONAL DEP. - ARMSTRONG'S AXIOMS
VIDEO - ARMSTRONG'S AXIOMS - CONTD.
VIDEO - FUNCTIONAL DEP. CONTD.
VIDEO - PROOF & DISPROOF USING AA
VIDEO - NORMAL FORMS IN DATABASES.
VIDEO - BCNF & RELATIONAL DECOMPOSITION
VIDEO - DEP. PRESERVING & LOSSLESS DECOMPOSITION.
VIDEO - REL. DECOMP. LAST VIDEO.
VIDEO - Physical Storage.
VIDEO - File Organization .
VIDEO - Index Structures.
ADDITIONAL INFORMATION
Using WINRDBI
Rel. Alg. Syntax - WinRDBI
Example Queries - WinRDBI
Connecting to PostgreSQL - Method
Connecting to PostgreSQL - Power Point
Your PostgreSQL Account
Stored Procedure Examples
HENRY BOOKS Database - Part I - DDL
HENRY BOOKS Database - Part II - DDL
Stored Procedure Complex Example - One Publisher Stats
Stored Procedure Complex Example - All Publishers' Stats