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 An ability to apply knowledge of mathematics, science and engineering to Industrial Engineering; an ability to apply theoretical and practical knowledge to model and solve engineering problems.
2 An ability to identify, formulate and solve complex engineering problems; an ability to select and apply proper analysis and modeling methods. X
3 An ability to design a complex system, process, tool or component to meet desired needs within realistic constraints; an ability to apply modern design.
4 An ability to develop, select and put into practice techniques, skills and modern engineering tools necessary for engineering practice; an ability to use information technology effectively. X
5 An ability to design, conduct experiments, collect data, analyze and interpret results for the study of complex engineering problems or disciplinary research topics. X
6 An ability to work individually, on teams, and/or on multidisciplinary teams. X
7 Ability to communicate effectively in Turkish orally and in writing; knowledge of at least one foreign language; effective report writing and understand written reports, preparing design and production reports, making effective presentations, giving and receiving clear and understandable instruction.
8 A recognition of the need for, and an ability to engage in life-long learning; an ability to use information-seeking tools and to follow the improvements in science and technology.
9 An ability to behave according to the ethical principles, an understanding of professional and ethical responsibility. Information on standards used in industrial engineering applications.
10 Knowledge of business applications such as project management, risk management and change management. A recognition of entrepreneurship, innovativeness. Knowledge of sustainable improvement.
11 Information on the effects of industrial engineering practices on health, environment and security in universal and societal dimensions and the information on the problems of the in the field of engineering of the era. Awareness of the legal consequences of engineering solutions.
12 An ability to design, development, implementation and improvement of integrated systems that include human, materials, information, equipment and energy.
13 Knowlede on appropriate analytical, computational and experimental methods to provide system integration.

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