CENG302 INTR. TO DATABASE MANAGEMENT SYSTEMS
| Course Code: | 5710302 |
| 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: | Lecturer AYŞE YASEMİN SEYDİM |
| Offered Semester: | Fall and Spring Semesters. |
Course Objectives
The objectives of the course are as follows:
To introduce basics of database management systems
To show how to apply this basic knowledge on current relational database management systems.
Course Content
Introduction to DBMSs, Relational Databases, Relational Algebra, SQL, Entity Relationship Model. Theory of Database Design, Physical Database Design, Example DBMS. (Offered to non-5710 students only).
Course Learning Outcomes
At the end of this course, students will be able to:
- Understand the basics of database management systems
- Understand ER modeling components and apply them for database conceptual design.
- Understand Relational Algebra queries and develop relation algebra queries
- Understand Relational Calculus queries.
- Understand SQL queries and develop SQL queries
- Understand the basics of file organization of databases.
- Understand the indexing mechanism in databases.
- Understand the basic levels of normalization and apply them for database design improvement.
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 | ✔ | |||