Skip to main content

Topic outline

  • Introduction to Databases

    Student will recognize meaning of database, DBMS, component of DBMS environment, Advantages and disadvantages of DBMS, and three-level database architecture

  • The Relational Model

    Student will understand terminology of relational model, properties of database relations, how to identify Candidate Key, Primary Key, and Foreign Key, meaning of entity integrity and referential integrity, how to use Entity–Relationship (ER) modeling in database design

    • Normalization

      Student will understand the purpose of normalization, data redundancy, how to identify functional dependencies, the process of normalization

      • SQL – Data Definition

        Student will understand data types supported by SQL standard, how to create a table and define integrity constraints using SQL, how to use the integrity enhancement feature in the CREATE and ALTER TABLE statements

        • SQL – Data Manipulation

          Student will understand how to update database using INSERT, UPDATE, and DELETE, how to retrieve data from one table using SELECT, how to retrieve data from multiple tables using SELECT