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
|
|
2
|
Advantages of DBMS and its User
|
|
3
|
Database Architecture I
|
|
4
|
Database Architecture II
|
|
5
|
Database Application Development Process
|
|
6
|
Detailed Diagrams and Database Design
|
|
7
|
Entity-Relationship Data Model
|
|
8
|
Key and its different types
|
|
10
|
Cardinality and Roles in Relationships
|
|
11
|
Extended Entity Relationship Diagram
|
|
12
|
Practice Session of ER Data Model
|
|
14
|
Logical Database Design
|
|
16
|
Cardinality Constraints
|
|
19
|
Functional Dependancy & Normalization
|
|
22
|
Data Volume and Usage Analysis
|
|
23
|
Physical Records and Denormalization
|
|
24
|
Partitioning, Replication and Structured Query Language (SQL)
|
|
25
|
Data Types and Rules of the Format
|
|
26
|
Data Definition Language (DDL)
|
|
27
|
Data Manipulation Language
|
|
28
|
Insert and Select Statements
|
|
29
|
Where Clause and Operaors(Not, BETWEEN ,IN, Like)
|
|
30
|
Order By Clause, Having Clause and Functions
|
|
32
|
Application Programs I
|
|
33
|
Application Programs II
|
|
|
|