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 Lecturer(s) |
|
| 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;
|
| 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 | ||