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 | 5. Semester | 2 | 2 | 0 | 3 | 5 |
| Pre-requisite Course(s) |
|---|
| N/A |
| Course Language | English |
|---|---|
| Course Type | Compulsory Departmental Courses |
| 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 | Gains adequate knowledge in mathematics, science, and relevant engineering disciplines and acquires the ability to use theoretical and applied knowledge in these fields to solve complex engineering problems. | |||||
| 2 | Gains the ability to identify, formulate, and solve complex engineering problems and the ability to select and apply appropriate analysis and modeling methods for this purpose. | X | ||||
| 3 | Gains the ability to design a complex system, process, device, or product under realistic constraints and conditions to meet specific requirements and to apply modern design methods for this purpose. | |||||
| 4 | Gains the ability to select and use modern techniques and tools necessary for the analysis and solution of complex engineering problems encountered in industrial engineering applications and the ability to use information technologies effectively. | X | ||||
| 5 | Gains the ability to design experiments, conduct experiments, collect data, analyze results, and interpret findings for investigating complex engineering problems or discipline specific research questions. | X | ||||
| 6 | Gains the ability to work effectively in intra-disciplinary and multi-disciplinary teams and the ability to work individually. | X | ||||
| 7 | Gains the ability to communicate effectively in written and oral form, acquires proficiency in at least one foreign language, the ability to write effective reports and understand written reports, prepare design and production reports, make effective presentations, and give and receive clear and intelligible instructions. | |||||
| 8 | Gains awareness of the need for lifelong learning and the ability to access information, follow developments in science and technology, and to continue to educate him/herself. | |||||
| 9 | Gains knowledge about behaviour in accordance with ethical principles, professional and ethical responsibility and standards used in industrial engineering applications | |||||
| 10 | Gains knowledge about business practices such as project management, risk management, and change management and develops awareness of entrepreneurship, innovation, and sustainable development. | |||||
| 11 | Gains knowledge about the global and social effects of industrial engineering practices on health, environment, and safety, and contemporary issues of the century reflected into the field of engineering; awareness of the legal consequences of engineering solutions. | |||||
| 12 | Gains skills in the design, development, implementation, and improvement of integrated systems involving human, material, information, equipment, and energy. | |||||
| 13 | Gains knowledge about appropriate analytical and experimental methods, as well as computational methods, for ensuring 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 | ||