Skip to main content
TR

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

  1. 01 TO DEVELOP SKILLS FOR DESIGNING AND IMPLEMENTING A RELATIONAL DATABASE
  2. 02 TO GIVE STUDENTS AN UNDERSTANDING OF THE FUNDAMENTAL CONCEPTS IN RELATIONAL THEOREY
  3. 03 TO GIVE STUDENTS A WORKING KNOWLEDGE OF IMPLEMENTATION OF DATABASE DESIGN
  4. 04 TO GIVE STUDENTS BACKGROUND ON STORED PROCEDURES, FUNCTIONS AND TRIGGERS
  5. 05 TO ENABLE STUDENTS IN THE USE OF SQL FOR DML AND DDL
  6. 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

  1. 01 "FUNDAMENTALS OF DATABASE SYSTEMS", ELMASRI AND NAVTHE, , 5th edition, 2007, ADDISON WESLEY

Learning Outcomes

  1. L01 TO DEVELOP SKILLS FOR DESIGNING AND IMPLEMENTING A RELATIONAL DATABASE
  2. L02 TO GIVE STUDENTS AN UNDERSTANDING OF THE FUNDAMENTAL CONCEPTS IN RELATIONAL THEOREY
  3. L03 TO GIVE STUDENTS A WORKING KNOWLEDGE OF IMPLEMENTATION OF DATABASE DESIGN
  4. L04 TO GIVE STUDENTS BACKGROUND ON STORED PROCEDURES, FUNCTIONS AND TRIGGERS
  5. L05 TO ENABLE STUDENTS IN THE USE OF SQL FOR DML AND DDL
  6. L06 TO INTRODUCE THE STUDENTS HOW TO DEVLOP DESKTOP APPLICATIONS WITH RDMS

Program Outcomes

  1. 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.
  2. Analyze complex organizational problems and design integrated information systems solutions by applying advanced MIS knowledge and synthesizing multiple theoretical perspectives.
  3. Develop and manage database systems and data-driven applications that ensure effective storage, retrieval, and use of organizational data in real-world contexts.
  4. Utilize data analytics, business intelligence tools, and data visualization techniques to extract actionable insights and support strategic, data-driven decision-making.
  5. Evaluate and apply emerging technologies such as AI, IoT, and Blockchain to drive digital transformation, enhance organizational performance, and formulate original research inquiries.
  6. Conduct independent and collaborative research using appropriate methodologies, and communicate findings effectively through scholarly writing and presentations suited to diverse audiences.
  7. dentify and address ethical, legal, and societal implications in the research, development, and use of information technologies, adhering to scientific and professional standards.
  8. Collaborate effectively in multidisciplinary teams and demonstrate leadership in addressing complex technology-driven challenges.
  9. Apply project management methodologies and tools to plan, execute, and monitor IT projects within organizational settings.
  10. Develop and integrate information systems that align with organizational goals and strategies, supporting innovation and sustainable growth.
  11. Perform comprehensive systems analysis and design, including requirements gathering, modeling, prototyping, and evaluating enterprise system architectures such as ERP, CRM, and SCM.
  12. 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 - - - - - - - - - - - - -