Scheming Schema
A "column" in a database, this includes a data type and values based on a single attribute.
What is a field?
A concept that involves limiting data to a certain modifier, such as a data type, amount, or value.
What is a constraint?
This symbol is used as a stand-in for "all."
What is an asterisk (*)?
This refers to how the data in a field is formatted, such as a sentence full of characters (string) or as a whole number (integer).
What is a data type?
Karen is trying to make a database to help her send thank you cards to her friends for a wedding. What database object would show the easily formatted results of the query?
This is what is created when you ask a database for data based on a set of parameters.
What is a query?
This relationship is represented by multiple tables linked together with a foreign key.
What is a one-to-many relationship?
A SQL manipulation command that is used by queries, this allows a user to view a specific set of data from the database.
What is SELECT?
This system is how relational databases are created and maintained.
What is a Database Management System (DBMS)?
Jim wants to remove his old co-worker Dwight from the editor list of his database. Which SQL command would he use to change the permissions?
REVOKE.
A unique identifier for every record in a database - it is crucial to the concept of exclusivity in a relational database.
What is a primary key?
This type of table is necessary to create a "many-to-many-relationship," made by separating data into two or more one-to-many relationships.
What is a junction table?
A SQL manipulation command that can be used to change primary or foreign keys inside of a table.
What is ALTER?
This type of database language involves changing the values within an existing database object, such as the contents of a record.
A restaurant has a database to store employees, orders, and customers. The order table has five fields: a unique order ID number, the food ordered, the time served, the employee who cooked it, and the employee's ID number. What is the employee's ID number called in this table?
A foreign key.
A two-dimensional file with data, such as in a comma separated value file (.CSV), is often called this.
What is a flat file?
Data that includes many different types, such as a database with articles, interviews, pictures, and audio files, is called what?
Non-structured data.
This SQL definition command deletes a database object (such as a table) and all the data inside of it.
What is DROP?
This term refers to the massive amount of data collected and stored online from everyone's frequent internet use. It can also refer to the analysts and companies that utilize the data.
Charlie buys the new Call of Duty every year, but his settings never save. He wants to record all his settings in a simple way that could be opened by any editor and he can bring up each time he buys the new game. What kind of file should Charlie use?
A text flat file.
Which of the following is NOT a defining characteristic of a database?
Centralized access, scalability, read-only data, and security.
Read-only data.
The missing characteristic is the ability to backup and recover.
Data that has been organized in an optimal way, it can be updated or edited without causing major errors.
What is normalization?
A SQL control command that allows a user to create a copy of a database.
BACKUP DATABASE.
This type of database language changes a database's structure, such as creating a table.
What is DDL (Data Definition Language)?
A non-relational database.