Tutorials : Relational data modeling for data architecture : Introduction: 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.