Understanding Databases
“It stores data.”
Database
The rules and structure of the database are called its ________
Schema
______________are how data is entered into and often viewed from your database
Forms
The SQL command to create a database is ________
CREATE
Name 2 types of Database Servers or services
Oracle, Microsoft SQL, or
MySQL), or accessed via the cloud (Amazon Web Services, Microsoft Azure,
Google,
__________ __________is the actual tables, columns, and relationships created inthe RDBMS. Many database management tools have a process for creating a
____________ _________ is based on a logical schema, or the _________ ___________ can be
created manually.
physical schema
______________are the real power of databases. They let you mine your data to find the
specific information that you need
Queries
If you forget to create the column during table creation or are working with an existing table, managing columns is done with the _________ command
ALTER
It’s called this because the data has two dimensions, rows and columns
Flat file
Each row in a table is called a _________
Record.
________________are generated to answer specific questions. For example, a manager could have an automatic ________ that generates the list of new clients in the last week, as opposed to viewing the list in a form. Think of them as preformed
queries.
Reports
The command to delete tables or databases
DROP
________ __________ __________ is the ability for multiple users to access a database at once and one of the many advantages of a database
Multiple Concurrent Users
Columns in a table are called __________
Fields
A database that has no organization to its data usually consist of videos, web pages, emails, documents, texts, and social media
Non-structured Data
The ___________command is used to insert records into an existing table
INSERT
The ability of Databases to stretch to meet the user or organizational requirements
Scalability
________and _________ make up a table
Records
Fields
___________- ____________ ___________is generally thought of as unstructured data that has been tagged with metadata. Metadata is literally
data about data.
Semi-structured Data
___________command is used to update existing data in the database.
UPDATE
Users expect their data to be stored indefinitely, and this is what is meant by______ _________
Data Persistence
For a table in a database to be relational, it must have a _________ __________. In fact, its
creation is mandatory when a table is created. A _______ _________ is one or more fields whose data is used to identify a record uniquely
Primary Key
If you forget to create the column during table creation or are working with an existing table, managing columns is done with the _________ command
ALTER
Queries use the _________ command to identify and display the data the user needs.
SELECT
A database that is predictable and organized, with tables containing columns and rows of text or
numerical data.
Relational Databases
A ________ _________is one or more columns in a
table that refers to the primary key in another table. Foreign keys are not required, and they don’t need to be officially designated in the RDBMS
(although they can be defined by the administrator in the index).
Foreign key
You have an address book for a small business with contact information for about 100 clients. The address book is used by two people. Which solution should you use to store the data?
A. Spreadsheet
B. Relational database
C. Word processing software
D. Non-relational database
A. Spreadsheet
For a small number of rows, with only two people accessing the data, a spreadsheet is fine in this situation
Command that deletes records
DELETE