C S 31A

About this course

Introduction to database design and use of database management systems for applications. Topics include database architecture, comparison to file-based systems, historical data models, conceptual model; integrity constraints and triggers; functional dependencies and normal forms; relational model, algebra, database processing and Structured Query Language (SQL), database access from Applications-Embedded SQL, JDBC, Cursors, Dynamic SQL, Stored Procedures. Emerging trends will be studied, such as NoSQL databases, internet and databases, and Online Analytical Processing (OLAP). A team project that builds a database application for a real-world scenario is an important element of the course.

Enrollment availability changes frequently. Confirm status in the official FHDA registration system before enrolling.

Prerequisites

The Foothill catalog lists no prerequisite for this course.

Advisory: “Advisory: One of the following: C S 1A, 2A, 3A, or equivalent.”

Transfer pathways that use C S 31A

ASSIST maps C S 31A to a requirement in 4 published pathways from Foothill College.

• Bachelor of Science in BioengineeringFoothill → University of the Pacific
• Bachelor of Science in Data ScienceFoothill → University of the Pacific
• Bachelor of Science Major in Data ScienceFoothill → University of the Pacific
• Information Science and Data Analytics, B.S. (SJSU Online)Foothill → San Jose State