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 | 5. Semester | 3 | 2 | 0 | 4 | 7 |
| 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 |
| 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 | 1.1 – 1.5, 2.1 – 2.3.1, 2.5.2 (main text) |
| 2 | ER model | 3.1-3.7 |
| 3 | EER model | 4.1-4.3, 4.5 |
| 4 | Relational model & Relational DB concepts | 5.1-5.3 |
| 5 | Relational algebra | 6.1 – 6.5 |
| 6 | ER- and EER-to-Relational Mapping | 7.1 – 7.2.2 |
| 7 | DB Design | 10.1-10.2.2 |
| 8 | DB Design | 10.3 |
| 9 | DB Design | 10.5, 11.1 |
| 10 | File organization | 13.1-13.8.2, 13.9-13.10.2 |
| 11 | Index structures | 14.1-14.2 |
| 12 | Index structures | 14.3 |
| 13 | Database Authorization, Security and Privacy | 23.1 – 23.2 |
| 14 | Database Authorization, Security and Privacy | 23.4 |
Sources
| Course Book | 1. “Fundamentals of Database Systems”, 5th Edition, Ramez Elmasri & Shamkant B. Navathe, Addison-Wesley, 2006. |
|---|---|
| 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 | |
|---|---|
| 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 | Gain sufficient knowledge in mathematics, science and computing; be able to use theoretical and applied knowledge in these areas to solve engineering problems related to information systems. | |||||
| 2 | To be able to identify, define, formulate and solve complex engineering problems; to be able to select and apply appropriate analysis and modeling methods for this purpose. | X | ||||
| 3 | Designs a complex system, process, device or product under realistic constraints and conditions to meet specific requirements; applies modern design methods for this purpose. | X | ||||
| 4 | To be able to develop, select and use modern techniques and tools required for the analysis and solution of complex problems encountered in information systems engineering applications; to be able to use information technologies effectively. | X | ||||
| 5 | Designs and conducts experiments, collects data, analyzes and interprets results to investigate complex engineering problems or research topics specific to the discipline of information systems engineering. | |||||
| 6 | Can work effectively in disciplinary and multidisciplinary teams; can work individually. | |||||
| 7 | a. Communicates effectively both orally and in writing; writes effective reports and understands written reports, prepares design and production reports, makes effective presentations, gives and receives clear and understandable instructions. b. Knows at least one foreign language. | |||||
| 8 | To be aware of the necessity of lifelong learning; to be able to access information, to be able to follow developments in science and technology and to be able to renew himself/herself continuously. | |||||
| 9 | a. Acts in accordance with the principles of ethics, gains awareness of professional and ethical responsibility. b. Gains knowledge about the standards used in information systems engineering applications. | |||||
| 10 | a. Gains knowledge about business life practices such as project management, risk management and change management. b. Gains awareness about entrepreneurship and innovation. c. Gains knowledge about sustainable development. | |||||
| 11 | a. To be able to acquire knowledge about the universal and social effects of information systems engineering applications on health, environment and safety and the problems of the era reflected in the field of engineering. b. Gains awareness of the legal consequences of engineering solutions. | |||||
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 | ||