Database
Relationships
SQL Commands
Normalization
Keys
100
A commonly used name for "relation" in industry
Table
100
What is a One-to-One Relationship?
Each row in one table corresponds to exactly one row in the other table
100
What is the command to create a database?
CREATE DATABASE "name";
100
The process of moving backwards towards 1NF, when concerned more with extreme performance than data protection?
Denormalization
100
This kind of key doesn't take much effort to differentiate data; it's already there!
Natural key
200
Academic term for a single item represented by a row
Tuple
200
What is a One-to-Many relationship?
Each record in the FIRST table corresponds to multiple records in the second table, BUT, each record in the SECOND table corresponds to only one record in the first table.
200
What is the command to list existing databases?
SHOW DATABASES;
200
The key relevant in the process of normalizing from 2NF to 1NF?
Composite key
200
Hmm this key doesn't seem related to the data, but at least it makes the records unique.
Surrogate key
300
The process of making a database more efficient by getting rid of redundant data
Normalization
300
Many-to-Many?
A many-to-many relationship occurs when multiple records in a table are associated with multiple records in another table.
300
What is the command to select a database?
USE "name";
300
Every non-primary key column is dependent on the entire primary key; In 1NF
Conditions to achieve 2NF
300
This kind of key is made up of multiple columns
Composite/compound key
400
Examples include MySQL, PostGreSQL, and Oracle
DBMS
400
How do you set a Self-Referencing relationship?
Set a column in the table as a foreign key to another column in the same table.
400
What is the command to delete an existing database?
DROP DATABASE "name";
400
No non-key field depends on another non-key field
One of the conditions to achieve 3NF
400
A key that relates a record to a record in another table
Foreign key
500
The definition of a column that determines what kind of data can be stored there
Attribute
500
What table do you need to implement when utilizing Many-to-Many?
Bridge Table
500
What is the command to add, delete, or modify columns in a table?
ALTER TABLE "name";
500
No top-to-bottom ordering to the rows; no left-to-right ordering to columns; every row can be uniquely identified; every row/column intersection contains only one value
Conditions to achieve 1NF
500
This is a table made up of keys used when tables have a many-to-many relationship
Bridge table