InnerPages - 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

ICS

InnerPages: ICS 324: Database Systems

Quick Launch

Title

Body

ICS 324: Database Systems

Attachments