Database Systems

Course Objectives

Introduction

First half covers basic terminologies of database, role of databases in organizations,compare traditional file bases systems, need of modern database management systems and DBMS architecture and evolution. Second half covers Relational Algebra, Relational Databases, life-cycle of database systems including system definition, requirement collection and database designing at conceptual, logical and physical level with refined steps.At the end we cover advanced concepts related to write complex SQL queries, analysis and indexing, security, transaction management and query optimization.

Text Book

Database Systems A Practical Approach to Design, Implementation and Management, 4th Edition

By Thomas Connelly, Carolyn Begg

Discussion Group

WhatsApp Group Invitation Link for Database Systems

Teachers - Meet with faculty of this course

Main Teacher - Control the quality of course contents

Subject Expert Admin

Lecturer, Computer Science

Email: Ask personally

Office: CS Building, Room 305

Office Hours: Tue & Thu, 10:00–12:00

Specializes in Machine Learning, Data Science, and OOP. Leads the course design and lectures.

Alternate Teachers

                                                    kashif  nasr
                                                
Lecturer, Programming
Email: Ask personally
Teaches lab sessions for OOP and Data Structures.

                                                    Humaira Jabeen
                                                
Lecturer, Programming
Email: Ask personally
Teaches lab sessions for OOP and Data Structures.

                                                    Ashfaq Ahmed
                                                
Lecturer, Programming
Email: Ask personally
Teaches lab sessions for OOP and Data Structures.

                                                    Bilal Khan
                                                
Lecturer, Programming
Email: Ask personally
Teaches lab sessions for OOP and Data Structures.

                                                    Mukhtiar Zamin
                                                
Lecturer, Programming
Email: Ask personally
Teaches lab sessions for OOP and Data Structures.

                                                    Dr Imran Ali Khan
                                                
Lecturer, Programming
Email: Ask personally
Teaches lab sessions for OOP and Data Structures.

                                                    Dr. Muhammad Amir Khan
                                                
Lecturer, Programming
Email: Ask personally
Teaches lab sessions for OOP and Data Structures.

                                                    Somiya zaman
                                                
Lecturer, Programming
Email: Ask personally
Teaches lab sessions for OOP and Data Structures.

                                                    Maria Gul
                                                
Lecturer, Programming
Email: Ask personally
Teaches lab sessions for OOP and Data Structures.

                                                    Ali Iqbal
                                                
Lecturer, Programming
Email: Ask personally
Teaches lab sessions for OOP and Data Structures.

                                                    Demo Teacher
                                                
Lecturer, Programming
Email: Ask personally
Teaches lab sessions for OOP and Data Structures.

                                                    Adnan Jaleel
                                                
Lecturer, Programming
Email: Ask personally
Teaches lab sessions for OOP and Data Structures.

Subject Teacher Request - Database Systems

Main Teacher controls the access to his subject and coordinate with other teachers for the subject related materials.
Subject Teacher equally participates as its main teacher on all related materials i.e. Topics, Questions, Course outlines, Lectures etc.
Notes:
1. Subject main teacher will automatically change if contribution of another teacher exceeds for this subject.
2. Current main teacher will decide to approve or deny your request.

Status bar: H1 H2 H3

Contents:

Agree with all Teacher Terms.

Programs