Module2: Relational Data Model Flashcards
What is the Relational Data Model?
A framework for specifying data and relationships using a simple and uniform structure known as relations (tables).
What are relations in the Relational Data Model?
Sets of tuples (rows) having attributes (columns) based on a schema defining the relation’s structure.
What are attributes in a relation?
Columns in a table that represent the data elements of entities.
What is a tuple in the context of relational databases?
A single entry in a table, representing a specific instance of an entity.
What is a primary key?
A unique identifier for each tuple in a relation, ensuring no two rows are identical.
What is a foreign key?
An attribute in a table that links to a primary key in another table, establishing a relationship between the two tables.
What are integrity constraints?
Rules that ensure the accuracy and consistency of data within a relational database, including domain, entity integrity, and referential integrity constraints.
What is normalization?
The process of organizing data in a database to reduce redundancy and improve data integrity.
How is an ER model mapped to a relational schema?
By converting entities to tables, relationships to foreign keys, and attributes to columns within those tables.
What are basic database operations in the relational model?
Operations include selection, projection, join, and division, allowing manipulation and retrieval of data from a relational database
What is a tuple in the context of relational databases?
A) A type of data model
B) A row in a table
C) A database management system
D) A query language
B) A row in a table
Which of the following integrity constraints ensures that a foreign key value in one table matches a primary key value in another table?
A) Domain Integrity
B) Referential Integrity
C) Entity Integrity
D) User-Defined Integrity
B) Referential Integrity
The process of organizing data in a database to reduce redundancy and improve data integrity is known as:
A) Indexing
B) Mapping
C) Normalization
D) Partitioning
C) Normalization