CS M10DB - Database Management Systems and Applications

    Recent Professors
    Esmaail Nikjeh
    Recent Semesters
    Spring 2027, Fall 2026, Spring 2026, Fall 2025, Spring 2025
    Class Size
    40 students
    Difficulty
    5.8Demandingout of 10
    Credits
    3
    Spring 2027 Sections
    View Spring 2027 sections of CS M10DB
    Transfers To
    CSU
    Description
    Introduces modern database concepts while emphasizing the relational database model. Includes such topics as design methodologies, normalization of tables to reduce redundancies, supertypes and subtypes to reduce nulls, data integrity, referential integrity, and using locks and other techniques for concurrency control in a multi-user database. Describes the factors that should be balanced during the design of a database. Documents databases, entity relationship diagrams, relational schemas, and data dictionaries are described. Applies the principles by performing exercises using MS SQL Server, MySQL, or other database management system. Uses SQL and other languages to create and fill tables, retrieve data, and manipulate it by stored programs.