CENG351 DATA MANAGEMENT AND FILE STRUCTURES
| Course Code: | 5710351 |
| METU Credit (Theoretical-Laboratory hours/week): | 3 (3.00 - 0.00) |
| ECTS Credit: | 6.0 |
| Department: | Computer Engineering |
| Language of Instruction: | English |
| Level of Study: | Undergraduate |
| Course Coordinator: | Prof.Dr. PINAR KARAGÖZ |
| Offered Semester: | Fall Semesters. |
Course Objectives
The objectives of the course are to enable the students to understand the fundamentals of file organization and processing techniques and also the internals of the storage and retrieval components of relational database systems.
Course Content
Introduction to DBMSs. Relational databases. Entity-Relationship data model. Relational algebra. Relational calculus. SQL. Sequential files. Unordered sequential files. Ordered sequential files. External sorting. B+tree index. Hashing. Dynamic hashing. Basics of query evaluation.
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 and Relational Calculus queries and develop Relational Algebra and Relational Calculus queries
Understand SQL queries and develop SQL queries
Understand the basics of file organization of databases.
Understand and apply indexing mechanisms in databases.
Understand the basics of query evaluation mechanisms.
Implement an application using a database management system
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 | ✔ | |||