Deck 15: Normalize a Database for Effective Design

Question 1

While several orders can be placed on the same day,one order cannot be placed on more than one date.Thus,order date is ________ the key of Order ID.

A)determined by
B)dependent on
C)transitioning to
D)reliant on

Answer 1

B

Question 2

A(n)________ anomaly forces you to enter data about two different entities when you have data on only one entity.

A)insertion
B)update
C)delete
D)cascade

Answer 2

A

Question 3

A database record equivalent is also known as a(n)________.

A)attribute
B)entity
C)nonkey field
D)tuple

Answer 3

D

Question 4

A(n)________ key is created from nonnaturally occurring data that is visible to the user,such as sequential numbering from the AutoNumber data type.

A)surrogate
B)artificial
C)candidate
D)concatenated

Question 5

A depends on B and B depends on C,thus A implies C.If C is a candidate key and B is not a candidate key,this is a(n)________.

A)transitive dependency
B)determinate
C)partial dependency
D)atomic record

Question 6

A(n)________ is when the field only depends on one part of a composite or concatenated key.

A)determinate
B)transitive dependency
C)partial dependency
D)atomic record

Question 7

The ________ requires that the table has to be free of transitive dependencies and that all lower levels of NF are satisfied.

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

Question 8

When multiple fields are used to identify a record,it is a(n)________ key.

A)artificial
B)natural
C)alternate
D)composite

Question 9

________ will update a foreign key automatically when the primary key changes.

A)Referential integrity
B)Cascade update
C)Cascade delete
D)Domain integrity constraints

Question 10

Which of the following is NOT true regarding second normal form?

A)The second normal form requires that the table has no fields with partial dependencies on a composite or concatenated key.
B)The table satisfies 1NF.
C)The table may contain a transitive dependency.
D)The table could have a partial dependency.

Question 11

A(n)________ anomaly forces you to change data in multiple records,such as when you need to change the name of a product and you must change multiple rows.

A)insertion
B)update
C)delete
D)cascade

Question 12

A(n)________ key is created from naturally occurring data outside of the database,such as a driver's license number.

A)natural
B)artificial
C)alternate
D)composite

Question 13

Which of the following is NOT true regarding normal forms?

A)If a database is stated to be 3NF,this means that all tables in the database meet the criteria for the first three normal forms.
B)The highest level of normal form is 3NF.
C)Each level represents the table's vulnerability to redundancy,anomalies,and inaccuracies.
D)The highest normal form is the level that a table satisfies along with all levels below.

Question 14

Which of the following is NOT true regarding anomalies?

A)Anomalies can be categorized into three types-insert,delete,and update.
B)One goal of concatenating fields is to minimize anomalies.
C)Update anomalies can be difficult to detect.
D)Anomalies are unmatched or missing data that is caused by limitations in database design.

Question 15

Which of the following is NOT true when deciding when to use a surrogate key?

A)The advantage with a surrogate key is that it can help prevent some cascading changes from primary to foreign key errors.
B)A surrogate key can increase the file size and require more joins.
C)If the key never has a foreign key,you need a surrogate key.
D)If you have a primary key with a foreign key that may need to be changed frequently or more than normal,a surrogate key should be considered.

Question 16

The ________ requires that all determinants are candidate keys and that all lower levels of NF are satisfied.

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

Question 17

________ are frequently shown in a functional dependency diagram.

A)Dependencies
B)Determinants
C)Entities
D)Normal forms

Question 18

Candidate keys that are not used for the primary keys are ________ keys.

A)artificial
B)natural
C)alternate
D)composite

Question 19

Which of the following is NOT true regarding first normal form?

A)The first normal form dictates that the table must not have repeating groups of values in a single column or anomaly and that it must have a key.
B)In 1NF each nonkey field needs some sort of dependency on the key.
C)A record is considered atomic when none of the values are repeating or concatenated for a single column.
D)If the values are repeated in the rows that are currently blank,each row will become atomic and each row will represent one database record or tuple.

Question 20

________ will remove every record with the foreign key if the record with the value is deleted from the primary table.

A)Cardinality
B)Cascade update
C)Cascade delete
D)Domain integrity constraints

Question 21

Which of the following is NOT true about identifying the attributes in an ERD?

A)A second inside circle is used for multivalued attributes.
B)Key attributes are bolded.
C)Derived values are represented with a dashed oval line.
D)Attributes are information about the entity or the data.

Question 22

In a small business,a department might be managed by no more than one manager,and each manager manages no more than one department.This is an example of a ________ relationship.

A)many-to-many
B)one-to-one
C)one-to-many
D)You cannot create this type of relationship without a junction table.

Question 23

A deletion anomaly forces you to delete one piece of data when you wanted to delete two pieces of data.

Question 24

Which of the following is NOT true about identifying the cardinality in an ERD?

A)You may need to add a join table.
B)Use 1:N or 1:M for a one-to-many relationship.
C)Use M:M for a many-to-many relationship.
D)Use 1:1 for a one-to-one relationship.

Question 25

Which of the following is NOT true about identifying the entities in an ERD?

A)Entities are people,places,or items that you want to keep data about.
B)Bridge entities use a composite key.
C)Composite keys are drawn in a diamond with a rectangle around it.
D)Weak entities have a primary key.

Question 26

Which of the following is NOT true regarding entity relationship diagrams?

A)The asterisk next to the field name designates the foreign key field in each table.
B)An ERD does not tell you anything about data flow.
C)An ERD is a fixed view of the database structure.
D)An ERD is a way of visually expressing the database structure.

Question 27

Which of the following is NOT a step that you would take when creating an ERD?

A)Identify the entities.
B)Determine the functionality of the relationships.
C)Identify the relationships.
D)Identify the attributes.

Question 28

________ are rules that are specific for each field in a table.

A)Cardinality
B)Integrity constraints
C)Junctions
D)Domain integrity constraints

Question 29

An update anomaly forces you to change data in multiple records,such as when you need to change the name of a product and you must change multiple rows to make the update.

Question 30

Normalization is the process of minimizing the duplication of information in a relational database through effective database design.

Question 31

An insertion anomaly suggests that you enter data about two different entities when you have data on only one entity.

Question 32

Access allows you to add some ________ to your database to help ensure the data's validity.

A)Cardinality
B)Integrity constraints
C)Junctions
D)Domain integrity constraints

Question 33

The 1NF dictates that the table must have atomicity.

Question 34

One goal of normalization is to minimize anomalies,in particular three anomalies-insert,delete,and update.

Question 35

A product can be in many different orders and each order can have many products in inventory.This is an example of a ________ relationship.

A)many-to-one
B)one-to-one
C)one-to-many
D)You cannot create this type of relationship without a junction table.

Question 36

Which of the following is NOT a shape included on an ERD?

A)Rectangle
B)Diamond
C)Triangle
D)Oval

Question 37

In an ERD,the ________ approach will list the tables in a database as rectangles with lines and symbols representing the types of relationships between them.

A)crow's feet
B)visual
C)basic shapes
D)symbolic

Question 38

Atomicity refers to unmatched or missing data that is caused by limitations in database design.

Question 39

Delete anomalies can be difficult to detect.

Question 40

________ indicate(s)the number of instances of one entity that relates to one instance of another entity.

A)Referential integrity
B)Anomalies
C)Cascading
D)Cardinality

Question 41

A dependency requires that the table has no fields with partial dependencies on a composite or concatenated key and satisfies 1NF.

Question 42

A transitive dependency is when the field only depends on one part of a composite or concatenated key.In other words,the field is determined by only one piece of a multifield key.

Question 43

Each employee can only be in the employees table exactly one time.However,an employee can be in the orders table many times,once for each sale.

Question 44

A primary key is a field that uniquely identifies a record.

Question 45

When multiple fields are used to identify a record,it is a composite key,which is sometimes referred to as a concatenated key.

Question 46

Candidate keys that are used for the primary key are alternate keys.

Question 47

An entity relationship diagram tells you about data flow and is a fixed view of the database structure.

Question 48

A surrogate key is not visible to the user.

Question 49

A product can be in many different orders.Also,each order can have many products in inventory.This is an example of a M:N relationship.

Question 50

Another name for a field in a table is a tuple.

Question 51

A partial dependency is when a field depends on another field in the table,which then depends on a candidate key.

Question 52

An example of an artificial key is a driver's license number.

Question 53

An example of a natural key is sequential numbering from the AutoNumber data type.

Question 54

By normalizing to BCNF,you are eliminating all transitive dependencies.

Question 55

In a small business,a department might be managed by no more than one manager,and each manager manages no more than one department.This is an example of a 1:1 relationship.

Question 56

A surrogate key can increase the file size and require more joins.

Question 57

A record is considered atomic when none of the values are repeating or concatenated for a single column.

Question 58

The third normal form requires that the table has to be free of transitive dependencies and that the table satisfies both 1NF and 2NF.

Question 59

Referential integrity in relationships requires that only values that have a corresponding value in the primary table can be entered for a foreign key.

Question 60

Cardinality indicates the number of instances of one entity that relates to one instance of another entity.

Question 61

The process of normalization holds each table to a progressive series of criteria known as ________.

Question 62

Candidate keys that are not used for the primary key are ________ keys.

Question 63

A key can be a(n)________ key that is nonnaturally occurring data that is visible to the user,such as sequential numbering from the AutoNumber data type.

Question 64

A database record equivalent is also known as a(n)________.

Question 65

The ________ normal form requires that the table has to be free of transitive dependencies.

Question 66

By normalizing to ________,you are eliminating all functional dependencies.

Question 67

________ are unmatched or missing data that is caused by limitations in database design.

Question 68

________ in relationships requires that only values that have a corresponding value in the primary table can be entered for a foreign key.

Question 69

A(n)________ is when a field depends on another field in the table,which then depends on a candidate key.

Question 70

A(n)________ exists when a field relates to a key.

Question 71

A(n)________ forces you to enter data about two different entities when you have only data on only one entity.

Question 72

A(n)________ is a field that determines the value of another field.

Question 73

The ________ normal form is the level that a table satisfies along with all levels below.

Question 74

A key can be a(n)________ key which is nonnaturally occurring data that is not visible to the user.

Question 75

A(n)________ is when the field only depends on one part of a composite or concatenated key.In other words,the field is determined by only one piece of a multifield key.

Question 76

In the ________ normal form,the table has no fields with partial dependencies on a composite or concatenated key.

Question 77

________ is the process of minimizing the duplication of information in a relational database through effective database design.

Question 78

A(n)________ key that is created from naturally occurring data generated outside of a database such as a driver's license number.

Question 79

The ________ normal form dictates that the table must not have repeating groups of values in a single column and that it must have a key.

Question 80

Each employee can only be in the employees table exactly one time.However,an employee can be in the orders table many times,once for each sale.This is an example of a(n)________ relationship.