ECTS - Database Design and Management
Database Design and Management (CMPE341) Course Detail
| Course Name | Course Code | Season | Lecture Hours | Application Hours | Lab Hours | Credit | ECTS |
|---|---|---|---|---|---|---|---|
| Database Design and Management | CMPE341 | Area Elective | 3 | 2 | 0 | 4 | 7 |
| Pre-requisite Course(s) |
|---|
| N/A |
| Course Language | English |
|---|---|
| Course Type | Elective Courses |
| Course Level | Natural & Applied Sciences Master's Degree |
| Mode of Delivery | Face To Face |
| Learning and Teaching Strategies | Lecture. |
| Course Lecturer(s) |
|
| Course Objectives | This course involves students in real-life problems and theory on database systems and encourages teamwork in the design and implementation of database systems. |
| Course Learning Outcomes |
The students who succeeded in this course;
|
| Course Content | Database system concepts, data modeling with ER and EER, the relational data model, file organizations and index structures, relational algebra, structured query language (SQL); database design: functional dependence and table normalization; introduction to database administration; a relational DBMS in a laboratory environment. |
Weekly Subjects and Releated Preparation Studies
| Week | Subjects | Preparation |
|---|---|---|
| 1 | DB system concepts | Chapter 1-2 (main text) |
| 2 | ER model | Chapter 3 |
| 3 | EER model | Chapter 4 |
| 4 | Relational model & Relational DB concepts | Chapter 5 |
| 5 | Relational algebra | Chapter 8 |
| 6 | ER- and EER-to-Relational Mapping | Chapter 9 |
| 7 | DB Design | Chapter 14 |
| 8 | DB Design | Chapter 14 |
| 9 | DB Design | Chapter 14 |
| 10 | File organization | Chapter 16 |
| 11 | Index structures | Chapter 17 |
| 12 | Index structures | Chapter 17 |
| 13 | Database Authorization, Security and Privacy | Chapter 30 |
| 14 | Database Authorization, Security and Privacy | Chapter 30 |
Sources
| Course Book | 1. “Fundamentals of Database Systems”, 7th Edition, Ramez Elmasri & Shamkant B. Navathe, Pearson Education, 2017. |
|---|---|
| 2. “Oracle 9i: SQL with an introduction to PL/SQL”, L. L. Morris-Murphy, Thomson Course Technology, 2003 | |
| Other Sources | 3. “Principles of Database Systems with Internet and Java Applications”, Greg Ricardi, Addison-Wesley, 2001. |
| 4. “Database Application Development & Design”, 3rd Ed., McGraw-Hill, M.V. Mannino, McGraw-Hill, 2005. | |
| 5. http://sqlCourse.com/ (Interactive Online SQL Training) | |
| 6. “Database Systems: A practical Approach to Design, Implementation, and Management”, T. Collony & Carolyn Begg, 4th Edition, Addison-Wesley, 2005. |
Evaluation System
| Requirements | Number | Percentage of Grade |
|---|---|---|
| Attendance/Participation | - | - |
| Laboratory | 1 | 20 |
| Application | - | - |
| Field Work | - | - |
| Special Course Internship | - | - |
| Quizzes/Studio Critics | - | - |
| Homework Assignments | - | - |
| Presentation | - | - |
| Project | 1 | 15 |
| Report | - | - |
| Seminar | - | - |
| Midterms Exams/Midterms Jury | 1 | 30 |
| Final Exam/Final Jury | 1 | 35 |
| Toplam | 4 | 100 |
| Percentage of Semester Work | 65 |
|---|---|
| Percentage of Final Work | 35 |
| Total | 100 |
Course Category
| Core Courses | X |
|---|---|
| Major Area Courses | |
| Supportive Courses | |
| 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 | To be able to use mathematics, science and engineering knowledge in solving engineering problems related to information systems. | X | ||||
| 2 | Design and conduct experiments in the field of informatics, analyze and interpret the results of experiments. | |||||
| 3 | Designs an information system, component and process according to the specified requirements. | X | ||||
| 4 | Can work effectively in disciplinary and multidisciplinary teams. | |||||
| 5 | Identify, formulate and solve engineering problems in the field of informatics. | X | ||||
| 6 | Acts in accordance with professional ethical rules. | |||||
| 7 | Communicates effectively both orally and in writing. | |||||
| 8 | Gains awareness of the necessity of lifelong learning. | |||||
| 9 | Learn about contemporary issues. | |||||
| 10 | To be able to use modern engineering tools, techniques and skills required for engineering practice. | X | ||||
| 11 | Knows project management methods and recognizes international standards. | |||||
| 12 | Develop informatics-related engineering products and prototypes for real-life problems. | |||||
| 13 | Contributes to professional knowledge. | |||||
| 14 | Can do methodological scientific research. | |||||
| 15 | Produce, report and present a scientific work based on an original or existing body of knowledge. | |||||
| 16 | Can defend the original idea generated. | |||||
ECTS/Workload Table
| Activities | Number | Duration (Hours) | Total Workload |
|---|---|---|---|
| Course Hours (Including Exam Week: 16 x Total Hours) | 16 | 5 | 80 |
| Laboratory | 1 | 10 | 10 |
| Application | |||
| Special Course Internship | |||
| Field Work | |||
| Study Hours Out of Class | 16 | 2 | 32 |
| Presentation/Seminar Prepration | |||
| Project | 1 | 20 | 20 |
| Report | |||
| Homework Assignments | |||
| Quizzes/Studio Critics | |||
| Prepration of Midterm Exams/Midterm Jury | 1 | 15 | 15 |
| Prepration of Final Exams/Final Jury | 1 | 20 | 20 |
| Total Workload | 177 | ||