• Unit 2: Database Architecture and Date Languages

    In order to properly create and then manage a database, we need to have a thorough understanding of the data it holds. Because data can be seen from different levels, we will introduce different data models and learn how to apply them in order to describe the structure of the database, thereby providing a "view" of the database for the different types of users introduced in the previous section. This unit explains database architecture and design using the ANSI/SPARC three-schema architecture.

    Completing this unit should take you approximately 4 hours.

    • 2.1: Databases and the Three-Schema Architecture

    • 2.2: Tables, Views, and Indexes

    • Unit 2 Assessment