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
- 01 Analyze a problem to design a relational database.
- 02 recognize the fundamental concepts in relational theory
- 03 implement relational theory to working knowledge of Oracle DBMS Server
- 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
- 01 Elmasri & Navthe: Fundamentals of Database Systems, Addison Wesley, fifth ed., 2007.
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 theory
- L03 To give students a working knowledge of Oracle DBMS Server
- L04 To enable students in the use of SQL for DML and DDL
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 | - | - | - | - | - | - | - | - | - | - | - | - | - |