Database Midterm

A person's name, birthdate, and ssn are all examples of...

Attributes

Customers, cars, and parts are examples of:

entities

The number of entity types that participate in a unary relationship is

1

The total quiz points for a student for an entire semester is a(n) ________ attribute

derived

The entity type name should be all of the following except

abbreviated

an entity that associates the instance of one or more entity type and contains attributes specific to the relationship is called a

associative entity

the number of entity types that participate in the relationship is called the

degree

a simultaneous relationship among the instance of 3 entity types is called what kind of relationship

tertiary

a student can attend 5 classes each with a different professor, each professor has 30 students, the relationship between students and professor is a what relationship

many to many

a single occurrence of an entity is called an entity instance

true

which of the following is a generic entity type that has a relationship with one or more suptypes

supertype

an attribute or attribute that uniquely identifies each row in a relation is a

primary key

a primary key that consists of more than one attribute is called a

composite key/ concatenated key

a two-dimensional table of data sometimes is called a

relation

_____ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated

constraints

which of the following are properties of relations

1. each relation/table has a unique name

2. each attribute/column has a unique name

3. each cell contains a single (atomic) value

4. each row (tuple) is unique

a rule that states each foreign key value must match a primary key value in the other relation is called the

referential integrity constraint

all of the following are goals of normalization except...

maximize storage space

When all multivalued attributes have been removed from a relation, it is said to be in...

First normal form

A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form?

Second normal form

functional dependencies in which one or more nonkey attributes are functionally dependent on part but not all of the primary key is called a ______ dependency.

partial

functional dependency between two or more nonkey attributes is called a

transitive dependency

Requiring a CustomerID to exist in a Primary table before it can exist in a foreign table is an example of:

referential integrity

______ are problems are encountered when removing data with transitive dependency

deletion anomalies

In the SQL language, the ________ statement is used to make table definitions.

create table

________ is a set of commands used to update and query a database.

DML

SQL command for adding one or more new columns to a table

ALTER TABLE table_name

ADD column_name data_type

DDL is typically used during which phases of the development process?

A) Implementation

B) Physical design

C) Analysis

D) All of the above

all of the above

Any create command can be reserved by using ____ command

DROP

INSERT is an example of _____ code

DML

In a SQL statement, which of the following parts states the conditions for row selection?

WHERE

The last part of SQL statement to be read is the ____ statement

ORDER BY

To eliminate duplicate rows in a query, the ________ qualifier is used in the SQL Select command.

DISTINCT