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
Teachers: Mukhtiar Zamin, kashif nasr, Humaira Jabeen, Ashfaq Ahmed, Bilal Khan, Mukhtiar Zameen, Dr Imran Ali Khan, Dr. Muhammad Amir Khan, Somiya zaman, Maria Gul, Ali Iqbal, Demo Teacher
Category: Computer Science
Created on 3/8/2015 7:04:52 PM and last modified on 2/17/2021 8:14:02 PM
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.