Data Modeling & Schema
What is the term for a blueprint that defines how data is structured in a database?
What is a schema?
This is a structured collection of data stored electronically in a computer system.
What is a database?
This term refers to a basic unit of data in a database, often represented as a column in a table.
What is an attribute?
This command retrieves data from the database
What is select?
What is a structured collection of data that is stored and managed electronically?
What is a database?
In a relational database, what type of key uniquely identifies each record in a table?
What is a primary key?
This language is used to manage and manipulate databases.
What is SQL?
This term refers to a collection of related attributes that describe a single entity in a database, typically represented as a row in a table.
What is a record?
This clause is used in a select statement to filter the output based on conditions
What is where?
What type of database organizes data into tables with rows and columns?
What is a relational database?
What is the process of organizing a database to reduce redundancy and improve integrity?
What is normalization?
This type of database stores data in rows and columns.
What is a relational database?
In relational databases, this term represents a set of related data, typically structured as rows and columns, and is used to store instances of entities.
What is a table?
This clause is used in a select system to SORT the queries items
What is Order by?
What language is commonly used to query and manage relational databases?
What is SQL?
In a ER diagram, what symbol typically represents an entity?
What is a rectangle?
This term refers to a unique identifier for a record in a relational database table.
What is a primary key?
This entity relationship model term is used to describe a relationship where an entity is associated with more than one other entity, often represented with a foreign key.
What is a one-to-many relationship?
What type of join only retrieves data that has matching values in both tables
What is inner join?
What type of database is designed to store and retrieve data as key-value pairs, documents, or graphs instead of tables?
What is a NoSQL database?
In a relational database, what type of key is used to establish a relationship between two tables?
What is a foreign Key?
This process ensures that changes to a database are performed in a safe, reliable, and consistent manner.
What is a transaction?
This data type in relational databases is used to store text-based data, often with varying lengths and sometimes defined with character limits.
What is a string or varchar data type?
This sql command adds a new row into a table
What is Insert Into?
What database management system (DBMS) is open-source and widely used for web applications, originally developed by Oracle Corporation?
What is MySQL?