CS403 - Database Management Systems
Course Page
Mcqs
Q & A
Video
Downloads
Course Category: Computer Science/Information Technology
Course Level: Imdregraduate
Credit Hours: 3
Pre-requisites: CS101 CS201 CS304

Course Synopsis

CS403 offers students an introduction to the design and programming of database systems. In particular, the students will cover the ER (entity-relationship) approach to data modeling, the relational model of database management systems (DBMSs) and the use of query languages such as SQL. They will also cover relational algebra and the use of SQL in a programming environment and briefly touch upon query processing and role of transaction management.

Course Learning Outcomes

At the end of this course, you should be able to:
  • State the importance of DBMS and explain how DBMS is better than traditional File Processing Systems
  • Analyze the basic structure of Database and Recognize the different views of the database
  • Draw and Investigate Data Flow and Entity Relationship Diagrams
  • List Relational Data Models and Relational Algebra Operators
  • Use and Experiment common SQL Statements
  • Explain the terms Transaction Processing and Concurrency Controltents">Course Learning Outcomes

Course Contents

Introduction to Basic Database Concepts, Database Architecture, Database Planning, Conceptual Database Design, Logical Database Design, Transforming E-R Design to Relational Design, Data Definition Languages, Data Manipulation Languages, Normalization and Denormalization, Physical Database Design, Database Tools, Structured Query Language (SQL), Data Storage Concepts, Indexes and Views, Transaction Management, Concurrency Control

Course Related Links

The Oracle home page provides links to their line of products and solutions, corporate information and news, support, education, events, and partner information
A stepwise approach of using SQL server 2000. Good site for the beginners
Interactive Online SQL Training for Beginners
Course Instructor

Dr. Nayyer Masood
Ph.D Computer Science Bradford University, UK
Books

Modern Database Management by Fred R. McFadden, Jeffrey A. Hoffer, and Mary B. Prescott

Database Management Systems by Raghu Ramakrishnan and Johannes Gehrke

Database Systems: Principles Design and Implementation by Catherine M. Ricardo

Database Management by Fred R McFadden and Jeffrey A. Hoffer