Database Management Systems Ch1-4

What cardinality is indicated by the Crow's Foot symbol that contains a line beside a crow's foot shape?

(1,N)

In the ERD, cardinality is indicated using the ____ format.

(min, max)

Which ERD design activity comes first?

. Create a detailed narrative of the organization's description of operations.

A ____ functionally determines all of the row's attributes.

. superkey

A ____ relationship exists when three entities are associated.

. ternary

What type of relationship is expressed with the phrase "Employee manages Store"?

1:1

The preferred way to represent multivalued attributes in a DBMS is to create a new entity composed of the original multivalued attribute's components in a(n) ____ relationship with the original entity.

1:M

What type of relationship is expressed with the phrase "Painter paints Painting"?

1:M

Almost all business designs use the _____ as the ideal normal form

3NF

The equijoin takes its name from the comparison operator ____ used in the condition.

=

The 1NF describes the tabular format in which:

A. all the key attributes are defined B. no repeating groups in the table C. all attributes are dependent on the primary key

A table that satisfies 2NF

Always satisfies 1NF

Which of the following is not a valid aggregate function?

COMPUTE

___ are normally expressed in the form of rules.

Constraints

____ exists when different versions of the same data appear in different places.

Data inconsistency

_________ is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.

Data integrity

Which of the following refers to the situation where different versions of the same data are stored at different places because they weren't updated consistently?

Data redundancy

In a database system, all the application data is stored in a single facility called the:

Database

____ yields only the rows that appear in both tables.

INTERSECT

A table whose primary key consists of only a single attribute is in 2NF if:

It is in 1NF

A table is in 2NF if:

It is in 1NF It has no partial dependencies

_________ is the body of information and facts about a specific subject.

Knowledge

________ provide a description of the data characteristics and the set of relationships that link the data found within the database.

Metadata

____ attributes are attributes that can have several values.

Multivalued

A field that consists of values on which you can perform arithmetic operations is a ____ type field.

Numeric

____ yields a vertical subset of a table.

PROJECT

_________ are the result of formatting disorganized data in order to facilitate storage, use and generation of information.

Structured data

A functional dependency between two or more nonkey attributes is called a(n):

Transitive dependency

A data model is usually graphical.

True

Each row in a relation is called a tuple.

True

____ combines all rows from two tables, excluding duplicate rows.

UNION

How can you change "Joel" into "Abram" in the "LastName" column in the Employee Table?

UPDATE Employee SET LastName = 'Abram' WHERE LastName = 'Joel';

_________ data exist in the format in which they were collected.

Unstructured

Which of the following might be represented with a single-valued attribute?

a serial number

A way of classifying data models is by degree of ____.

abstraction

A(n)_________ might be written by a programmer or it might be created through a DBMS utility program.

application

A ____ relationship exists when two entities are associated.

binary

A(n) ____ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.

business rule

A superkey that does not contain a subset of attributes that is itself a superkey is called a ____.

candidate key

A database that supports data located at a single site is called ___________ database:

centralized

The bridge entity is also known as a ____ entity.

composite

A(n) ____ model is independent of both hardware and software.

conceptual

A(n) ____ model represents a global view of the database as viewed by the entire organization.

conceptual

The basic building blocks of all data models are entities, attributes, relationships, and ____.

constraints

A ___________ _____________ develops when all the required changes in the redundant data are not made successfully.

data anomaly

A workgroup database will be used in a(n)

department within an organization

______ _________ depicts all the dependencies found within a given table structure.

dependency diagram

A(n) _______ is any attribute whose value determines other values within a row.

determinant

A ____ database supports data distributed across several different sites.

distributed

A CUSTOMER ____ would be described by attributes such as customer last name, customer first name, customer phone, customer address, and customer credit limit.

entity

A CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of ____ integrity.

entity

A noun in a business rule translates to a(n) ____ in the data model.

entity

As a general rule, a noun in a business rule will translate into a(n) ____ in the model.

entity

_________ is a character or group of characters that has a specific meaning.

field

_________ is a collection of related records.

file

Accurate, relevant, and timely information is the key to .

good decision making

The database system is composed of the five major parts:

hardware, software, people, procedures and data.

A(n) ____ is an ordered arrangement of keys and pointers.

index

A(n) ____ is an orderly arrangement used to logically access rows in a table

index

A(n) ____ join only returns matched records from the tables that are being joined.

inner

The process of database design is ____.

iterative

Any attribute that is part of a key is known as a ____.

key attribute

Students and classes have a ____ relationship.

many-to-many

Normalization represents a(n) _______ view of the entities within the ER diagram

micro

A(n) ____'s main function is to help you understand the complexities of the real-world environment.

model

Data models were developed to ____.

model real-world objects or events

A workgroup database is a(n)________ database.

multiuser

What type of attribute should not be implemented in a RDBMS?

multivalued

Within a table, each primary key value ____.

must be unique

Transitive dependency is dependency of one nonprime attribute on another ________ attribute.

nonprime

Normalization works through a series of stages called _____ ______.

normal forms

________ is a process for evaluating and correcting table structures to minimize the data redundancies

normalization

No data entry at all is known as a(n) ____.

null

For a violation of 2NF to occur in a table in 1NF, the following condition(s) must exist:

part of a key determines a nonkey attribute

Dependencies based on only a part of a composite primary key are called ______ _____.

partial dependency

Which of the following should be a derived attribute?

person's age

Which model operates at the lowest level of abstraction?

physical

When you can change the physical model without affecting the internal model, you have ____.

physical independence

We can describe a link by observing that a ____.

primary key of one table appears again as a foreign key in a related table

A ____ relationship is one in which a relationship can exist between occurrences of the same entity set.

recursive

Normalizing the table will reduce data ______.

redundancies

A(n) ____________________ is a representation of the relational database's entities, the attributes within those entities and the relationships between those entities.

relational diagram

A ____ _______ is a group of multiple entries for any single key attribute occurrence.

repeating group

1NF table is automatically in 2NF if its primary key is based on only a _______.

single attribute

A desktop database is a _______ database.

single-user

A ____ attribute is an attribute that can have only one value.

single-valued

The Crow's Foot model depicts the strong (identifying) relationship with a ____ line between the entities.

solid

A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.

strong

Another word for an existence-independent entity is a ____ entity.

strong

The ____ can be described as a detailed system data dictionary that describes all objects within the database, including data about table names, the table's creator and creation date, the number of columns in each table, the data type corresponding to each column, index filenames, index creators, authorized users, and access privileges.

system catalog

A(n) ____ is perceived as a two-dimensional structure composed of rows and columns.

table

Another word for the term "relation" is ____.

table

A relational database is a collection of ____.

tables

The normalization process starts with a simple ________ _____ procedure.

three step

Each table is perceived as a ____.

two-dimensional structure

A ____ relationship exists when an association is maintained within a single entity.

unary

A ____ index is an index in which the index key can have only one pointer value (row) associated with it.

unique

A(n) ____ entity is existence-dependent

weak

When the PK of a related entity does not contain a PK component of the parent entity, the relationship is ____.

weak

A(n)________ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.

workgroup