School of Engineering \ Computer Engineering
Course Credit
ECTS Credit
Course Type
Instructional Language
Programs that can take the course
Computer Engineering
Artificial Intelligence Engineering
Database concepts, data modeling with ER and EER, relational DBMS, file organization and Index structures. SQL, DB Design: Functional Dependency, Normalization. DBMS management. database programming, transaction processing, concurrency control.
Textbook and / or References
Fundamentals of Database Systems, 7th Edition Addition Wesley, Ramez Elmasri and Shamkant Navathe, ISBN-10: 0133970779 ISBN-13: 978-0133970777 - 7
To equip students with a comprehensive understanding of database systems' fundamental concepts, data modeling techniques, relational database management systems, and methods to ensure data integrity, enabling them to design and implement effective and reliable data management systems.
1. Understand fundamental database concepts and principles, including data modeling with ER and EER diagrams.
2. Gain proficiency in relational database management systems (RDBMS), including file organization and index structures.
3. Develop the ability to design databases using functional dependency, normalization techniques, and best practices.
4. Learn to write and execute SQL queries to retrieve, manipulate, and manage data effectively.
5. Acquire skills in database management, including programming, transaction processing, and concurrency control.
6. Develop and demonstrate a database application.
1. Week: Database System Concepts
2. Week: Mini World, ER/EER and Relational Mapping
3. Week: Relational Algebra
4. Week: Tuple Relational Calculus and Domain Relational Calculus
5. Week: SQL
6. Week: Functional Dependency, Normal Forms (1NF, 2NF, 3NF, 4NF, 5NF, BCNF)
7. Week: Minimal Functional Dependency and FD Closure
8. Week: Candidate Key Finding and Equivalence of FDs
9. Week: Basic File Structure and Indexing (Single Level, Multi-Level, B++)
10. Week: Transaction Processing Concepts (Serializability and Recoverability)
11. Week: 2PL and Timestamp-Based Ordering for Concurrency Control
12. Week: No-Undo/Redo on Deferred Update, Recovery on Immediate Update
Tentative Assesment Methods
Midterm %30
Final %40
Lab %10
Project %20
|
Program Outcome
*
|
| 1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
|
Course Outcome
|
|---|
| 1 |
C, D
|
A
|
|
A, B
|
|
|
|
|
|
|
|
| 2 |
C, D
|
A
|
|
A, B
|
|
|
|
|
|
|
|
| 3 |
C, D
|
|
|
A, B
|
|
|
|
|
|
|
|
| 4 |
C, D
|
|
|
|
|
|
|
|
|
|
|
| 5 |
C, D
|
A, B
|
|
|
|
|
|
|
|
|
|
| 6 |
C, D
|
A
|
|
A, B
|
|
A, C
|
A, B, E
|
|
|
|
|