CSC 455 Test 1 - Flashcards

question

A ____ database supports data distributed across several different sites.

answer

distributed

question

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

answer

field

question

A ____ is a collection of related records.

answer

file

question

A ____ is a logically connected set of one or more fields that describes a person, place, or thing.

answer

record

question

A desktop database is a ____ database.

answer

single-user

question

A workgroup database is a(n)____ database.

answer

multiuser

question

A(n) ____ database is designed to support a company's day-to-day operations.

answer

transactional

question

A(n) ____ database is used by an organization and supports many users across many departments.

answer

enterprise

question

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

answer

workgroup

question

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

answer

application program

question

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

answer

good decision making

question

Most data you encounter is best classified as ____.

answer

semistructured

question

Most decision-support data are based on historical data obtained from ____.

answer

operational databases

question

The ____ serve(s) as the intermediary between the user and the database.

answer

DBMS

question

The database structure in a DBMS is stored as a ____.

answer

collection of files

question

The phrase ____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment.

answer

database system

question

The response of the DBMS to a query is the ____.

answer

query result set

question

An example of structured data

answer

spreadsheet

question

XML data is ____.

answer

semistructured

question

____ data are the result of formatting to facilitate storage, use and generation of information.

answer

structured

question

____ data exist in a format that does not lend itself to processing that yields information.

answer

unstructured

question

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

answer

unstructured

question

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

answer

data inconsistency

question

____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database.

answer

metadata

question

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

answer

entity

question

A verb associating two nouns in a business rule translates to a(n) ____ in the data model.

answer

relationship

question

A(n) ____ enables a database administrator to define schema components.

answer

data definition language (DDL)

question

A(n) ____ is a restriction placed on the data.

answer

constraint

question

A(n) ____ is anything about which data are to be collected and stored.

answer

entity

question

A(n) ____ is bidirectional.

answer

relationship

question

A(n) ____ is the equivalent of a field in a file system.

answer

attribute

question

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

answer

conceptual

question

A(n) ____ represents a particular type of object in the real world.

answer

entity

question

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

answer

model

question

Business rules are derived from ____.

answer

a detailed description of an organization's operations

question

MySQL is an example of a(n) ____.

answer

relational data model

question

Students and classes have a ____ relationship.

answer

many-to-many

question

The ____ model is the end users' view of the data environment.

answer

external

question

The ____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.

answer

entity relationship

question

They can serve as a communication tool between the users and designers.

answer

business rules

question

____ are important because they help to ensure data integrity.

answer

constraints

question

____ are normally expressed in the form of rules.

answer

constraints

question

In an SQL-based relational database, rows in different tables are related based on common values in common attributes.

answer

true

question

Each row in the relational table is known as an entity instance or entity occurrence in the ER model.

answer

true

question

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.

answer

entity

question

A ____ contains at least all of the attribute names and characteristics for each table in the system.

answer

data dictionary

question

A ____ key can be described as a superkey without unnecessary attributes, that is, a minimal superkey.

answer

candidate

question

A ____ key is defined as a key that is used strictly for data retrieval purposes.

answer

secondary

question

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

answer

index

question

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

answer

table

question

A(n) ____ join links tables by selecting only the rows with common values in their common attribute(s).

answer

natural

question

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

answer

inner

question

All primary key entries are unique, and no part of a primary key may be ____.

answer

null

question

Another name for a composite entity is a ____ entity.

answer

bridge

question

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

answer

key attribute

question

Controlled ____ makes a relational database work.

answer

redundancy

question

Date attributes contain calendar dates stored in a special format known as the ____ date format.

answer

Julian

question

In a database context, a(n) ____ indicates the use of different names to describe the same attribute.

answer

synonym

question

In a database context, the word ____ indicates the use of the same attribute name to label different attributes.

answer

homonym

question

In an outer join, the matched pairs would be retained and any unmatched values in the other table would be left ____.

answer

null

question

In the context of a database table, the statement "A ____ B" indicates that if you know the value of attribute A, you can look up the value of attribute B.

answer

determines

question

In the relational model, ____ are important because they are used to ensure that each row in a table is uniquely identifiable.

answer

keys

question

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

answer

null

question

Referential ____ means that if the foreign key contains a value, that value refers to an existing valid tuple (row) in another relation.

answer

integrity

question

Since it is used to link the tables that originally were related in a M:N relationship, the composite entity structure includes—as foreign keys—at least the ____ keys of the tables that are to be linked.

answer

primary

question

The ____ constraint can be placed on a column to ensure that every row in the table has a value for that column.

answer

not null

question

The ____ is actually a system-created database whose tables store the user/designer-created database characteristics and contents.

answer

system catalog

question

The ____ relational type is the "relational model ideal."

answer

1:M

question

The ____ relationship should be rare in any relational database design.

answer

1:1

question

The attribute B is ____ the attribute A if each value in column A determines one and only one value in column B.

answer

functionally dependent on

question

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

answer

=

question

To be considered minimally relational, the DBMS must support the key relational operators ____, PROJECT, and JOIN.

answer

select

question

When you define a table's primary key, the DBMS automatically creates a(n) ____ index on the primary key column(s) you declared.

answer

unique

question

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

answer

union

question

____ data can have only a true or false (yes or no) values.

answer

logical

question

____ yields a vertical subset of a table.

answer

project

question

____ yields only the rows that appear in both tables.

answer

intersect

question

____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition.

answer

select

question

A foreign key must exist in both tables that have a relationship.

answer

false

question

A ____ attribute can be further subdivided to yield additional attributes.

answer

composite

question

A ____ attribute can have only one value.

answer

single-valued

question

A ____ attribute is one that cannot be subdivided.

answer

simple

question

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

answer

weak

question

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

answer

unary

question

A ____ relationship exists when three entities are associated.

answer

ternary

question

A ____ relationship exists when two entities are associated.

answer

binary

question

A ____ should be a derived attribute.

answer

person's age

question

Need not be physically stored within the database

answer

a derived attribute

question

A derived attribute is indicated in the Chen model by a ____.

answer

dashed line

question

A relationship is an association between ____.

answer

entities

question

A(n) ____ entity is composed of the primary keys of each of the entities to be connected.

answer

associative

question

Although the conceptual model can handle ____ relationships and multivalued attributes, you should not implement them in the RDBMS.

answer

M:N

question

An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.

answer

existence

question

Another word for existence-independent is ____.

answer

strong

question

Attributes may share a ____.

answer

domain

question

Ideally, an entity identifier is composed of ____ attribute(s).

answer

one

question

If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ____ relationship.

answer

recursive

question

If an entity can exist apart from one or more related entities, it is said to be ____-independent.

answer

existence

question

In an ER diagram, primary keys are indicated by ____.

answer

underlining

question

The Crow's foot symbol with two parallel lines indicates ____ cardinality.

answer

(1,1)

question

The ____ attribute(s) make up the primary key in the table definition: CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)

answer

CRS_CODE and CLASS_SECTION

question

The set of possible values for an attribute is a ____.

answer

domain

question

____ attributes can have many values.

answer

multivalued

question

____ relationships are most common.

answer

binary

CSC 455 Test 1 – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards