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

Prerequisites

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.

Textbook(s): 

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​