Introduction

ICS321 is an introductory data management course covering data modeling, database systems, SQL, database-backed application development, transaction processing, indexing, query processing & optimization.

Instructor name and contact information.

Dr. Richard Halverson
808-371-7424. richardh@hawaii.edu

Course description.

Data storage devices, timing and capacity, programming for files, hashed and indexed files, introduction to relational database systems.

Course objectives.

At the end of this class, the successful student will:

  • have a broad understanding of database concepts and database management system software
  • have a high-level understanding of major DBMS components and their function
  • be able to model an application’s data requirements using conceptual modeling tools like ER diagrams and design database schemas based on the conceptual model.
  • be able to write SQL commands to create tables and indexes, insert/update/delete data, and query data in a relational DBMS.
  • be able to develop a data-intensive application using DBMS APIs.

In addition to the ICS department’s new undergraduate course outcomes, which are students will have:

  • An ability to apply mathematical foundations, algorithmic principles, and computer science theory to the modeling and design of computer-based systems.
  • An ability to define the computing requirements of a problem and to design appropriate solutions based on established design principles and with an understanding of the tradeoffs involved in design choices.
  • An ability to use sound development principles to implement computer-based and software systems of varying complexity, and to evaluate such systems.
  • An ability to use current techniques, skills, and tools necessary for computing practice.

Number of credit hours

3 credit hours

Prerequisites

ICS211 or consent

Textbooks & Required Readings

  1. Relational Theory for Computer Professionals: What Relational Databases Are Really All About (Theory in Practice) 1st Edition by C. J. Date (O’Reilly)
    (ISBN: 978-1449369439) Available at Amazon.com – $33.33 new paperback, $18.35 Kindle, <$20.00 used.
  2. Other online resources

Classroom policies

Student Conduct: All students are expected to conduct themselves above and beyond the standard set forth in UH System-wide Student Conduct Code.

Learning Difference or Disability: Any student who feels s/he may need an accommodation based on the impact of a disability is invited to contact the instructor privately. The instructor would be happy to work with you, and the KOKUA Program (Office for Students with Disabilities) to ensure reasonable accommodations in the course. KOKUA can be reached at (808) 956-7511 or (808) 956-7612 (voice/text) in room 013 of the Queen Liliuokalani Center for Student Services.

174.142.46.13