MidTerm Study

Question 1

T/F: 2 tables can be linked or joined together through a common field.

Answer 1

True

Question 2

Which of the following does not contain repeating groups, but has a primary key and possibly partial dependencies?

A. 1NF
B. 2NF
C. 3NF
D. 4NF

Answer 2

A. 1NF

Question 3

Which of the following is used to create and maintain the physical database?

A. SQL
B. schema
C. DBMS

Answer 3

C. DBMS

Question 4

What represents a characteristic or attribute that is being collected about an entity?

A. Row
B. Tuple
C. Column
D. Field

Answer 4

D. Field

Question 5

T/F: Tables can be linked or joined together through their primary keys.

Answer 5

False

Question 6

For every occurance of A, there can only be one occurance of B.
This is an example of what type of relationship?

A. One-to-One
B. One-to-Many
C. Many-to-Many

Answer 6

A. One-to-One

Question 7

A field in the logical design of a database corresponds to a ____ in the physical database.

A. Row
B. Column
C. Field
D. Entity

Answer 7

B. Column

Question 8

Which of the following is used to determine the correct organization for data that is to be stored in a database?

A. SDLC
B. DBMS
C. Data Model
D. Normalization

Answer 8

D. Normalization

Question 9

A(n) ____________________ table can be added to the physical database to eliminate a many-to-many relationship.

Answer 9

Bridging

Question 10

If a recipe contains several ingredients, and those ingredients can also be used in other recipes, this would be an example of what type of relationship?

A. One-to-One
B. One-to-Many
C. Many-to-Many

Answer 10

C. Many-to-Many

Question 11

Which of the following is used to uniquely identify each record?

A. Foreign Key
B. Unique Field
C. Primary Key
D. Relation

Answer 11

C. Primary Key

Question 12

T/F: The simplest approach to remove a partial dependency is to use each portion of the primary key to create separate tables.

Answer 12

True

Question 13

T/F: The Systems Development Life Cycle is a series of steps that can be used to guide the development process for a database management system.

Answer 13

True

Question 14

A composite primary key can lead to what?

A. Transitive Dependencies
B. Partial Dependencies
C. Total Dependencies

Answer 14

B. Partial Dependencies

Question 15

A ____ is a group of interrelated files.

A. database
B. field
C. column
D. entity

Answer 15

A. database

Question 16

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

Answer 16

True

Question 17

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

A. ease of use
B. stability
C. flexibility
D. efficiency

Answer 17

C. flexibility

Question 18

T/F: Repeating groups must be eliminated by making sure that each row defines a single entity.

Answer 18

True

Question 19

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

Answer 19

prime

Question 20

A(n) ____________________ derives its name from the fact that a group of multiple entries of the same type can exist for any single key attribute occurrence.

A. duplicate group
B. repeating group
C. multi-valued

Answer 20

B. repeating group

Question 21

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

Answer 21

repeating group

Question 22

Dependencies based on only a part of a composite primary key are called ____ dependencies.

Answer 22

partial

Question 23

T/F: Normalization should be performed after the design process

Answer 23

False

Should be done during the design process

Question 24

Normalization works through a series of stages called ___________________ forms

Answer 24

normal

Question 25

Because a partial dependency can exist only if a table’s primary key is composed of several attributes, a table whose ____________________ key consists of only a single attribute is automatically in 2NF if it is in 1NF.

Answer 25

primary