ECTS - Introduction to Database Management Systems

Introduction to Database Management Systems (CMPE301) Course Detail

Course Name Course Code Season Lecture Hours Application Hours Lab Hours Credit ECTS
Introduction to Database Management Systems CMPE301 2 2 0 3 5
Pre-requisite Course(s)
N/A
Course Language English
Course Type N/A
Course Level Bachelor’s Degree (First Cycle)
Mode of Delivery Face To Face, Mix
Learning and Teaching Strategies Lecture, Demonstration, Discussion, Question and Answer, Problem Solving, Team/Group, Brain Storming, Project Design/Management.
Course Coordinator
Course Lecturer(s)
Course Assistants
Course Objectives This course is designed to teach fundamental database concepts, and methods to design and develop database systems. This course also aims at teaching database query languages.
Course Learning Outcomes The students who succeeded in this course;
  • Describe fundamental concepts of database systems
  • Practice on ER and EER data modeling
  • Design and implement a relational database system
  • Build database queries using SQL
Course Content Database concepts, database management systems (DBMS); relational data model and relational DBMS; use of ER-diagrams in database design; normalizing relations; structured query language (SQL); a popular DBMS in a laboratory environment.

Weekly Subjects and Releated Preparation Studies

Week Subjects Preparation
1 DB system concepts Chapter 1 (main text)
2 DB system concepts Chapter 2
3 ER model Chapter 3
4 ER model Chapter 3
5 EER model Chapter 4
6 Case Studies (ER/EER model) Lecture Notes
7 Relational data model & Relational DB concepts Chapter 5
8 ER- and EER-to-Relational Mapping Chapter 7
9 ER- and EER-to-Relational Mapping Chapter 7
10 Practice problems (Relational Mapping) Lecture Notes
11 Functional Dependencies Chapter 10
12 Normalization of Relational Tables Chapter 10
13 Normalization of Relational Tables Chapter 10
14 Case Studies (Normalization) SQL: Creating Tables and Including Constraints Lecture Notes Chapter 8
15 Review
16 Review

Sources

Course Book 1. “Fundamentals of Database Systems”, Elmasri & Navathe, 5th Edition, Pearson Addison Wesley, 2007.
Other Sources 2. Oracle 8i: A Practical Guide to SQL, PL/SQL, and Developer 6, Ali Yazıcı and Aydın Şekihanov, Atılım Yayınları, 2001.
3. Database Application Development & Design”, 3rd Ed., McGraw-Hill, M.V. Mannino, McGraw-Hill, 2005.
4. Database Systems, Molina, Ullman, Widom, 2nd edition, Pearson, Prentice Hall, 2009.
5. Database System Concepts, Silberschatz, Korth and Sudarshan, Mc Graw Hill, 2006
6. http://www.sql.org/, An SQL Tutorial

Evaluation System

Requirements Number Percentage of Grade
Attendance/Participation - -
Laboratory 3 20
Application - -
Field Work - -
Special Course Internship - -
Quizzes/Studio Critics - -
Homework Assignments - -
Presentation - -
Project 1 20
Report - -
Seminar - -
Midterms Exams/Midterms Jury 1 25
Final Exam/Final Jury 1 35
Toplam 6 100
Percentage of Semester Work 70
Percentage of Final Work 30
Total 100

Course Category

Core Courses
Major Area Courses
Supportive Courses X
Media and Managment Skills Courses
Transferable Skill Courses

The Relation Between Course Learning Competencies and Program Qualifications

# Program Qualifications / Competencies Level of Contribution
1 2 3 4 5
1 Adequate knowledge in mathematics, science and subjects specific to the computer engineering discipline; the ability to apply theoretical and practical knowledge of these areas to complex engineering problems.
2 The ability to identify, define, formulate and solve complex engineering problems; selecting and applying proper analysis and modeling techniques for this purpose.
3 The ability to design a complex system, process, device or product under realistic constraints and conditions to meet specific requirements; the ability to apply modern design methods for this purpose.
4 The ability to develop, select and utilize modern techniques and tools essential for the analysis and determination of complex problems in computer engineering applications; the ability to utilize information technologies effectively.
5 The ability to design experiments, conduct experiments, gather data, analyze and interpret results for the investigation of complex engineering problems or research topics specific to the computer engineering discipline.
6 The ability to work effectively in inter/inner disciplinary teams; ability to work individually
7 Effective oral and writen communication skills in Turkish; the knowledge of at least one foreign language; the ability to write effective reports and comprehend written reports, to prepare design and production reports, to make effective presentations, to give and to receive clear and understandable instructions.
8 Recognition of the need for lifelong learning; the ability to access information, to follow recent developments in science and technology.
9 The ability to behave according to ethical principles, awareness of professional and ethical responsibility; knowledge of the standards utilized in computer engineering applications.
10 Knowledge on business practices such as project management, risk management and change management; awareness about entrepreneurship, innovation; knowledge on sustainable development.
11 Knowledge on the effects of computer engineering applications on the universal and social dimensions of health, environment and safety; awareness of the legal consequences of engineering solutions.
12 An ability to describe, analyze and design digital computing and representation systems.
13 An ability to use appropriate computer engineering concepts and programming languages in solving computing problems.

ECTS/Workload Table

Activities Number Duration (Hours) Total Workload
Course Hours (Including Exam Week: 16 x Total Hours) 16 4 64
Laboratory 3 4 12
Application
Special Course Internship
Field Work
Study Hours Out of Class 16 1 16
Presentation/Seminar Prepration
Project 1 4 4
Report
Homework Assignments
Quizzes/Studio Critics
Prepration of Midterm Exams/Midterm Jury
Prepration of Final Exams/Final Jury 1 15 15
Total Workload 111