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
Reference Text:
Database System Concepts, 6th Edition, A. Silberschatz; H. Korth; S. Sudarshan McGraw- Hill, ISBN-13: 978-0073523323 ISBN-10: 0073523321.
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.
Week 1: Database System Concepts
Week 2: Mini World, ER/EER and Relational Mapping
Week 3: Relational Algebra
Week 4: Tuple Relational Calculus and Domain Relational Calculus
Week 5: SQL
Week 6: Functional Dependency, Normal Forms (1NF, 2NF, 3NF, 4NF, 5NF, BCNF)
Week 7: Minimal Functional Dependency and FD Closure
Week 8: Candidate Key Finding and Equivalence of FDs
Week 9: Basic File Structure and Indexing (Single Level, Multi-Level, B++)
Week 10: Transaction Processing Concepts (Serializability and Recoverability)
Week 11: 2PL and Timestamp-Based Ordering for Concurrency Control
Week 12: 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
|
|
|
|
|