Relational Database
The maximum number of times an instance can be associated in a relationship.
What is cardinality?
What was used to access the mainframe computer in the 1970s?
What are dumb terminals?
Used to retrieve and return data from the database
What is SELECT?
The main column used to uniquely identify the table.
What is a primary key?
A string. In parentheses, represents the length of the string.
What is VARCHAR2(n)?
The phase that adds attributes, normalization, relationships, cardinality, etc.
What is logical design phase?
What used internet to give users access to the database servers?
What is web-based database access (1990s)?
Expanding upon the SELECT query, gives a condition that is checked. Only values that satisfy the condition are returned.
What is a WHERE statement?
A column that references the primary key of another table, represents a relationship.
What is a foreign key?
A number.
What is NUMBER?
A type of database that uses shapes to describe entities, attributes, and relationships
What is Chen Model?
If one path is down, data can take another path using the other computers in the server.
What is grid computing?
Something that finds data based on two values. It is inclusive
What is BETWEEN?
A primary key that is made up of multiple columns
What is a composite key?
A character large object with single-byte or multi-byte characters
What is CLOB?
Ensures that all attributes are single-values
What is First Normal Form (1NF)?
A computer in client-server architecture that provides significant functionality independent of what is provided by the centralized.
What is fat-client?
Joins two tables and returns the common values as well as all of the data in the first table
What is a LEFT JOIN?
Multiple unique columns that are in a “race” to be the primary key.
What are candidate keys?
A binary large object
What is BLOB?
Ensures that all non-key attributes rely solely on the primary uid
What is Third Normal Form (3NF)?
A computer in multi-tier client architecture that provides minimal functionality independent of what is provided by the centralized server.
What is thin-client?
What transaction will undo all INSERT statements from the last SAVEPOINT.
What is ROLLBACK?
What is the ideal type of key for the primary key. It does not exist in real life.
What is an artificial key?
DAILY DOUBLE
A data type with datetime fields. Contains YEAR, MONTH, DAY, HOUR, MINUTE, SECOND with fractional seconds. Does NOT have a time zone.
What is TIMESTAMP