ICS 324: Database Systems

​

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: 
ICS 202: Data Structures
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​