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
- 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 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.
- 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.
- 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.
- Apply ethical principles, academic integrity, and responsible conduct of research in all phases of the research process, including data collection, analysis, reporting, and publication.
- Identify and address the social, legal, and ethical implications of information systems research and its applications within organizational and societal contexts.
- 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.
- 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.
- Collaborate and lead in interdisciplinary research environments, establishing productive scientific partnerships and managing research projects that integrate diverse academic perspectives.
- 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.
- Identify challenges and propose innovative, research-based solutions at the intersection of information systems, technology, and organizational strategy.
- Deliver advanced-level MIS courses, supervise graduate research, and nurture academic development through effective mentorship and scholarly teaching.
- 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 | - | - | - | - | - | - | - | - | - | - | - | - | - |