MGS 404 - Database Management Systems

Instructor: Kumar Madurai

First Day Handout

Lecture 1 - Introduction to Database Systems

Lecture 2 - Conceptual Database Modeling - Entity Relationship Diagrams

Lecture 3 - Conceptual Database Modeling - Semantic Object Diagrams

Lecture 4 - Relational Data Models

Lecture 5 - Conceptual to Relational Model Transformation

Lecture 6 - Relation Algebra, Introduction to SQLPlus

Lecture 7 - SQLPlus Functions, Queries, Groups, Views

Lecture 8 - SQLPlus Reports

Lecture 9 - SQL Data Definition and Data Maintenance Commands

Lecture 10 - Advanced SQLPlus Commands and Concepts

Homework Assignment #1

Homework Assignment #1 - Solution

Homework Assignment #2

Homework Assignment #3

SQLPlus Report Example for the Video Rentals Database

SQLPlus Report Example for the School Database

Course Grades