Database Modeling
This is the process of creating a data model for the data to be stored in a database.
What is database modeling?
This type of relationship exists when a single record in one table is related to multiple records in another table.
What is a one-to-many relationship?
This SQL command is used to retrieve data from a database.
What is SELECT?
This constraint ensures that all values in a column are unique.
What is UNIQUE?
This type of join returns records that have matching values in both tables.
What is INNER JOIN?
This type of diagram is used to visually represent the structure of a database.
What is an Entity-Relationship Diagram (ERD)?
This type of relationship exists when multiple records in one table are related to multiple records in another table.
What is a many-to-many relationship?
This clause is used to specify the table from which to retrieve data.
What is FROM?
This constraint ensures that a column cannot have a NULL value.
What is NOT NULL?
This type of join returns all records from the left table and the matched records from the right table.
What is LEFT JOIN?
This term describes the unique identifier for a record in a table.
What is a primary key?
This type of relationship exists when a single record in one table is related to a single record in another table.
What is a one-to-one relationship?
This clause is used to filter records that meet a certain condition.
What is WHERE?
This constraint is used to enforce a link between two tables.
What is FOREIGN KEY?
This type of join returns all records from the right table and the matched records from the left table.
What is RIGHT JOIN?
This type of database model organizes data into tables.
What is a relational database model?
This type of key is used to establish and enforce a link between the data in two tables.
What is a foreign key?
This clause is used to sort the result set in ascending or descending order.
What is ORDER BY?
This constraint ensures that the value in a column or a group of columns is unique across the entire table.
What is PRIMARY KEY?
This type of join returns all records when there is a match in either left or right table.
What is FULL OUTER JOIN?
This notation, named for its distinctive symbols, is used to represent the relationships between entities in a database.
What is Crow's Foot Notation?
This term describes the table that connects two tables in a many-to-many relationship.
What is a junction table?
This keyword is used in SQL to combine multiple conditions in a WHERE clause, ensuring that all conditions must be true.
What is AND?
This constraint is used to specify a default value for a column.
What is DEFAULT?
This is the basic syntax for performing an INNER JOIN in SQL.
What is SELECT columns FROM table1 INNER JOIN table2 ON table1.column = table2.column?