Database Concepts
This type of database organizes data into tables, with rows representing records and columns representing fields.
What is a relational database
This database model uses a tree-like structure where records are connected in a parent-child hierarchy.
What is a hierarchical model
What is the primary key?
What is a key that uniquely identifies each row in a database.
What is a table?
What is a collection of rows and columns in a relational database, where data is stored in a structured format.
This SQL command is used to retrieve data from one or more tables in a database.
What is SELECT
This is the term for a collection of data that is organized so that it can be easily accessed, managed, and updated.
What is a database
This database model integrates object-oriented programming concepts, where data is stored as objects rather than tables.
What is the object-oriented database model
What is a foreign key?
What is a key used to link two tables by referencing a primary key in another table.
What is an attribute?
What is a characteristic or property of an entity, often represented by a column in a table.
This SQL clause is used to filter records based on a specified condition, often used in conjunction with the SELECT statement.
What is a WHERE condition
In a relational database, this is the term for a single record in a table, often represented as a row.
What is a tuple or row
This model allows multiple relationships between entities and organizes them into a graph structure, with nodes and connections.
What is the network model
What is a composite key?
What is key consists of more than one field in a table, combining them to form a unique identifier for each row.
What is a one-to-many (1:M) relationship?
What is a relationship that is formed when a row in one table is linked to multiple rows at another table.
This SQL clause is used to sort the result set of a query either in ascending or descending order.
What is ORDER BY
This type of software is used to create, manage, and manipulate databases.
What is a database management system (DBMS)
This model stores data as documents, allowing for flexible, semi-structured data storage and retrieval.
What is the document model
DAILY DOUBLE
What is cascading?
DAILY DOUBLE
What is a process involving deleting or updating related rows in a tables when a row in another table is deleted or updated.
What is a nullable attribute?
What is an attribute is not required to have a value and can be left empty in a database.
This SQL function is used to calculate the total sum of a numeric column in a table.
What is SUM()
This concept ensures that the data in a database is accurate, consistent, and reliable over time.
What is data integrity
This model stores data in a graph structure, using nodes, edges, and properties to represent and store relationships between entities.
What is the graph model
How to resolve a many to many relationships?
What is separating two entities and creating two one-to-many (1:n) relationships between them with a third intersect entity.
What is data integrity?
What is a condition where the data in a database is correct, up-to-date, and logically consistent according to the database schema.
This type of join returns only the rows where there is a match in both tables, excluding rows from either table that do not have a corresponding match.
What is an INNER JOIN