3 lectures per week, 50 minutes each, and one 3 hours lab per week (3-3-4)
Designation: Required Course
Course Level: Undergraduate
Prerequisite(s) by Topic:
- Fundamental Programming Constructs
- Algorithms and Problem-Solving
- Fundamental Data Structures.
Basic database concepts, conceptual data modeling, relational data model, relational theory and languages, database design, SQL, introduction to query processing and optimization, and introduction to concurrency and recovery.
Fundamentals of Database Systems, R. Elmasri and S. B. Navathe, 5th edition, Addison-Wesley, 2006.
Reference(s) and Other Material:
Database System Concepts, by Abraham Silberschatz, Henry F. Korth, S. Sudarshan McGraw Hill, 5th
- After completion of this course, the student shall be able to:
- Explain the basic database concepts and relational theory.
- Understand and develop relational / conceptual data model.
- Use and apply database programming languages and physical database design.
- Understand the basics of query processing and optimization, concurrency controls and database recovery.
- Gain work experience in a lab project as a team member or leader.
- Information models and systems
- The relational data model
- Relational languages
- Conceptual modeling and mapping
- Functional dependency and normalization
- Practical and Physical database design Concepts
- Database processing issues like query processing and optimization, concurrency controls, security, and database recovery