Relation Station
this table is very structured with specific fields/columns; consequently, fields are never randomly placed
Relational Table
Which software package is a Relational Database Management System (RDBMS)?
Microsoft SQL Server
What is the purpose of the SQL DROP command?
To delete a table or entire database
What does DDL stand for?
Data Definition Language
You submitted the following SQL command: "Custommer" table: DELETE FROM CUSTOMER
What happens next?
All the records from the "Customer" table were deleted
An attorney uses a standard form to capture information about new clients. Which type of database would best suit those needs?
A Relational Database
What is the purpose of a Schema
Describe the structure of a database
What is the purpose of the SQL DELETE command?
it is used to delete one or more rows of data from an existing table
What is the term used for the file that includes a copy of the database along with the schema?
Database Dump
What does the SQL UPDATE command do?
updates one or more field values
In this database type, objects and their properties are stored, but each object doesnt have to have all the properties
key/value pair database
why is it important to consider the number size of columns included in a table schema?
the size affects the amount of storage and how quickly it can be processed
What is the purpose of the SQL ALTER command?
deletes an individual column
Which type of constraint is added to a table for the purpose of establishing a relationship with another table?
Foreign Key
What is the SQL command used to create queries?
SELECT
In this database, all attributes of a record are defined up front, and each record has all the same attributes as the other records
Relational Database
why would an unstructured database be used to store data instead of a structured database?
some data does not need to be stored with a rigid formatted structure (presentations, text files, word documents, etc)
What is the purpose of the ALTER TABLE command?
to add, remove, and change table columns, primary keys, and foreign keys
You add this to a table for the purpose of making sure each row in the table can be uniquely identified.
Primary Key
Colums in a table are called
Fields
what is the relationship between a primary key and a foreign key in a relational database?
the primary key is in one table and matched to the foreign key in a secondary table
In a pragmatic database, what type of commands are used to interact with a relational database?
SQL
creates new table and establishes a primary key (cannot modify the primary key after it is created)
In the event of an application failure, which application architecture model would be the most disruptive to users?
Standalone
This is how data is entered into a database and often viewed by user
Forms