Course Information
SemesterCourse Unit CodeCourse Unit TitleT+P+LCreditNumber of ECTS CreditsLast Updated Date
4MIS 242Database Management for MIS3+0+03523.07.2026

 
Course Details
Language of Instruction English
Level of Course Unit Bachelor's Degree
Department / Program Management Information Systems (English)
Type of Program Formal Education
Type of Course Unit Compulsory
Course Delivery Method Face To Face
Objectives of the Course The aim of this course is to introduce students to the fundamental concepts of database systems, data modeling, and relational database design. The course also aims to develop students' skills in creating, querying, and managing databases using SQL.
Course Content Database environment and database development process, data modeling in organizations, Enhanced Entity-Relationship (E-R) modeling, relational model and logical database design, physical database design and performance considerations, introduction to SQL, data definition and data manipulation commands, and advanced SQL querying techniques.
Course Methods and Techniques Lecturing, discussion and submission.
Prerequisites and co-requisities None
Course Coordinator None
Name of Lecturers Associate Prof.Dr. Görkem Erdoğan
Assistants None
Work Placement(s) No

Recommended or Required Reading
Resources Hoffer, J. A., Venkataraman, R., & Topi, H. (2019). Modern Database Management (12th Global Edition). Pearson.
Course Notes 1.Coronel, C., Morris, S., and Rob, P. (2013) Database Principles: Fundamentals of Design, Implementation, and Management, 10th edition, Course Technology, Cengage Learning.
2.R. Elmasri & S.B. Navathe, (2011), Database Systems: Models, Languages, Design, and Application Programming, 6th edition, Pearson.


Planned Learning Activities and Teaching Methods
Activities are given in detail in the section of "Assessment Methods and Criteria" and "Workload Calculation"

Assessment Methods and Criteria
In-Term Studies Quantity Percentage
Mid-terms 1 % 40
Final examination 1 % 60
Total
2
% 100

 
ECTS Allocated Based on Student Workload
Activities Quantity Duration Total Work Load
Course Duration 14 3 42
Hours for off-the-c.r.stud 14 4 56
Mid-terms 1 2 2
Practice 10 4 40
Final examination 1 2 2
Total Work Load   Number of ECTS Credits 4,73333333333333 142

 
Course Learning Outcomes: Upon the successful completion of this course, students will be able to:
NoLearning Outcomes
1 Analyze database requirements and design relational databases using Entity-Relationship (E-R) modeling techniques.
2  Create  database tables and perform data insertion, update, and deletion operations using SQL.
3 Write basic and advanced SQL queries to effectively retrieve, filter, and report data from relational databases.

 
Weekly Detailed Course Contents
WeekTopicsStudy MaterialsMaterials
1 Introduction to database systems and the database development process
2 Data modeling in organizations and business rules
3 Introduction to Entity-Relationship (E-R) modeling
4 Enhanced E-R Model and Business Rules
5 E-R modeling applications and case studies
6 Conceptual database design applications
7 Review of Chapters 1-3 and modeling exercises
8 Midterm
9 Relational model and logical database design
10 Normalization and relational schema design
11 Physical database design and performance considerations
12 Introduction to SQL and Data Definition Language (DDL)
13 Data Manipulation Language (DML) and basic SQL queries
14 Advanced SQL queries, joins, grouping operations, and course review
15 Review
16 Final

 
Contribution of Learning Outcomes to Programme Outcomes
P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11
All 3 4 5 4 3 4 4 3 5 4 3
C1
C2
C3

  Contribution: 1: Very Slight 2:Slight 3:Moderate 4:Significant 5:Very Significant

  
  https://obs.ankarabilim.edu.tr/oibs/bologna/progCourseDetails.aspx?curCourse=50616&curProgID=5813&lang=en