Sign In

 ICS 324: Database Systems

​​Course Information

Class/Laboratory Schedule: 

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.

Prerequisite Courses: 

Catalog Description: 

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
Edition, 2006

Course Outcomes: 

  • 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.

Topics Covered: 

  • Information models and systems
  • The relational data model
  • Relational languages
  • SQL
  • 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​