INSY 3304 EXAM 1

Ace your homework & exams now with Quizwiz!

The object-oriented data model was developed in the _____.

1980s

At the implementation level, the supertype and its subtype(s) depicted in a specialization hierarchy maintain a(n) _____ relationship.

1:1

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

1:1

Data warehouse routinely uses _____ structures in its complex, multilevel, multisource data environment.

2NF

To generate a surrogate key, Microsoft Access uses a(n) _____ data type.

AutoNumber

_____ are normally expressed in the form of rules.

Constraints

A(n) _____ is the set of possible values for a given attribute.

Domain

Which of the following is a specialization hierarchy disjoint constraint scenario in case of partial completeness?

Each supertype occurrence is a member of at least one subtype.

A subtype contains attributes that are common to all of its supertypes.

False

An advantage of database systems is that you needn't perform frequent updates and apply latest patches.

False

Character data can contain any character or symbol intended for mathematical manipulation.

False

Database designers determine the data and information that yield the required understanding of the entire business.

False

Database programming languages receive all application requests and translate them into the complex operations required to fulfill those requests.

False

In Chen notation, entities and relationships have to be oriented horizontally; not vertically.

False

In a natural join, the column on which the join was made occurs twice in the new table.

False

In an SQL-based relational database, each table is dependent on every other table.

False

In implementation terms, an entity is existence-dependent if it has a mandatory primary key.

False

Normalization purity is often easy to sustain in the modern database environment.

False

One advantage of a database system over previous data management approaches is that the database system is considerably less complex.

False

The Crow's Foot notation easily identifies multivalued attributes.

False

The hierarchical model is software-independent.

False

The one-to-many (1:M) relationship is easily implemented in the relational model by putting the foreign key of the "1" side in the table of the "many" side as a primary key.

False

The order of the rows and columns is important to the DBMS.

False

Within a specialization hierarchy, a supertype can exist only within the context of a subtype.

False

_____ is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes.

Generalization

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

Keys

Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed only once in the _____ relationship.

M:N

_____ relationships can be implemented by creating a new entity in 1:M relationships with the original entities.

M:N

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

Metadata

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

NOT NULL

When the specific cardinalities are not included on the diagram in Crow's Foot notation, cardinality is implied by the use of _____.

Symbols

Which of the following is true of NoSQL databases?

They are not based on the relational model.

A data model is usually graphical.

True

A null is created when you press the Enter key or the Tab key to move to the next entry without making a prior entry of any kind.

True

A table is in fourth normal form if it is in third normal form and has no independent multivalued dependencies.

True

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

True

An entity in the entity relationship model corresponds to a table in the relational environment.

True

An implementation-ready data model should contain a description of the data structure that will store the end-user data.

True

At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a 1:1 relationship.

True

Connectivities and cardinalities are established by concise statements known as business rules.

True

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

True

In order to meet performance requirements, portions of the database design may need to be occasionally denormalized.

True

In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored.

True

In the context of partial dependencies, data redundancies occur because every row entry requires duplication of data.

True

In the entity relationship model, a table row corresponds to an entity instance.

True

Metadata describe the data characteristics and the set of relationships that links the data found within the database.

True

Relational algebra defines the theoretical way of manipulating table contents using relational operators.

True

Relational models view data as part of a table or collection of tables in which all key values must be identified.

True

The DIVIDE operation uses one single-column table (e.g., column "a") as the divisor and one two-column table (e.g., columns "a" and "b") as the dividend.

True

The combination of normalization and ER modeling yields a useful ERD, whose entities can be translated into appropriate table structures.

True

The objective of normalization is to ensure that each table conforms to the concept of well-formed relations.

True

Oracle 12c, MS SQL Server, and Tamino are examples of _____ data models.

XML Hybrid

An entity cluster is formed by combining multiple interrelated entities into _____.

a single entity object

A partial completeness constraint is represented by _____.

a single horizontal line under a circle

Improving _____ leads to more flexible queries.

atomicity

To simplify the conceptual design, most higher-order relationships are decomposed into appropriate equivalent _____ relationships whenever possible.

binary

BCNF can be violated only if the table contains more than one _____ key.

candidate

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

collection of files

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

constraint

A derived attribute is indicated in the Chen notation by a _____ that connects the attribute and an entity.

dashed line

A(n) _____ enables a database administrator to describe schema components.

data definition language (DDL)

The extended entity relationship model (EERM) is sometimes referred to as the _____.

enhanced entity relationship model

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

entity

A(n)_____ is a generic entity type that is related to one or more entity subtypes.

entity supertype

The default comparison condition for the subtype discriminator attribute is the _____ comparison.

equality

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

existence

In a real-world environment, we must strike a balance between design integrity and _____.

flexibility

In organizations that generate large number of transactions, _____ are often a top priority in database design.

high processing speeds

The property of _____ enables an entity subtype to inherit the attributes and relationships of the supertype.

inheritance

A table is in 4NF if it is in 3NF, and _____.

it has no multivalued dependencies

In a _____ situation, one key determines multiple values of two other attributes and those attributes are independent of each other.

multivalued dependency

If one exists, a data modeler uses a _____ as the primary key of the entity being modeled.

natural identifier

Overlapping subtypes are subtypes that contain _____ subsets of the supertype entity set.

nonunique

The most likely data type for a surrogate key is _____.

numeric

A data warehouse contains historical data obtained from the _____.

operational databases

If Tiny College has some departments that are classified as "research only" and do not offer courses, the COURSE entity of the college database would be _____ the DEPARTMENT entity.

optional to

In the context of total completeness, in a(n) _____, every supertype occurrence is a member of at least one subtype.

overlapping constraint

Dependencies based on only a part of a composite primary key are known as _____ dependencies.

partial

One important inheritance characteristic is that all entity subtypes inherit their _____ key attribute from their supertype.

primary

An attribute that is part of a key is known as a(n) _____ attribute.

prime

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

record

A relational table must not contain a(n) _____.

repeating group

Most data that can be encountered are best classified as _____.

semistructured

According to the "preferably single-attribute" characteristic of a primary key, the primary key:

should have the minimum number of attributes possible.

When a table contains only one candidate key, _____ are considered to be equivalent.

the 3NF and the BCNF

Normalization works through a series of stages called normal forms. For most purposes in business database design, _____ stages are as high as you need to go in the normalization process.

three

Nonoverlapping subtypes are subtypes that contain a(n) _____ subset of the supertype entity set.

unique

The "_____" characteristic of a primary key states that the primary key must uniquely identify each entity instance, must be able to guarantee unique values, and must not contain nulls.

unique values


Related study sets

Board Vitals Remediation 1st 200 Questions

View Set

Literary Devices 1st Semester Exam

View Set

SCIENCE 8th grade TEST: STRUCTURE OF MATTER

View Set