ADVANCED DATABASE MANAGEMENT SYSTEMS
- Course
- MISY540 - ADVANCED DATABASE MANAGEMENT SYSTEMS
- Department
- Master of Management Information Systems - English - Master
- Course Type
- Course
- Status
- Required
- Language
- English
- Credit
- 3
- ECTS
- 0
- T+P+L
- 3 + 0 + 0
- Course Coordinator(s)
- Asst. Prof. Dr. Dokun Iwalewa OLUWAJANA
- Prerequisite
- -
- Keywords
- -
Course Description
-
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
- Demonstrate advanced knowledge of core concepts and theoretical frameworks in Management Information Systems, and apply them to develop innovative models that reflect current advancements in the field.
- Analyze complex organizational problems and design integrated information systems solutions by applying advanced MIS knowledge and synthesizing multiple theoretical perspectives.
- Develop and manage database systems and data-driven applications that ensure effective storage, retrieval, and use of organizational data in real-world contexts.
- Utilize data analytics, business intelligence tools, and data visualization techniques to extract actionable insights and support strategic, data-driven decision-making.
- Evaluate and apply emerging technologies such as AI, IoT, and Blockchain to drive digital transformation, enhance organizational performance, and formulate original research inquiries.
- Conduct independent and collaborative research using appropriate methodologies, and communicate findings effectively through scholarly writing and presentations suited to diverse audiences.
- dentify and address ethical, legal, and societal implications in the research, development, and use of information technologies, adhering to scientific and professional standards.
- Collaborate effectively in multidisciplinary teams and demonstrate leadership in addressing complex technology-driven challenges.
- Apply project management methodologies and tools to plan, execute, and monitor IT projects within organizational settings.
- Develop and integrate information systems that align with organizational goals and strategies, supporting innovation and sustainable growth.
- Perform comprehensive systems analysis and design, including requirements gathering, modeling, prototyping, and evaluating enterprise system architectures such as ERP, CRM, and SCM.
- Assess and mitigate organizational information security risks by applying appropriate principles, technologies, and best practices in cybersecurity.
Po-Lo Matrix
| LO | Average | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| L01 | - | - | - | - | - | - | - | - | - | - | - | - | - |
| L02 | - | - | - | - | - | - | - | - | - | - | - | - | - |
| L03 | - | - | - | - | - | - | - | - | - | - | - | - | - |
| L04 | - | - | - | - | - | - | - | - | - | - | - | - | - |
| L05 | - | - | - | - | - | - | - | - | - | - | - | - | - |
| L06 | - | - | - | - | - | - | - | - | - | - | - | - | - |