Table Joins and Sorting Data
-Landon
-Landon
To reverse the order of sorted columns you use the ____ keyword.
Descending, DESC
What are the 3 different types of SQL?
DDL, DML, and TCL
What does it mean for an attribute to be mandatory or optional?
Mandatory can’t be null, Optional can
When a relation must have no composite, or multi-valued attributes.
First Normal Form
A ____ is equivalent to column in a table. It is an element that qualifies or describes and Entity?
Attribute
By default, nulls are sorted ____ in ascending order.
Last
The keyword to delete a table or column.
Drop
An attribute whose value uniquely identifies an entity instance
Unique Identifier, UID
When every non-prime attribute is fully functionally dependent on the candidate key.
Second Normal Form
What is the fundamental building block of a relational database, where data is organized into rows and columns?
Table
You can give a table a temporary name by using an _____.
Alias
Keyword to show query results by ascending order.
ASC
What is a Candidate UID?
Any attributes or combination of attributes that can identify a row of data.
When a relation has no transitive dependency.
Third Normal Form
What type of relationship exists when one record in a table can be associated with multiple records in another table?
One to many relationship
A join where the condition has an equality operator. Combines rows that have equivalent values.
Equijoin
Shows nulls in data entries before anything else.
NULLS FIRST
The formula of an ERDish statement
Entity 1 [Cardinality] Relationship to Entity 2 [Cardinality]
Records showing changes in a database, could be known as the history.
Audit Trail
What is the term for a set of rules that ensure data consistency and accuracy within a database?
Data Integrity
A join where the condition is not an equality operator. Combines rows that have non equal values.
Shows every entry in the right table even if there is nothing in the left table.
Right Join
Foreign Keys must match an existing primary key value or else can be null.
Referential Integrity
What is the process of organizing data to minimize redundancy and dependency, ensuring efficiency, consistency, and integrity?
Normalization
What is the language used to interact with a relational database, allowing users to retrieve, insert, update, and delete data?
SQL, Structured Query Language