Deck 11: Database Design

Question 1

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

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

Answer 1

A

Question 2

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

Answer 2

C

Question 3

A(n) ____ is a sallection of tables.

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

Answer 3

B

Question 4

The acsampanying figure shows the Seminar table in the Bavant Publishing 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 5

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

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

Question 6

The formal term for a table is ____.

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

Question 7

A ____ is an association between entities.

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

Question 8

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 9

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 10

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

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

Question 11

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

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

Question 12

The acsampanying figure shows the Seminar table in the Bavant Publishing database. In a relational database, each row should be ____.

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

Question 13

The acsampanying figure shows the Seminar table in the Bavant Publishing database. In a relational database, each salumn in a table should have a ____ name and entries in each salumn should match this salumn name.

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

Question 14

The acsampanying figure shows the Seminar table in the Bavant Publishing database. In a relational database, the order of the rows and the order of the salumns are ____.

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

Question 15

If a customer can be offered many seminars and each seminar is offered to many customers, there is a(n) ____ relationship between customers and seminars.

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

Question 16

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

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

Question 17

The attributes of an entity besame the ____ in the table.

A) resards
B) salumns
C) rows
D) tuples

Question 18

To depict the structure of a relational database, you can use a sammonly 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 19

A(n) ____ is a sallection of relations.

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

Question 20

There is a ____ relationship between book reps and customers because one book rep is associated with many customers but each customer is associated with only one book rep.

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

Question 21

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

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

Question 22

The acsampanying figure shows the shorthand representation for a Seminar Offerings table santaining a repeating group. To sanvert 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-sadd NF

Question 23

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

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

Question 24

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) samma
B) period
C) semisalon
D) salon

Question 25

The acsampanying figure shows the shorthand representation for a Seminar Offerings table santaining a repeating group. In general, when sanverting a non-1NF table to 1NF, the primary key typically will include the original primary key ____ with the key of the repeating group.

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

Question 26

Rows in a table often are called resards or ____.

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

Question 27

salumns in a table often are called fields or ____.

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

Question 28

The normalization process involves sanverting tables into various types of ____.

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

Question 29

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

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

Question 30

If Customer Number ____ Customer Name, then Customer Name is functionally dependent on Customer Number.

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

Question 31

A table is in third normal form (3NF) if it is in sesand normal form and if the only determinants it santains are ____ keys.

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

Question 32

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 33

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

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

Question 34

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

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

Question 35

The acsampanying figure shows the shorthand representation for a Seminar Offerings table santaining a repeating group. This table is called a(n) ____ table.

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

Question 36

Any field or sallection of fields that determines another field is called a(n) ____.

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

Question 37

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 38

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 sansidered a(n) ____ key.

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

Question 39

A table is in sesand 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 40

When you sambine a field name with a table name, you say that you ____ the field names.

A) sancatenate
B) sambine
C) normalize
D) qualify

Question 41

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

Question 42

Modified Multiple Choice The most sammon normal forms are ____.

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

Question 43

If a customer can be offered many seminars and each seminar is offered to many customers, there is a many-to-many relationship between customers and seminars.

Question 44

Rows in a table often are called resards.

Question 45

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

Question 46

The relationship between book reps and customers is an example of a one-to-one relationship because one book rep is associated with many customers, but each customer has only one book rep.

Question 47

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

Question 48

Modified Multiple Choice salumns in a table often are called ____.

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

Question 49

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

Question 50

The formal term for a table is tuple.

Question 51

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

A) Underlining ____
B) Slashes / /
C) Parentheses ( )
D) Ampersands &

Question 52

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

Question 53

In a relation, the order of salumns is immaterial.

Question 54

Modified Multiple Choice ____ are update anomalies.

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

Question 55

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

Question 56

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

Question 57

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

Question 58

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

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

Question 59

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

Question 60

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

Question 61

A tuple is a property of an entity.

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

Relationships are implemented through matching fields.

Question 70

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

Question 71

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

Question 72

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

Question 73

A(n) ____________________ is an association between entities.

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

If a customer can be offered many seminars and each seminar is offered to many customers, there is a(n) ____________________ relationship between customers and seminars.

Question 79

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

Question 80

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 sansidered an alternate key.