Course Overview
|
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 Control
|
Course Calendar
|
|
|
Week 01
|
2
|
Advantages of DBMS and its User
|
|
3
|
Database Architecture I
|
Week 02
|
4
|
Database Architecture II
|
|
5
|
Database Application Development Process
|
|
6
|
Detailed Diagrams and Database Design
|
Assignment No 1
Week 03
|
7
|
Entity-Relationship Data Model
|
|
8
|
Key and its different types
|
Week 04
|
10
|
Cardinality and Roles in Relationships
|
Quiz No 1
|
11
|
Extended Entity Relationship Diagram
|
|
12
|
Practice Session of ER Data Model
|
Week 05
|
14
|
Logical Database Design
|
Graded Discussion Board
Week 06
|
16
|
Cardinality Constraints
|
Quiz No 2
Week 07
|
19
|
Functional Dependancy & Normalization
|
Midterm Exams
Week 08
|
22
|
Data Volume and Usage Analysis
|
|
23
|
Physical Records and Denormalization
|
|
24
|
Partitioning, Replication and Structured Query Language (SQL)
|
Week 09
|
25
|
Data Types and Rules of the Format
|
|
26
|
Data Definition Language (DDL)
|
|
27
|
Data Manipulation Language
|
Week 10
|
28
|
Insert and Select Statements
|
Assignment No 2
|
29
|
Where Clause and Operaors(Not, BETWEEN ,IN, Like)
|
|
30
|
Order By Clause, Having Clause and Functions
|
Week 11
|
32
|
Application Programs I
|
|
33
|
Application Programs II
|
Week 12
Quiz No 3
Week 13
Quiz No 4
Week 14
Week 15
Final Term Examination
|
|
|