Database & SQL Concepts final

These flashcards cover key concepts, definitions, and understandings related to databases and SQL as discussed in the lecture.

What does SQL stand for?

Structured Query Language.

Which is NOT one of the responsibilities of a DBMS?

Display query results.

The first step in the design and development of a database is to:

Define the purpose of the database.

In which architecture does the application reside on local computers?

Client/Server architecture.

Which type of architecture requires the most network bandwidth?

Client/Server architecture.

Another term for the DBMS in an information system is:

The engine.

What kind of system uses multiple databases with both internal and external data?

None of the listed answers.

Which of the following is best described as a TPS system?

Point of Sale System.

What kind of system captures information about detailed business operations?

TPS system.

Dumb terminals belong to which type of database architecture?

Mainframe Architecture.

A type of database used for strategic analysis is called:

Online Analytical Processing database.

What are two important pieces of information stored in a database about an entity?

Identifiers and Attributes.

A type of database used for daily business processing is called:

Online Transaction Processing database.

Which is NOT one of the beneficial uses of data mining?

Correcting account balances.

What does the database schema define?

The keys and indices required.

The SQL statement used to change data in an existing row is:

Update.

Which SQL statement is used to remove rows from a table?

Delete.

The process of linking records in different tables is called:

Joining.

Which clause identifies the tables the query should access?

FROM.

To eliminate duplicate values in SQL, you use which keyword?

Distinct.

The order of precedence for AND, OR, and NOT is:

NOT, AND, OR.

Conditions connected by OR will be true when:

Either condition is true.

The SQL statement used to insert new rows into a table is:

Insert.

The clause that specifies how rows in the query result should be sorted is:

ORDER BY.

To sort in reverse alphabetical order, you use the keyword:

DESC.

Conditions connected by AND will be true when:

Only when both conditions are true.

String literal values are always represented:

Surrounded by single quotation marks.

The clause that gives the condition for selecting rows is:

WHERE.

In an SQL SELECT statement, * means:

List all columns.

A single member of a set is called:

An instance.

UML stands for:

Unified Modeling Language.

The set of all instances with the same characteristics is called:

An entity.

A property of the instances in an entity set is called:

An attribute.

Connections or links between instances in one entity set with those in another describes:

Relationships.

Tangible things (e.g., car, person) are examples of:

Entities.

Which type of relationship links instances of an Entity Set to instances of the same set?

Unary.

The number of instances in one Entity that are related to a single instance in another describes:

Cardinality.

What is the relationship between STUDENT and PERMIT in the described scenario?

Mandatory one-to-one relationship.

What is the relationship between CLASSROOM and CLASS in the described scenario?

One-to-many (optional many, mandatory one).

In the relational model, a unique row identifier is called:

Candidate key.

In the relational model, a column that connects one table to another is called:

Foreign key.

An internally generated value unique to a row in a table is called:

Object identifier.

If a relation's key has more than one column, it is:

Composite.

If a relation is in Third Normal Form, it is also in:

Second Normal Form.

In the relational model, a row in a table is called:

Tuple.

The rule that no key column value may be null is called:

Entity integrity.

A unique row identifier with meaning outside the computer system is called:

External key.

A rule that says one column's value determines another column's value is called:

Functional dependency.

If a data value is null, it:

May be unknown.

In standard relational notation, underlined column names identify:

The relation's key.

In standard relational notation, a comma-separated list of names identifies:

The attributes.

The rule that a foreign key must be null or have an actual key value is called:

Referential integrity.

The rule that every attribute value must be atomic is called:

First Normal Form.

If a portion of a relation's key is a determinant, then the relation violates:

Second Normal Form.