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 | Acquires sufficient knowledge in mathematics, natural sciences, and related engineering disciplines; gains the ability to use theoretical and applied knowledge in these fields in solving complex engineering problems. | |||||
| 2 | Gains the ability to identify, define, formulate, and solve complex engineering problems; acquires the skill 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 to meet specific requirements under realistic constraints and conditions, and applies modern design methods for this purpose. | |||||
| 4 | Develops the skills to develop, select, and use modern techniques and tools necessary for the analysis and solution of complex problems encountered in industrial engineering applications; gains the ability to effectively use information technologies. | X | ||||
| 5 | Gains the ability to design experiments, conduct experiments, collect data, analyze and interpret results for the investigation of complex engineering problems or discipline-specific research topics. | X | ||||
| 6 | Acquires the ability to work effectively in intra-disciplinary and multidisciplinary teams, as well as individual work skills. | X | ||||
| 7 | Acquires effective oral and written communication skills in Turkish; at least one foreign language proficiency; gains the ability to write effective reports, understand written reports, prepare design and production reports, make effective presentations, and give and receive clear instructions. | |||||
| 8 | Develops awareness of the necessity of lifelong learning; gains the ability to access information, follow developments in science and technology, and continuously renew oneself. | |||||
| 9 | Acquires the consciousness of adhering to ethical principles, and gains professional and ethical responsibility awareness. Gains knowledge about the standards used in industrial engineering applications. | |||||
| 10 | Gains knowledge about practices in the business life such as project management, risk management, and change management. Develops awareness about entrepreneurship and innovation. Gains knowledge about sustainable development. | |||||
| 11 | Gains knowledge about the universal and social dimensions of the impacts of industrial engineering applications on health, environment, and safety, as well as the problems reflected in the engineering field of the era. Gains 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 | ||