C S 31A - INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

    Recent Professors
    LADAWN MEADE, HANAN IBRAHIM
    Recent Semesters
    Spring 2027, Winter 2027, Fall 2026, Summer 2026, Spring 2026
    Class Size
    40 students
    Credits
    4.5
    Spring 2027 Sections
    View Spring 2027 sections of C S 31A
    Transfers To
    CSU
    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.