Course Objectives: |
This course looks at the theoretical and technical issues involved in the implementation of generalized databases used to store and retrieve data. Course contents include introduction to databases, entity relationship model, physical database design and access strategies, relational data model, SQL data manipulation language, theoretical data manipulation language, normal forms and logical database design, query processing, concurrency control and recovery in databases, implementation of a simple storage manager and design of a relational database. |
Course Content: |
To introduce database systems to students, to create database designs using E-R and relational data models for given database problems, to set up these designs in the form of tables in the physical database, to write and run the necessary queries on this physical database, to develop database applications using ADO.NET, stored procedures and triggers. |
Week |
Subject |
Related Preparation |
1) |
Introduction to databases |
NA |
2) |
Relational Data Model-Relational Model |
NA |
3) |
Relational Data Model-Relational algebra |
NA |
4) |
Database design-ER Data Model |
NA |
5) |
SQL-Constraints: Data-type, primary-key, second-key, not-null,column-constraints |
NA |
6) |
SQL-Data definition language, Data manipulation language |
NA |
7) |
SQL-Query language-Filtering and sorting operations |
NA |
8) |
Midterm |
Solving sample questions and homework, repeating the topic |
9) |
SQL-Subqueries- JOIN operations |
NA |
10) |
SQL-Grouping |
NA |
11) |
Database programming languages-T-SQL, PL/SQL |
NA |
12) |
SQL-Stored procedures/functions |
NA |
13) |
SQL-Triggers |
NA |
14) |
ADO.NET Applications |
NA |
15) |
Final Exam |
Solving sample questions and homework, repeating the topic |