Note : This schedule is Tentative and can change , depending upon circumstance .
CS403-Database Management
Course Code: CS403 Category: Computer Science Title: Database Management Systems Credit Hours: 3
Instructor's Info
Name: Dr. Nayyer Masood Email: cs403@vu.edu.pk
- Introduction to Basic Database Concepts
- Database Architecture
- Database Planning
- Conceptual Database Design
- Logical Database Design
- Transforming E-R Design to Relational one
- 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
| Content | Lecture # | ||
| Introduction | 1 | ||
| Introduction to Data and Information | 2 | ||
| Database Architecture | 3 | ||
| Internal or Physical View / Schema | 4 | ||
| Database Application Development Process | 5 | ||
| Detailed DFD Diagrams | 6 | ||
| Entity-Relationship Data Model | 7 | ||
| Assignment # 1 | |||
| The Concept of Keys and its Types | 8 | ||
| Relationships in E-R Data Model | 9 | ||
| Cardinality | 10 | ||
| Inheritance | 11 | ||
| Steps in the study of System | 12 | ||
| Case Study: E-R Diagram of Examination System | 13 | ||
| Logical Database Design | 14 | ||
| Relational Data Model | 14 | ||
| Assignment # 2 | |||
| Database and Math Relations | 15 | ||
| Mapping Relationships | 16 | ||
| Quiz # 1 | |||
| Basic Operations of Relational Algebra | 17 | ||
| Join Operation | 18 | ||
| Assignment # 3 | |||
| Normalization | 19 | ||
| Normal Forms and Higher Normal Forms | 20 | ||
| Normalization Summary and Introduction to Physical DB design phase | 21 | ||
| The Physical Database Design Considerations and Implementation | 22 | ||
| Midterm Exam | |||
| Physical Record and Renormalization | 23 | ||
| Partitioning and Replication Concepts | 24 | ||
| Structured Query Language (SQL) | 25 | ||
| Categories of SQL Commands | 26 | ||
| Assignment # 4 | |||
| Data Manipulation Language | 27 | ||
| SQL Statements | 28 | ||
| Data Manipulation Language | 29 | ||
| Functions in SQL | 30 | ||
| Types of Joins | 31 | ||
| Application Programs | 32 | ||
| Quiz # 2 | |||
| Designing Input Forms | 33 | ||
| Classification of Physical Storage Media | 34 | ||
| Hashing | 35 | ||
| Hashing and Collision Handling | 37 | ||
| Indexes | 37 | ||
| Indexes (Continue) | 38 | ||
| Introduction to Views | 39,40 | ||
| Assignment # 5 | |||
| Updating Multiple Table | 41 | ||
| Transaction Management | 42 | ||
| Incremental Log with Deferred Updates | 43 | ||
| Concurrency Control and Introduction to Locking | 44 | ||
| Deadlocks & Deadlock Handling | 45 | ||
| Final Term | |||
Best Wishes,
Muhammad Ishfaq
Virtual University of Pakistan
MCS (Semester-02)Campus:Pakpattan
قل رب زدنی علماً۔
Home Page: www.zavia.site90.com
(Dedicated for MCS 2nd Semester Student Only)
Gmail: pak.nchd@gmail.com
For study materials, past papers and assignments,
Join VU School at www.VusCool.com
and www.VUGuys.com
CoooL Virtual University Students Google Group.
To post to this group, send email to coool_vu_students@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/coool_vu_students?hl=en
No comments:
Post a Comment