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

 
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 To teach basics of database management systems from initial stages of analysis to ultimate activities involving design and implementation.
Course Content The characteristics of database approach & relations, techniques and methodologies of Database Management Systems; Entity Relationship approach to data modeling (ER Diagrams), the relational model of DBMS, relational mapping, normalization and Structured Query Language (SQL), the contributions of DBMS to an organization’s operations, control and planning activities.
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
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 2 28
Mid-terms 1 2 2
Final examination 1 2 2
Total Work Load   Number of ECTS Credits 2 74

 
Course Learning Outcomes: Upon the successful completion of this course, students will be able to:

 
Weekly Detailed Course Contents
WeekTopicsStudy MaterialsMaterials
1 Introduction to Database
2 Database Environment, Database Development Process
3 Database Analysis, Modeling Data
4 Enhanced E-R Model and Business Rules
5 Database Design
6 Logical Database Model
7 Mid-term exam
8 Physical Database Design
9 Database Implementation
10 Database implementation with SQL
11 Database implementation with SQL
12 Client/Server Database Environment
13 Internet Database Environment
14 Data Warehousing
15 Review
16 Final

 
Contribution of Learning Outcomes to Programme Outcomes
P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11

  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