Class Schedule

• Description: 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.
• Prerequisite:
• Corequisite:
• Advisory: Advisory: One of the following: C S 1A, 2A, 3A, or equivalent.
• Repeatability: Not Repeatable.
• Hours: 4 hours lecture per week, 2 hours lab per week. 72 hours total per quarter.
• Foothill GE Area:English
• Transferability: Both
• Transfer GE: Information regarding how this course is applied toward CSU GE/Breadth or IGETC certification is available at:
• Foothill Transfer GE Guide

Department Note: