CENG352 DATABASE MANAGEMENT SYSTEMS
| Course Code: | 5710352 |
| METU Credit (Theoretical-Laboratory hours/week): | 3 (3.00 - 0.00) |
| ECTS Credit: | 5.0 |
| Department: | Computer Engineering |
| Language of Instruction: | English |
| Level of Study: | Undergraduate |
| Course Coordinator: | Prof.Dr. FEHİME NİHAN ÇİÇEKLİ |
| Offered Semester: | Fall or Spring Semesters. |
Course Objectives
Students will learn
- Relational data model and semi-structured data models
- Advanced SQL mechanisms for relational databases
- Relational Database Design Theory
- SQL query processing algorithms and query optimization techniques
- Transaction management and concurrency control
- Crash recovery protocols
- Database application development concepts
Course Content
Review of relational model of data,relational algebra, and SQL. Semi-structured data models. Relational database design theory. Query evaluation and optimization. Performance tuning. Transaction management, concurrency and crash recovery. Client-server architectures. NoSQL databases.
Course Learning Outcomes
- Use advanced SQL DDL mechanisms for relational databases.
- Identify anomalies in relational database schemas and solve via normalization
- Use transaction processing mechanisms in relational databases
- Identify efficent query processing plans in relational databases
- Design and implement complete stand-alone or web based database applications for a real-life data management problem
Program Outcomes Matrix
| Contribution | |||||
| # | Program Outcomes | No | Yes | ||
| 1 | An ability to identify, formulate, and solve complex engineering problems by applying principles of engineering, science, and mathematics | ✔ | |||
| 2 | An ability to apply engineering design to produce solutions that meet specified needs with consideration of public health, safety, and welfare, as well as global, cultural, social, environmental, and economic factors | ✔ | |||
| 3 | An ability to communicate effectively with a range of audiences | ✔ | |||
| 4 | An ability to recognize ethical and professional responsibilities in engineering situations and make informed judgments, which must consider the impact of engineering solutions in global, economic, environmental, and societal contexts | ✔ | |||
| 5 | An ability to function effectively on a team whose members together provide leadership, create a collaborative and inclusive environment, establish goals, plan tasks, and meet objectives | ✔ | |||
| 6 | An ability to develop and conduct appropriate experimentation, analyze and interpret data, and use engineering judgment to draw conclusions | ✔ | |||
| 7 | An ability to acquire and apply new knowledge as needed, using appropriate learning strategies | ✔ | |||