Exam Review

Fundamentals

100

A person, place, thing or event

Entity

200

A characteristic of an entity

Attribute

300

The type of relationship that an entity has with itself.

Unirary (Recursive) relationship

400

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

Weak relationship

500

Technology that preceded databases

File systems (physicals and digital)

Attributes and Relationships

100

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

Single-Valued

200

The 'price' attribute in the 'product' table can only have positive decimal values. What is this also called?

Attribute Domain

300

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

Primary key

400

The minimum and maximum number of entity occurrences associations

Relationship cardinality

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

Modeling

100

Internal standards/procedures to name database elements

Naming convention

200

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

Conceptual model

300

Type of notation used by MySQL Workbench on their diagrams.

Crow's foot notation

400

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

Internal Model

500

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

Normalization

SQL Queries

100

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

SELECT and FROM

200

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

LIMIT

300

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

USE

400

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

SELECT * FROM Student

WHERE last_name LIKE 'Q%';

500

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

DESCRIBE

Miscellaneous

100

SQL function needed to obtain the difference in days between two dates

DATEDIFF()

200

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

Two dimensions (rows and columns)

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

SQL was needed to retrieve all customers from the table, joined with the purchases they have made. Customers without purchases are also returned.

LEFT JOIN

500

A database object that can be automatically executed after an INSERT, UPDATE, or DELETE has happened.

Trigger