Relational Model Concepts
Explore the core concepts of the relational data model including relations as tables, attributes as columns, and tuples as rows. Understand relation schemas, degree, cardinality, domain constraints, and how NULL values represent unknown data. This lesson lays the groundwork for working with relational databases and SQL.
We'll cover the following...
We'll cover the following...
Why use relational data models?
The relational data model was introduced by C.F. Codd in 1970. Currently, it is the most widely used data model.
The relational model has provided the basis for:
- Research on the theory of data/relationship/constraint.
- Numerous database design methodologies.
- The standard database access language called Structured Query Language (SQL).
- Almost all modern commercial database management systems.
The relational data model describes the world as “a collection of inter-related relations (or tables).”
What is relational model?
The ...