Introduction: Relational data modeling for data architecture

Tutorials > Relational data modeling for data architecture > Introduction: Relational data modeling for data architecture

Build logical and physical models to represent the structure and relationships in your organization.

For this tutorial, you will model the structures and relationships of a hotel chain. For example, you will model the process of a customer booking a reservation. This model will include entities (a reserved room), attributes (the name of a customer), and relation lines (the reserved room belongs to the customer).

Learning objectives

By the end of this tutorial, you will know how to:

•generate a logical data model

•generate a physical data model

•manage models and databases.

Time required

This tutorial should take approximately 30 minutes to finish. If you explore other concepts related to this tutorial, it could take longer to complete.

Skill level

Intermediate

Prerequisites

Before you begin this tutorial, make sure that you have completed the Prerequisites.

Modules in this tutorial

Module 1: Generate a logical data model

Build a logical data model to illustrate the reservation system of the hotel. This data model will be one subject area of the overall system.

Module 2: Create a physical data model

Build a physical diagram from the logical model built in the previous module.

Prerequisites