Question 1

In IDEF1X terminology, what is a subtype called?
A) catalog
B) category
C) entity
D) discriminator

Accepted Answer

In IDEF1X terminology, a subtype is referred to as a category. This is used to represent a subset of a larger entity, where the subset shares common attributes or relationships but also has distinct characteristics that justify its separation into a category.

Question 2

Columns that are of interest strictly for the purpose of retrieval are known as ____________________.

Accepted Answer

The answer of Columns that are of interest strictly for...

Question 3

As soon as you have completed Steps 1 through 3 for a given user view, you can merge the results into the __________________ design.

Accepted Answer

The answer of As soon as you have completed Steps...

Question 4

For each table, you must identify the primary key and any alternate keys, secondary keys, and ____________________ keys.

Accepted Answer

The answer of For each table, you must identify the...

Question 5

What does it mean when an entity has a minimum cardinality of one?
A) The entity is required in the relationship.
B) The entity is not required in the relationship.
C) The entity should not be in the relationship as an attribute.
D) The entity must be listed with all ones in the data fields.

Accepted Answer

When an entity has a minimum cardinality of one, it means that the entity is required in the relationship. This indicates that every instance of the entity must participate in the relationship. In other words, the entity must have at least one occurrence in the relationship. Therefore, option A is the best choice.

Question 6

What is the term used in an E-R diagram that specifies the maximum number of entities that can participate in a relationship?
A) maximum cardinality
B) maximum entropy
C) highest ratio
D) highest entropy

Accepted Answer

The term used in an E-R diagram that specifies the maximum number of entities that can participate in a relationship is maximum cardinality.

Question 7

On an E-R diagram, what does the number closest to the relationship represent?
A) maximum entropy
B) minimum cardinality
C) midvalue ratio
D) highest entropy

Accepted Answer

The number closest to the relationship on an E-R diagram represents the minimum cardinality, which is the minimum number of instances of one entity that can have a relationship with a certain number of instances of another entity. It can also represent the maximum cardinality, which is the maximum number of instances of one entity that can have a relationship with a certain number of instances of another entity. However, the question only gives one option that includes cardinality, so the best choice is B, which specifically mentions minimum cardinality.

Question 8

On an E-R diagram, ____________________ entities have rounded corners.

Accepted Answer

The answer of On an E-R diagram, ____________________ entities have...

Question 9

A rectangle represents each _____________ in an E-R diagram.

Accepted Answer

The answer of A rectangle represents each _____________ in an...

Question 10

It is through foreign keys that you can create relationships among tables and enforce certain types of ____________________ constraints in a database.

Accepted Answer

The answer of It is through foreign keys that you...

Question 11

If an entity represented in a supertype table is not represented in the subtype table, what is this called in IDEF1X terminology?
A) foreign key
B) incomplete category
C) subtype anomaly
D) supertype discriminator

Accepted Answer

In IDEF1X terminology, an incomplete category occurs when not all entities in a supertype are represented in its subtypes.

Question 12

A subtype ____________________ is the specific attribute that determines the subtype-supertype relationship.

Accepted Answer

The answer of A subtype ____________________ is the specific attribute...

Question 13

When designing a database, you might find it helpful to design a ____________ form to obtain the required information from users.

Accepted Answer

The answer of When designing a database, you might find...

Question 14

Suppose you have the following two tables where EmployeeNum is the primary key in both tables. What can you say about the EmployeeBuilding table??Employee (EmployeeNum, LastName, FirstName)?EmployeeBuilding (EmployeeNum, BuildingName)?FK EmployeeNum -> Employee
A) The EmployeeBuilding table is a subtype of the Employee table.
B) The EmployeeBuilding table is a supertype of the Employee table.
C) The Employee table is a subtype of the EmployeeBuilding table.
D) BuildingName is a subtype discriminator.

Accepted Answer

The EmployeeBuilding table is not a subtype or supertype of the Employee table; instead, it is related to the Employee table through a foreign key (FK) relationship. This means EmployeeBuilding contains additional information (in this case, BuildingName) related to each employee, indicating a kind of extension or detail table rather than a subtype/supertype relationship. The concept of subtype and supertype is related to inheritance and specialization in database design, which is not what is being described here.

Question 15

When are nulls used?
A) when a numeric value is zero
B) when a character value is blank
C) when a string contains a space
D) when a value is inapplicable

Accepted Answer

Null values are used when a value is inapplicable. This means that there is no value or a value cannot be determined or provided for a certain attribute or field. Null values are commonly used in databases to represent missing or unknown data. They are also used in programming to indicate the absence of a value.

Question 16

During the ____________________-level design, designers must consider the characteristics of the particular DBMS that the organization will use.

Accepted Answer

The answer of During the ____________________-level design, designers must consider...

Question 17

What does it mean when an entity has a minimum cardinality of zero?
A) The entity has a mandatory role in the relationship.
B) The entity is not required in the relationship.
C) The entity should not be in the relationship as an attribute.
D) The entity must be listed with all zeros in the data fields.

Accepted Answer

A minimum cardinality of zero for an entity in a relationship means that it is not required to be present in the relationship. The entity may be optional and may or may not participate in the relationship.

Question 18

____________________ key restrictions determine the relationships between tables.

Accepted Answer

The answer of ____________________ key restrictions determine the relationships between...

Question 19

If a many-to-many-to-many relationship is created when it is not appropriate to do so, how can the problem be corrected?
A) by converting to 1NF
B) by converting to 2NF
C) by converting to 3NF
D) by converting to 4NF

Accepted Answer

Converting to 4NF (Fourth Normal Form) addresses issues related to multi-valued dependencies, which are a common problem in many-to-many-to-many relationships. By ensuring that database tables are in 4NF, it ensures that these complex relationships are handled appropriately, eliminating the unnecessary redundancy and potential for inconsistency that can arise from improperly structured many-to-many-to-many relationships.

Question 20

What is an entity that can serve as the relationship between other entities called?
A) composite entity
B) complex entity
C) complicated entity
D) circular entity

Accepted Answer

A composite entity is an entity that is created to serve as the relationship between other entities. It is usually made up of the primary keys of the entities it is relating. Therefore, it links multiple entities and acts as an intermediary between them. The other options, B-D, are not commonly used terms in database design.

Quiz 6: Database Design 2: Design Method

In IDEF1X terminology, what is a subtype called?

Columns that are of interest strictly for the purpose of retrieval are known as ____________________.

As soon as you have completed Steps 1 through 3 for a given user view, you can merge the results into the __________________ design.

For each table, you must identify the primary key and any alternate keys, secondary keys, and ____________________ keys.

What does it mean when an entity has a minimum cardinality of one?

What is the term used in an E-R diagram that specifies the maximum number of entities that can participate in a relationship?

On an E-R diagram, what does the number closest to the relationship represent?

On an E-R diagram, ____________________ entities have rounded corners.

A rectangle represents each _____________ in an E-R diagram.

It is through foreign keys that you can create relationships among tables and enforce certain types of ____________________ constraints in a database.

If an entity represented in a supertype table is not represented in the subtype table, what is this called in IDEF1X terminology?

A subtype ____________________ is the specific attribute that determines the subtype-supertype relationship.

When designing a database, you might find it helpful to design a ____________ form to obtain the required information from users.

Suppose you have the following two tables where EmployeeNum is the primary key in both tables. What can you say about the EmployeeBuilding table??Employee (EmployeeNum, LastName, FirstName) ?EmployeeBuilding (EmployeeNum, BuildingName) ?FK EmployeeNum -> Employee

When are nulls used?

During the ____________________-level design, designers must consider the characteristics of the particular DBMS that the organization will use.

What does it mean when an entity has a minimum cardinality of zero?

____________________ key restrictions determine the relationships between tables.

If a many-to-many-to-many relationship is created when it is not appropriate to do so, how can the problem be corrected?

What is an entity that can serve as the relationship between other entities called?