Key Milestones of the Relational Model in the Mid-1970s
What key milestones were achieved during the creation of the relational model in the mid-1970s?
a.) Introducing the schema
b.) Creating a tuple or a table row within a relation
c.) Using Unified Modeling Language to represent data models
d.) Focusing on having support for large databases at a terabyte size
Answer:
The correct answer is (c.) Using Unified Modeling Language to represent data models.
One of the key milestones achieved during the creation of the relational model in the mid-1970s was the use of Unified Modeling Language to represent data models. This allowed for a more organized and standardized way to represent data and its relationships.
The relational model was first defined in June 1970 by Edgar Codd, a researcher at IBM. The model is based on mathematical set theory and represents data as independent relations. Codd established 12 rules for relational database management systems (RDBMS), outlining the requirements for a database to be considered relational.
The main components of the relational model are structures for organizing data and integrity constraints to maintain data consistency. Data is organized into tables with columns and rows, where each row is known as a tuple. Each column has a name or attribute, and domains define the set of values an attribute can take.