Fundamentals
A person, place, thing or event
Entity
Type of attribute that Social Security Number (SSN) belongs to
Single-Valued
Internal standards/procedures to name database elements
Naming convention
The two required keywords for any SQL statement that retrieves data.
SELECT and FROM
What are SELECT (RESTRICT), PROJECT, UNION, INTERSECT, DIFFERENCE, PRODUCT, JOIN, and DIVIDE examples of?
A characteristic of an entity
The process of evaluating table structures to identify and minimize data redundancies.
Normalization
The model that represents in a logical way a database or schema; which many times uses diagrams.
Conceptual model
The keyword used to limit the number of results of a SQL query
LIMIT
The number of dimensions of the data that a relational database records.
Two dimensions (rows and columns)
A relationship that an entity holds with another entity of the same table or entity set.
Recursive relationship
The key that uniquely identifies a row (tuple) in a table
Primary key
Type of notation used by MySQL Workbench on their diagrams.
Crow's foot notation
SQL keyword to specify the database that is going to be queried.
USE
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
Relationship strength when the foreign key does not act as a primary key component of the related entity
Weak relationship
The minimum and maximum number of entity occurrences associations
Relationship cardinality
The model that contains the SQL statements to implement a database or schema
Internal Model
SQL statement to SELECT all students whose last name starts with 'Q'
SELECT * FROM Student
WHERE last_name LIKE 'Q%';
RDBMS creates automatically them for primary keys.
Indexes
File systems (physicals and digital)
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
Normalization
DESCRIBE
The range of values an attribute can take
Attribute domain