Databases
This language is primarily used to interact with relational databases.
SQL (Structured Query Language)
In an ER diagram, what shape is used to represent an entity?
rectangle
This individual proposed the Relational Model of Data in 1970, revolutionizing database management.
Dr. E.F. Codd
In ER-to-Relational mapping, what is chosen as the primary key of a relation corresponding to a regular entity type?
One of the key attributes
This relational algebra operation is used to retrieve specific attributes (columns) from a relation while eliminating duplicates.
PROJECT
This three-level architecture consists of internal, conceptual, and external schemas to provide data abstraction.
Three-Schema Architecture
What is the term for a relationship where one entity is dependent on another for its identification?
weak entity
In the formal relational model, a row in a table is referred to as this.
tuple
In a binary 1:N relationship mapping, where is the foreign key placed?
N-side of the relationship
In relational algebra, the UNION operation requires both relations to meet this compatibility condition.
type compatibility
The description of a database, including its structure, data types, and constraints, is known as this.
Database Schema
What extended ER model concept is used to represent hierarchical relationships among entities, such as Employee and Manager?
superclass/subclass relationship
This type of key is a minimal superkey, meaning that removing any attribute from it would make it no longer a superkey.
candidate key
What is the recommended method for handling multivalued attributes in relational schema mapping?
a new relation
This set-theoretic operation returns tuples that exist in both relations while eliminating duplicates.
INTERSECTION
This language is used to specify database retrievals and updates, with commands that can be embedded in general-purpose programming languages.
Data Manipulation Language (DML)
What is the cardinality of a relationship where one department has multiple employees, but each employee belongs to only one department?
one-to-many (1:N)
This constraint ensures that a foreign key in one table must either match a primary key in another table or be null.
referential integrity
In a binary M:N relationship mapping, what is created to represent the relationship?
a new relation
In relational algebra, this operation is a combination of Cartesian Product followed by a SELECT operation to create meaningful relationships between two tables.
JOIN
This early database model, heavily used by IBM’s IMS system, organizes data in a tree-like structure
Hierarchical Data Model
What type of EER constraint specifies that an entity can belong to only one subclass?
disjointness
The relational model is formally based on this branch of mathematics, which deals with sets and relations.
set theory
In mapping generalization, what does Option 8C use to distinguish subclasses?
a type (discriminating) attribute
The sequence of relational algebra operations can be visually represented using this data structure to analyze execution complexity.
a query tree