Deck 12: Database Design

Question 1

The attributes of an entity become the _____ in the table.

A) records
B) columns
C) rows
D) tuples

Answer 1

B

Question 2

If a client can be offered many courses and each course is offered to many clients, there is a(n) _____ relationship between clients and courses.

A) many-to-one
B) many-to-many
C) all-to-all
D) one-to-many

Answer 2

B

Question 3

A(n) _____ is a collection of relations.

A) entity
B) relational database
C) tuple
D) normal form

Answer 3

B

Question 4

A(n) _____ is an association between entities.

A) relationship
B) normalization
C) configuration
D) union

Question 5

If one employee is assigned to a project and each project has only one employee working on it, there is a(n) _____ relationship between employees and projects.

A) uni-to-uni
B) only-to-one
C) one-to-one
D) one-to-many

Question 6

There is a _____ relationship between business analysts and clients because one business analyst is associated with many clients but each client is associated with only one business analyst.

A) one-to-one
B) one-to-all
C) many-to-one
D) one-to-many

Question 7

A(n) _____ is a collection of tables.

A) entity
B) relational database
C) tuple
D) normal form

Question 8

A(n) _____ is like a noun: It is a person, place, thing, or event.

A) record
B) tuple
C) entity
D) attribute

Question 9

When creating a database, a(n) _____ is represented as a table.

A) entity
B) attribute
C) determinant
D) tuple

Question 10

Many-to-many relationships are implemented through an additional table that contains _____ fields for both of the related tables.

A) matching
B) dependent
C) descendent
D) nonkey

Question 11

The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, each row should be _____.

A) updated
B) unique
C) normalized
D) non-descript

Question 12

A(n) _____ is a property of an entity.

A) record
B) tuple
C) entity
D) attribute

Question 13

The process of determining the particular tables and fields that will make up a database is known as _____.

A) visualization
B) diagramming
C) normalization
D) database design

Question 14

The determination of database requirements is part of a process known as _____.

A) visualization
B) systems analysis
C) normalization
D) outlining

Question 15

A(n) _____ interviews users, examines existing and proposed documents, investigates current procedures, and reviews organizational policies to determine exactly the type of data needs the database must support.

A) network analyst
B) SQL specialist
C) infrastructure analyst
D) systems analyst

Question 16

The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, the order of the rows and the order of the columns are _____.

A) predetermined
B) critical
C) immaterial
D) distinct

Question 17

The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, you should restrict each position in the table to a single entry, that is, you do not permit multiple entries, often called _____ in the table.

A) anomalies
B) tuples
C) redundancy
D) repeating groups

Question 18

The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, each column in a table should have a _____ name and entries in each column should match this column name.

A) unique
B) pre-defined
C) computer-generated
D) duplicate

Question 19

When you combine a field name with a table name, you say that you _____ the field names.

A) concatenate
B) combine
C) normalize
D) qualify

Question 20

The formal term for a table is _____.

A) tuple
B) relation
C) two-dimensional record
D) object

Question 21

The _____ key of a table is the field or minimum collection of fields that uniquely identifies a given row in that table.

A) alternate
B) index
C) secondary
D) primary

Question 22

Columns in a table often are called fields or _____.

A) attributes
B) lines
C) relations
D) tuples

Question 23

The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. In general, when converting a non-1NF table to 1NF, the primary key typically will include the original primary key _____ with the key of the repeating group.

A) concatenated
B) unionized
C) cross-joined
D) equi-joined

Question 24

To depict the structure of a relational database, you can use a commonly accepted shorthand representation. You write the name of the table and then within _____ list all of the fields in the table.

A) square brackets [ ]
B) curly braces { }
C) slashes / /
D) parentheses ( )

Question 25

Rows in a table often are called records or _____.

A) attributes
B) lines
C) relations
D) tuples

Question 26

A(n) _____ key is a field in one table whose values are required to match the primary key of another table.

A) alternate
B) foreign
C) candidate
D) relational

Question 27

The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. This table is called a(n) _____ table.

A) redundant
B) duplicate
C) 1NF
D) unnormalized

Question 28

Any field or collection of fields that determines another field is called a(n) _____.

A) attribute
B) antipode
C) determinant
D) descendent

Question 29

A table is in third normal form (3NF) if it is in second normal form and if the only determinants it contains are _____ keys.

A) alternate
B) indexed
C) primary
D) candidate

Question 30

_____ is the process of making sure that a database design is free of potential update, redundancy, and consistency problems.

A) Redaction
B) Synchronization
C) Replication
D) Normalization

Question 31

A field is a(n) _____ field if it is not part of the primary key.

A) attribute
B) nonkey
C) non-normal
D) alpha

Question 32

The normalization process involves converting tables into various types of _____.

A) tuples
B) relations
C) normal forms
D) diagrams

Question 33

A table that contains a repeating group, or multiple entries for a single row, is called a(n) _____ table.

A) 1NF
B) unnormalized
C) redundant
D) duplicate

Question 34

The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. To convert the table to _____, remove the parentheses enclosing the repeating group and expand the primary key to include the key to the repeating group.

A) 1NF
B) 2NF
C) 3NF
D) Boyce-Codd NF

Question 35

Social Security Number and Employee ID are candidate keys for a table. An organization chooses Employee ID as the primary key. Social Security Number is considered a(n) _____ key.

A) primary
B) candidate
C) alternate
D) index

Question 36

An organization can use either Social Security Number or Employee ID as the primary key for a table. These two fields are considered _____ keys.

A) primary
B) candidate
C) alternate
D) index

Question 37

A table is in second normal form (2NF) if it is in first normal form and no _____ field is dependent on only a portion of the primary key.

A) attribute
B) alpha
C) non-normal
D) nonkey

Question 38

If you have already created a database and relationships in Access, the _____ window and corresponding report provide a helpful diagram of the design.

A) Referential Integrity
B) Database Tools
C) Relationships
D) ERD

Question 39

If Client Number _____ Client Name, then Client Name is functionally dependent on Client Number.

A) precedes
B) qualifies
C) determines
D) follows

Question 40

When duplicate field names exist in a database, you need to indicate the field to which you are referring. You do so by writing both the table name and the field name separated by a _____.

A) comma
B) period
C) semicolon
D) colon

Question 41

Modified Multiple Choice The most common normal forms are _____.

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

Question 42

Modified Multiple Choice ____ are update anomalies.

A) Update
B) Inconsistent data
C) Additions
D) Deletions

Question 43

In a relation, the order of rows is fixed; rows must be in ascending order by primary key.

Question 44

Modified Multiple Choice _____ is(are) used in the shorthand representation of table.

A) Underlining ____
B) Slashes / /
C) Parentheses ( )
D) Arrow ®

Question 45

Rows in a table often are called records.

Question 46

Standardization is a process used to make sure a database design is free of potential update, redundancy, and consistency problems.

Question 47

In designing a database, you must first identify the fields in the database and then the tables.

Question 48

A dependent key is a field or combination of fields on which all fields in the table are functionally dependent.

Question 49

Many-to-many relationships are implemented through an additional table that contains matching fields for both of the related tables.

Question 50

If you use the word, Order, for the name of a table, you cannot use SQL to query that table.

Question 51

A foreign key is a field in one table whose values are required to match the primary key of another table.

Question 52

In a relation, the order of columns is immaterial.

Question 53

The formal term for a table is tuple.

Question 54

The relationship between business analysts and clients is an example of a one-to-one relationship because one business analyst is associated with many clients, but each client has only one business analyst.

Question 55

The primary key of a table is the field or minimum collection of fields that uniquely identifies a given row in that table.

Question 56

In Access, the terms record and field are used to describe rows and columns in a relation.

Question 57

If a client can be offered many courses and each course is offered to many clients, there is a many-to-many relationship between clients and courses.

Question 58

You always must qualify field names, even if there is no possibility of confusion.

Question 59

Modified Multiple Choice Rows in a table often are called _____.

A) records
B) attributes
C) fields
D) tuples

Question 60

Modified Multiple Choice Columns in a table often are called _____.

A) records
B) attributes
C) fields
D) tuples

Question 61

A tuple is a property of an entity.

Question 62

A field is a dependent field if it is not part of the primary key.

Question 63

If the primary key of a table contains only a single field, the table is automatically in second normal form (2NF).

Question 64

Social Security Number and Employee ID are candidate keys for a table. An organization chooses Employee ID as the primary key. Social Security Number is considered an alternate key.

Question 65

The process of determining the particular tables and fields that will make up a database is known as ____________________.

Question 66

Any field or collection of fields that determines another field is called a descendent.

Question 67

A table that contains a repeating group, or multiple entries for a single row, is called a non-standard table.

Question 68

A(n) ____________________ is an association between entities.

Question 69

If a client can be offered many courses and each course is offered to many clients, there is a(n) ____________________ relationship between clients and courses.

Question 70

If you know that whenever you are given a value for one field, you will be able to determine a single value for a second field, the first field is said to define the second field.

Question 71

The goal of normalization is to take a table or collection of tables and produce a new collection of tables that represents the same information but is free of problems.

Question 72

A table is in first normal form (1NF) if it does not contain repeating groups.

Question 73

The determination of database requirements is part of a process known as systems analysis .

Question 74

You can use an entity-relationship diagram (ERD) to diagram a database design.

Question 75

A(n) ____________________ is like a noun: It is a person, place, thing, or event.

Question 76

When you merge entities in a database design, the merged entities automatically will be in third normal form (3NF).

Question 77

Relationships are implemented through matching fields.

Question 78

Existing documents, such as purchase orders and procedural manuals, can often furnish helpful information concerning the database design.

Question 79

A table is in third normal form (3NF) if it is second normal form and if the only determinants it contains are candidate keys.

Question 80

The determination of database requirements is part of a process known as ____________________.