Skip to main content
TR

DATABASE MANAGEMENT SYSTEMS

Course
MISY343 - DATABASE MANAGEMENT SYSTEMS
Department
Master of Management Information Systems - English - Master
Course Type
Scientific Preparation
Status
Required
Language
English
Credit
0
ECTS
0
T+P+L
0 + 0 + 0
Course Coordinator(s)
Asst. Prof. Dr. Yasemin BAY
Prerequisite
-
Keywords
-

Course Description

-

DATABASE MANAGEMENT SYSTEMS

Evaluation Tools (Active Term)

Item Type Weight (%)
Midterm Midterm 30
Final Final 40
Project Project 20
Quiz1 Quiz 5
Quiz2 Quiz 5
Total 100

Course outcomes

  1. 01 Analyze a problem to design a relational database.
  2. 02 recognize the fundamental concepts in relational theory
  3. 03 implement relational theory to working knowledge of Oracle DBMS Server
  4. 04 apply SQL for DML and DDL

Course Syllabus

Week Topic
Week 1 Introduction to Database Management Systems
Week 2 DMBS concepts (Characteristics, levels of abstraction, advantages, query types )
Week 3 Relational database ( relational model, ER diagram)
Week 4 1 Week Break due to Covid19 Pandemy
Week 5 Introduction to Structured Query Language
Week 6 Restricting and Sorting Data
Week 7 Single Row Functions
Week 8 Conversion Functions
Week 9 Aggregate Functions
Week 10 Nested Queries - joins
Week 11 Nested queries - Subqueries
Week 12 Data Definition Languages (DDL) (table operations, constraints, indexing)
Week 13 Data Manipulation Language(DML)
Week 14 Normalization
Week 15 Revision

Reference Books & Course Materials

  1. 01 Elmasri & Navthe: Fundamentals of Database Systems, Addison Wesley, fifth ed., 2007.

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 theory
  3. L03 To give students a working knowledge of Oracle DBMS Server
  4. L04 To enable students in the use of SQL for DML and DDL

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 - - - - - - - - - - - - -