From the course: Azure Solutions Architect Expert (AZ-305) Cert Prep: Design Data Storage Solutions

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Features of relational data

Features of relational data - Azure Tutorial

From the course: Azure Solutions Architect Expert (AZ-305) Cert Prep: Design Data Storage Solutions

Start my 1-month free trial Buy for my team

Features of relational data

“

- [Instructor] Relational data has a static structure. It is governed by rules which predefine how the data must be stored and transacted against. All data is tabular. The tables represent modeled entities where an entity is defined as something for which information needs to be held. Each column is a property of the entity. Each row is an instance of the entity. In this example, a product. Every row has the same columns and the data is written across the row and the entity can have any number of rows or instances of the entity. Every table has a primary key. The primary key is unique for each row and is used to identify the row. For the product table, the Prod ID is the primary key. If you try and add or insert another row with the same Prod ID, the primary key will not allow this and the insert will fail. The design of the data model is normalized. This is to reduce redundancy in the data, protect the data and…

Contents