Fundamentals
Attributes and Relationships
Modeling
SQL Queries
Miscellaneous
100

A person, place, thing or event

Entity

100

Type of attribute that Social Security Number (SSN) belongs to

Single-Valued

100

Internal standards/procedures to name database elements

Naming convention

100

The two required keywords for any SQL statement that retrieves data.

SELECT and FROM

100

What are SELECT (RESTRICT), PROJECT, UNION, INTERSECT, DIFFERENCE, PRODUCT, JOIN, and DIVIDE examples of?

Database relational algebra operations
200

A characteristic of an entity

Attribute
200

The process of evaluating table structures to identify and minimize data redundancies.

Normalization

200

The model that represents in a logical way a database or schema; which many times uses diagrams.

Conceptual model

200

The keyword used to limit the number of results of a SQL query

LIMIT

200

The number of dimensions of the data that a relational database records.

Two dimensions (rows and columns)

300

A relationship that an entity holds with another entity of the same table or entity set.

Recursive relationship

300

The key that uniquely identifies a row (tuple) in a table

Primary key

300

Type of notation used by MySQL Workbench on their diagrams.

Crow's foot notation

300

SQL keyword to specify the database that is going to be queried.

USE

300

A student can be registered in many classes, and a class can have many students. Is an example of what type of relationship?

M:N Relationship

400

Relationship strength when the foreign key does not act as a primary key component of the related entity

Weak relationship

400

The minimum and maximum number of entity occurrences associations

Relationship cardinality

400

The model that contains the SQL statements to implement a database or schema

Internal Model

400

SQL statement to SELECT all students whose last name starts with 'Q'

SELECT * FROM Student

WHERE last_name LIKE 'Q%';

400

RDBMS creates automatically them for primary keys.

Indexes

500
Technology that preceded databases

File systems (physicals and digital)

500

Type of attribute that results from the calculation of the value of other attributes (e.g., remaining warranty days of a product)

Derived or computed attribute

500
During modeling, this process can be done over a series of stages.

Normalization

500
SQL keyword utilized to obtain the structure of a database without obtaining any table tuple.

DESCRIBE

500

The range of values an attribute can take

Attribute domain

M
e
n
u