ADVANCED DATABASE MANAGEMENT SYSTEMS
- Course
- ITEC502 - ADVANCED DATABASE MANAGEMENT SYSTEMS
- Department
- Information Technologies - English - Master
- Course Type
- Course
- Status
- Required
- Language
- English
- Credit
- 3
- ECTS
- 8
- T+P+L
- 3 + 0 + 0
- Course Coordinator(s)
- Asst. Prof. Dr. Dokun Iwalewa OLUWAJANA
- Prerequisite
- -
- Keywords
Course Description
This course provides a comprehensive foundation in relational database theory and practical skills for designing and implementing relational databases. Students will explore key concepts such as database normalization, schema design, and data integrity. Through hands-on activities, they will gain proficiency in SQL, focusing on Data Manipulation Language (DML) and Data Definition Language (DDL) commands. Additionally, the course introduces advanced database concepts, including stored procedures, functions, and triggers, to enhance database functionality and efficiency. Students will apply their knowledge to develop desktop applications integrated with relational database management systems (RDBMS), bridging the gap between theoretical understanding and practical application. By the end of the course, students will be equipped to design robust databases, implement complex database functionalities, and effectively utilize RDBMS in real-world application development scenarios
ADVANCED DATABASE MANAGEMENT SYSTEMS
Evaluation Tools (Active Term)
No evaluation items have been defined.
Course outcomes
- 01 TO DEVELOP SKILLS FOR DESIGNING AND IMPLEMENTING A RELATIONAL DATABASE
- 02 TO GIVE STUDENTS AN UNDERSTANDING OF THE FUNDAMENTAL CONCEPTS IN RELATIONAL THEOREY
- 03 TO GIVE STUDENTS A WORKING KNOWLEDGE OF IMPLEMENTATION OF DATABASE DESIGN
- 04 TO GIVE STUDENTS BACKGROUND ON STORED PROCEDURES, FUNCTIONS AND TRIGGERS
- 05 TO ENABLE STUDENTS IN THE USE OF SQL FOR DML AND DDL
- 06 TO INTRODUCE THE STUDENTS HOW TO DEVLOP DESKTOP APPLICATIONS WITH RDMS
Course Syllabus
| Week | Topic |
|---|---|
| Week 1 | INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS |
| Week 2 | DBMS CONCEPTS ( CHARACTERISTICS, LEVEL OF ABSTRACTION, ADVANTAGES, QUERY TYPES) |
| Week 3 | RELATIONAL DATABASE MODELING (RELATIONAL MODEL, ER DIAGRAM) |
| Week 4 | RELATIONAL ALGEBRA AND CALCULUS |
| Week 5 | STRUCTURES QUERY LANGUAGE, NESTED QUERIES, SUB QUERIES |
| Week 6 | DATA MANIPULATION LANGUAGE (DML) |
| Week 7 | DATA DEFINITION LANGUAGE (DDL) (TABLE OPERATIONS, CONSTRAINTS, INDEXING) |
| Week 8 | MIDTERM |
| Week 9 | NORMALIZATION |
| Week 10 | VIEWS, INDEXING |
| Week 11 | STORED PROCEDURES |
| Week 12 | STORED FUNCTIONS/TRIGGERS |
| Week 13 | DEVELOPING DATABASE DRIVEN APPLICATIONS |
| Week 14 | PROJECT PRESENTATION |
| Week 15 | - |
Reference Books & Course Materials
- 01 "FUNDAMENTALS OF DATABASE SYSTEMS", ELMASRI AND NAVTHE, , 5th edition, 2007, ADDISON WESLEY
Learning Outcomes
- L01 TO DEVELOP SKILLS FOR DESIGNING AND IMPLEMENTING A RELATIONAL DATABASE
- L02 TO GIVE STUDENTS AN UNDERSTANDING OF THE FUNDAMENTAL CONCEPTS IN RELATIONAL THEOREY
- L03 TO GIVE STUDENTS A WORKING KNOWLEDGE OF IMPLEMENTATION OF DATABASE DESIGN
- L04 TO GIVE STUDENTS BACKGROUND ON STORED PROCEDURES, FUNCTIONS AND TRIGGERS
- L05 TO ENABLE STUDENTS IN THE USE OF SQL FOR DML AND DDL
- L06 TO INTRODUCE THE STUDENTS HOW TO DEVLOP DESKTOP APPLICATIONS WITH RDMS
Program Outcomes
No program outcomes have been defined.
Po-Lo Matrix
The PO-LO matrix has not been populated yet.