Question 1

A(n) ____________________ is essentially both an entity and a relationship and is represented in an E-R diagram by a diamond within a rectangle.

Accepted Answer

composite entity

Question 2

What is a column that you create for an entity to serve solely as the primary key and that is visible to users?

Accepted Answer

A)  synthetic key 
B)  weak entity 
C)  artificial key 
D)  natural key 
A)  synthetic key 
B)  weak entity 
C)  artificial key 
D)  natural key C

Question 3

____________________ refers to the number of items that must be included in a relationship.

Accepted Answer

Cardinality

Question 4

Convert the following table to first normal form:?Branch (BranchNum, BranchName, (BookCode, Title, OnHand) ) where BranchNum is the primary key

Accepted Answer

A)  Branch (BranchNum, BranchName) where BranchNum is the primary key?Book (BookCode, Title) where BookCode is the primary key 
B)  Branch (BranchNum, BranchName) where BranchNum is the primary key 
C)  Book (BookCode, Title) where BookCode is the primary key 
D)  Branch (BranchNum, BranchName, BookCode, Title, OnHand ) where BranchNum and BookCode make the primary key 
A)  Branch (BranchNum, BranchName) where BranchNum is the primary key?Book (BookCode, Title) where BookCode is the primary key 
B)  Branch (BranchNum, BranchName) where BranchNum is the primary key 
C)  Book (BookCode, Title) where BookCode is the primary key 
D)  Branch (BranchNum, BranchName, BookCode, Title, OnHand ) where BranchNum and BookCode make the primary key

Question 5

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

Accepted Answer

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. 
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.

Question 6

The crucial issue in making the determination between a single many-to-many-to-many relationship and two (or three) many-to-many relationships is the ____.

Accepted Answer

A)  independence 
B)  primary key 
C)  redundancy 
D)  primary index 
A)  independence 
B)  primary key 
C)  redundancy 
D)  primary index

Question 7

When implementing the physical-level design, for secondary keys, you must ensure that it is possible to retrieve data rapidly based on a value of which key?

Accepted Answer

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

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

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

Accepted Answer

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. 
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.

Question 10

Consider the following two tables where EmployeeNum is primary key in both tables. What is the result of combining the two tables??Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum)?Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode)

Accepted Answer

A)  Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, (Street, City, PostalCode) ) 
B)  Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, Street, City, State, PostalCode) 
C)  Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode, WageRate, SocSecNum) 
D)  Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, EmployeeNum, LastName, FirstName, Street, City, State, PostalCode ) 
A)  Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, (Street, City, PostalCode) ) 
B)  Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, Street, City, State, PostalCode) 
C)  Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode, WageRate, SocSecNum) 
D)  Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, EmployeeNum, LastName, FirstName, Street, City, State, PostalCode )

Question 11

A foreign key is a column or collection of columns in one table that is required to match the value of the primary key for some row in another table, or be null.

Accepted Answer

A) True 
 B)False

Question 12

Which type of key is usually an automatic numbering data type, such as the Access AutoNumber data type?

Accepted Answer

A)  surrogate 
B)  artificial 
C)  natural 
D)  logical 
A)  surrogate 
B)  artificial 
C)  natural 
D)  logical

Question 13

When are nulls used?

Accepted Answer

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 
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

Question 14

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 15

Which of the following is a set of requirements that is necessary to support the operations of a particular database user?

Accepted Answer

A)  user view 
B)  user table 
C)  user attribute 
D)  user field 
A)  user view 
B)  user table 
C)  user attribute 
D)  user field

Question 16

When a DBMS cannot enforce data and access restrictions, how should they be enforced?

Accepted Answer

A)  by users when they are entering data using the DBMS 
B)  by peripheral programs written to access the database 
C)  by the operating system used to run the DBMS 
D)  by technicians who monitor database usage 
A)  by users when they are entering data using the DBMS 
B)  by peripheral programs written to access the database 
C)  by the operating system used to run the DBMS 
D)  by technicians who monitor database usage

Question 17

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 18

What is the correct order of steps in the information-level design method??1. Normalize the tables.?2. Represent the user view as a collection of tables.?3. Merge the result into the cumulative design.?4. Represent all keys.

Accepted Answer

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

Question 19

If no unique identifier is available for an entity, you can go without one.

Accepted Answer

A) True 
 B)False

Question 20

The first substep in representing the user view as a collection of tables is to determine entities and create a table for each.

Accepted Answer

A) True 
 B)False

A(n) ____________________ is essentially both an entity and a relationship and is represented in an E-R diagram by a diamond within a rectangle.

What is a column that you create for an entity to serve solely as the primary key and that is visible to users?

____________________ refers to the number of items that must be included in a relationship.

Convert the following table to first normal form:?Branch (BranchNum, BranchName, (BookCode, Title, OnHand) ) where BranchNum is the primary key

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

The crucial issue in making the determination between a single many-to-many-to-many relationship and two (or three) many-to-many relationships is the ____.

When implementing the physical-level design, for secondary keys, you must ensure that it is possible to retrieve data rapidly based on a value of which key?

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

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

Consider the following two tables where EmployeeNum is primary key in both tables. What is the result of combining the two tables??Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum)?Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode)

A foreign key is a column or collection of columns in one table that is required to match the value of the primary key for some row in another table, or be null.

Which type of key is usually an automatic numbering data type, such as the Access AutoNumber data type?

When are nulls used?

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

Which of the following is a set of requirements that is necessary to support the operations of a particular database user?

When a DBMS cannot enforce data and access restrictions, how should they be enforced?

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

What is the correct order of steps in the information-level design method??1. Normalize the tables.?2. Represent the user view as a collection of tables.?3. Merge the result into the cumulative design.?4. Represent all keys.

If no unique identifier is available for an entity, you can go without one.

The first substep in representing the user view as a collection of tables is to determine entities and create a table for each.

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 2: SQL

The Relational Model 3: Advanced Topics

Database Design 1: Normalization

Dbms Functions

Database Administration

Database Management Approaches

Filters

Exam 6: Database Design 2: Design Method

A(n) ____________________ is essentially both an entity and a relationship and is represented in an E-R diagram by a diamond within a rectangle.

What is a column that you create for an entity to serve solely as the primary key and that is visible to users?

____________________ refers to the number of items that must be included in a relationship.

Convert the following table to first normal form:?Branch (BranchNum, BranchName, (BookCode, Title, OnHand) ) where BranchNum is the primary key

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

The crucial issue in making the determination between a single many-to-many-to-many relationship and two (or three) many-to-many relationships is the ____.

When implementing the physical-level design, for secondary keys, you must ensure that it is possible to retrieve data rapidly based on a value of which key?

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

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

Consider the following two tables where EmployeeNum is primary key in both tables. What is the result of combining the two tables??Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum)?Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode)

A foreign key is a column or collection of columns in one table that is required to match the value of the primary key for some row in another table, or be null.

Which type of key is usually an automatic numbering data type, such as the Access AutoNumber data type?

When are nulls used?

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

Which of the following is a set of requirements that is necessary to support the operations of a particular database user?

When a DBMS cannot enforce data and access restrictions, how should they be enforced?

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

What is the correct order of steps in the information-level design method??1. Normalize the tables.?2. Represent the user view as a collection of tables.?3. Merge the result into the cumulative design.?4. Represent all keys.

If no unique identifier is available for an entity, you can go without one.

The first substep in representing the user view as a collection of tables is to determine entities and create a table for each.

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 2: SQL

The Relational Model 3: Advanced Topics

Database Design 1: Normalization

Dbms Functions

Database Administration

Database Management Approaches

Filters