Skip to main content
TR

ADVANCED DATABASE MANAGEMENT SYSTEMS

Course
MISY640 - ADVANCED DATABASE MANAGEMENT SYSTEMS
Department
Management Information Systems - English - PhD
Course Type
Course
Status
Required
Language
English
Credit
3
ECTS
0
T+P+L
3 + 0 + 0
Course Coordinator(s)
-
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 mastery of advanced research methodologies (quantitative, qualitative, and mixed methods) by critically analyzing literature, identifying research gaps, and designing original studies that contribute to MIS theory and practice.
  2. Conduct and defend an original doctoral dissertation that reflects independent scholarly inquiry, academic rigor, and a significant contribution to the advancement of knowledge in MIS.
  3. Exhibit readiness for thesis monitoring and defense by articulating the philosophical foundations of research paradigms, positioning one's research within these frameworks, and responding to scholarly critique.
  4. Apply ethical principles, academic integrity, and responsible conduct of research in all phases of the research process, including data collection, analysis, reporting, and publication.
  5. Identify and address the social, legal, and ethical implications of information systems research and its applications within organizational and societal contexts.
  6. Employ advanced data science techniques, including statistical modeling, machine learning, and AI-based analytics, to examine complex datasets and extract meaningful insights in MIS research.
  7. Recognize and evaluate emerging technologies such as artificial intelligence, big data, blockchain, and the Internet of Things, assessing their transformative impact on organizational processes and digital ecosystems.
  8. Collaborate and lead in interdisciplinary research environments, establishing productive scientific partnerships and managing research projects that integrate diverse academic perspectives.
  9. Publish high-quality research in peer-reviewed journals, present findings at international conferences, and actively engage in academic service such as journal reviewing, conference organizing, and committee participation.
  10. Identify challenges and propose innovative, research-based solutions at the intersection of information systems, technology, and organizational strategy.
  11. Deliver advanced-level MIS courses, supervise graduate research, and nurture academic development through effective mentorship and scholarly teaching.
  12. Develop advanced information systems and decision support systems that align IT capabilities with organizational strategies using systems thinking and innovative design methodologies.

Po-Lo Matrix

LO Average
L01 - - - - - - - - - - - - -
L02 - - - - - - - - - - - - -
L03 - - - - - - - - - - - - -
L04 - - - - - - - - - - - - -
L05 - - - - - - - - - - - - -
L06 - - - - - - - - - - - - -