ISYS 330 Midterm Study Guide

A _____ attribute is one that cannot be subdivided. a.simple b.multivalued c.composite d.single-valued

a

A _____ entity has a primary key that is partially or totally derived from the parent entity in the relationship. a.weak b.strong c.child d.business

a

A _____ is a collection of related records. a. File b. Schema c. Column d. Field

a

A _____ is a logically connected set of one or more fields that describes a person, place, or thing. a. Record b. Database c. Column d. File

a

A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key is said to be in _____. a.1NF b.2NF c.3NF d.4NF

a

A verb associating two nouns in a business rule translates to a(n) _____ in the data model. a. Relationship b. Constraint c. Attribute d. Entity

a

A(n) _____ is bidirectional. a. Relationship b. Entity c. Attribute d. Constraint

a

From a structural point of view, 2NF is better than _____. a.1NF b.3NF c.4NF d.BCNF

a

From a structural point of view, 3NF is better than _____. a.2NF b.3NF c.5NF d.6NF

a

From a system functionality point of view, _____ attribute values can be calculated when they are needed to write reports or invoices. a.derived b.granular c.atomic d.historical

a

Ideally, an entity identifier is composed of _____ attribute(s). a.one b.two c.three d.six

a

If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have _____ based on this composite candidate key even when the primary key chosen is a single attribute. a.partial dependencies b.redundancies c.time-variances d.Boyce-Codd normal forms

a

Improving _____ leads to more flexible queries. a.atomicity b.normalization c.derived attribute d.denormalization

a

In a database context, the word _____ indicates the use of the same attribute name to label different attributes. a. Homonym b. Synonym c. Duplicate d. Redundancy

a

The _____ constraint can be placed on a column to ensure that every row in the table has a value for that column. a. NOT NULL b. VALUE c. UNIQUE d. EMPTY

a

The _____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text. a. Entity Relationship b. Hierarchical c. Object-Oriented d. Network

a

The _____ relationship should be rare in any relational database design. a. 1:1 b. 1:M c. M:1 d. M:N

a

The database structure in a DBMS is stored as a _____. a. Collection of Files b. Set of Key/Value Pairs c. Collection of Queries d. Single File

a

_____ are especially useful when you are trying to determine what values in related tables cause referential integrity problems. a. Outer joins b. Equijoins c. Theta joins d. Inner joins

a

A _____ is a character or group of characters that has a specific meaning. a. Database b. Field c. File d. Record

b

A _____ is the primary key of one table that has been placed into another table to create a common attribute. a. Candidate Key b. Foreign Key c. Composite Primary Key d. Superkey

b

A derived attribute is indicated in the Chen notation by a _____ that connects the attribute and an entity. a.single line b.dashed line c.double dashed line d.double line

b

A desktop database is a _____ database. a. Work Group b. Single-User c. Distributed d. Multi-User

b

A relational table must not contain a(n) _____. a.entity b.repeating group c.attribute d.relationship

b

A table is in 4NF if it is in 3NF, and _____. a.all attributes are unrelated b.it has no multivalued dependencies c.no column contains the same values d.all attributes must be dependent on the primary key and must be dependent on each other

b

A(n) _____ exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key. a.partial dependency b.transitive dependency c.atomic attribute d.repeating group

b

A(n) _____ join links tables by selecting only the rows with common values in their common attribute(s). a. Foreign b. Natural c. Attribute d. Unique

b

A(n) _____'s main function is to help one understand the complexities of the real-world environment. a. Node b. Model c. Entity d. Database

b

An attribute that is part of a key is known as a(n) _____ attribute. a.nonprime b.prime c.important d.entity

b

An entity is said to be _____-dependent if it can exist in the database only when it is associated with another related entity occurrence. a.data b.existence c.relationship d.business

b

Data warehouse routinely uses _____ structures in its complex, multilevel, multisource data environment. a.1NF b.2NF c.3NF d.4NF

b

Each table _____ represents an attribute. a. Row b. Column c. Dimension d. Value

b

Referential _____ dictates that the foreign key must contain values that match the primary key in the related table, or must contain null. a. Model b. Integrity c. Uniqueness d. Attribute

b

The _____ relationship is the "relational model ideal." a. 1:1 b. 1:M c. M:1 d. M:N

b

The conceptual model can handle _____ relationships and multivalued attributes. a.1:M b.M:N c.1:1 d.1:N

b

The entity relationship diagram (ERD) represents the _____ database as viewed by the end user. a.condensed b.conceptual c.physical d.logical

b

_____ is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions. a. Data anomaly b. Data integrity c. Data quality d. Data ubiquity

b

_____ is the result of revealing the meaning of raw facts. a. An encoded sample b. Information c. An encrypted bit d. End-user data

b

n a real-world environment, we must strike a balance between design integrity and _____. a.uniqueness b.flexibility c.robustness d.ease of use

b

A _____ key can be described as a minimal superkey, a superkey without any unnecessary attributes. a. Secondary b. Foreign c. Candidate d. Primary

c

A table that is in 2NF and contains no transitive dependencies is said to be in _____. a.1NF b.2NF c.3NF d.4NF

c

A(n) _____ is a restriction placed on the data. a. Attribute b. Relationship c. Constraint d. Entity

c

Accurate, relevant, and timely information is the key to ____. a. Knowledge b. Data Management c. Good Decision Making d. Understanding

c

An atomic attribute _____. a.displays multiplicity b.cannot exist in a relational table c.cannot be further subdivided d.is always chosen to be a foreign key

c

Dependencies based on only a part of a composite primary key are known as _____ dependencies. a.composite b.primary c.partial d.incomplete

c

Students and classes have a _____ relationship. a. One-to-Many b. One-to-One c. Many-to-Many d. Many-to-One

c

The first step in building an entity-relationship diagram (ERD) is _____. a.developing the initial ERD b.identifying the attributes and primary keys that adequately describe the entities c.creating a detailed narrative of the organization's description of operations d.identifying the business rules based on the description of operations

c

The term _____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment. a. Transaction b. Management System c. Database System d. Structured Data

c

To be considered minimally relational, the DBMS must support the key relational operators _____, PROJECT, and JOIN. a. DIFFERENCE b. INTERSECT c. SELECT d. UNION

c

To generate a surrogate key, Microsoft Access uses a(n) _____ data type. a.character b.sequence c.AutoNumber d.identity

c

Which of the following is true of business rules? a. They provide a framework for the company's self-actualization. b. They allow the designer to develop business processes. c. They can serve as a communication tool between the users and designers. d. They allow the designer to set company policies with regard to data.

c

_____ are important because they help to ensure data integrity. a. Relationships b. Attributes c. Constraints d. Entities

c

_____ exists when different versions of the same data appear in different places. a. Structural dependence b. Conceptual dependence c. Data inconsistency d. Poor data security

c

_____ expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity. a. Relationship b. Connectivity c. Cardinality d. Dependence

c

_____ serve as the intermediary between the user and the database. a. End-user data b. Metadata c. DBMSs d. Programming languages

c

A _____ attribute can be further subdivided to yield additional attributes. a.simple b.multivalued c.single-valued d.composite

d

A _____ is any key that uniquely identifies each row. a. Special Key b. Candidate Key c. Foreign Key d. Superkey

d

A _____ key is defined as a key that is used strictly for data retrieval purposes. a. Lookup b. Foreign c. Candidate d. Secondary

d

A noun in a business rule translates to a(n) _____ in the data model. a. Relationship b. Constraint c. Attribute d. Entity

d

A(n) _____ is the equivalent of a field in a file system. a. Constraint b. Relationship c. Entity d. Attribute

d

A(n) _____ represents a particular type of object in the real world. a. Relationship b. Node c. Attribute d. Entity

d

An example of denormalization is using a _____ denormalized table to hold report data. This is required when creating a tabular report in which the columns represent data that are stored in the table as rows. a.component b.transitive c.3NF d.temporary

d

Database design is a(n) _____ process based on repetition. a.intermittent b.sequential c.linear d.iterative

d

End-user data is _____. a. Accurate, relevant and timely information. b. Information about a specific subject. c. Knowledge about the end users. d. Raw facts of interest to the end user.

d

If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a _____ relationship. a.self b.looping c.self-referring d.recursive

d

If an entity can exist apart from all of its related entities, then it is existence-independent, and it is referred to as a(n) _____ entity. a.alone b.weak c.unary d.strong

d

In a database context, a(n) _____ indicates the use of different names to describe the same attribute. a. Duplicate b. Homonym c. Entity d. Synonym

d

In a(n) _____ diagram, the arrows above the attributes indicate all desirable dependencies. a.Chen b.ER c.functionality d.dependency

d

In the _____ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent. a. Hierarchical b. Entity Relationship c. Object-Oriented d. Network

d

The entity relationship model uses the associative entity to represent a(n) _____ relationship between two or more entities. a.M:1 b.N:1 c.1:M d.M:N

d

The most likely data type for a surrogate key is _____. a.character b.logical c.date d.numeric

d

When using the Crow's Foot notation, the associative entity is indicated by _____ relationship lines between the parents and the associative entity. a. double b. dotted c. triple d. solid

d

Which of the following is true of spreadsheet applications? a. They provide enhanced security and robust data sharing features. b. They are a better alternative to databases. c. They do not allow manipulation of data once entered. d. They enhance the user's ability to understand the data.

d

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? a. Data integrity b. Data query c. Data dictionary d. Data redundancy

d

_____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely. a.Temporary b.Normalized c.Report d.Data warehouse

d

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

d