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

The answer of A(n) ____________________ is essentially both an entity...

Question 2

You can recognize entity subtypes by the fact the primary key is also a(n) ____________________.

Accepted Answer

The answer of You can recognize entity subtypes by the...

Question 3

If you combine the two tables shown above,the result would be ____.

Accepted Answer

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

Question 4

When the existence of one entity depends on the existence of another related entity,there is a(n) ____________________.

Accepted Answer

existence

Question 5

When designing a database,you might find it helpful to design a(n) ____ to obtain the required information from users.

Accepted Answer

A) E-R diagram 
B) IDEF1X diagram 
C) report 
D) survey form 
A) E-R diagram 
B) IDEF1X diagram 
C) report 
D) survey form

Question 6

The basic relationships are one-to-many,many-to-many,and one-to-one. How do you create each type of relationship in the information-level design?

Accepted Answer

To create a one-to-many relationship,inc

Question 7

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

Question 8

Foreign keys allow you to create relationships among tables and enforce certain types of ____________________ constraints in a database.

Accepted Answer

The answer of Foreign keys allow you to create relationships...

Question 9

After the information-level design is completed,the ____ is the next step.

Accepted Answer

A) physical-level design 
B) modality-level design 
C) DBMS-level design 
D) table-level design 
A) physical-level design 
B) modality-level design 
C) DBMS-level design 
D) table-level design

Question 10

The following is an example of DBDL documentation for an Employee table ____.

Accepted Answer

A) Employee (EmployeeNum ,LastName,FirstName,Street,City,State, Zip) 
B) Employee (EmployeeNum ,LastName,FirstName,Street,City,State,Zip). 
C) Employee (EmployeeNum ,LastName,FirstName,Street,City,State,Zip,(WageRate,SocSecNum,DepartmentNum) ., 
D) Employee (EmployeeNum ,LastName,FirstName,Street,City,State,Zip,WageRate,SocSecNum,DepartmentNum)
AK SocSecNum
SK LastName
FK DepartmentNum   Department 
A) Employee (EmployeeNum ,LastName,FirstName,Street,City,State, Zip) 
B) Employee (EmployeeNum ,LastName,FirstName,Street,City,State,Zip). 
C) Employee (EmployeeNum ,LastName,FirstName,Street,City,State,Zip,(WageRate,SocSecNum,DepartmentNum) ., 
D) Employee (EmployeeNum ,LastName,FirstName,Street,City,State,Zip,WageRate,SocSecNum,DepartmentNum)
AK SocSecNum
SK LastName
FK DepartmentNum   Department

Question 11

The ____________________ design method begins with a general database design that models the overall enterprise and repeatedly refines the model to achieve a design that supports all necessary applications.

Accepted Answer

The answer of The ____________________ design method begins with a...

Question 12

When you use an E-R diagram to represent a database,it visually illustrates all the information listed in the DBDL.

Accepted Answer

A) True 
 B)False

Question 13

On an E-R diagram,the number closest to the rectangle represents ____ cardinality.

Accepted Answer

A) maximum 
B) minimum 
C) midvalue 
D) smallest 
A) maximum 
B) minimum 
C) midvalue 
D) smallest

Question 14

In IEDF1X,complete categories are represented by ____ horizontal line(s) below the category symbol.

Accepted Answer

A) one 
B) two 
C) three 
D) four 
A) one 
B) two 
C) three 
D) four

Question 15

A relationship that is not necessary for identification is called a(n) ____________________ relationship.

Accepted Answer

The answer of A relationship that is not necessary for...

Question 16

The type of information collected on the survey form that describes reports that must be produced is ____.

Accepted Answer

A) attribute information 
B) processing information 
C) relationship information 
D) entity information 
A) attribute information 
B) processing information 
C) relationship information 
D) entity information

Question 17

When implementing the physical-level design,you must ensure that it is possible to retrieve data rapidly on the basis of a value of any ____ keys.

Accepted Answer

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

Question 18

An entity that depends on another entity for its own existence is called a weak entity.

Accepted Answer

A) True 
 B)False

Question 19

You create a many-to-many relationship by creating a new table whose primary key is the combination of the primary keys of the original tables.

Accepted Answer

A) True 
 B)False

Question 20

Entity integrity is the property that states that a secondary key in one table is required to match the value of the primary key for some row in another table or is required to be null.

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.

You can recognize entity subtypes by the fact the primary key is also a(n) ____________________.

If you combine the two tables shown above,the result would be ____.

When the existence of one entity depends on the existence of another related entity,there is a(n) ____________________.

When designing a database,you might find it helpful to design a(n) ____ to obtain the required information from users.

The basic relationships are one-to-many,many-to-many,and one-to-one. How do you create each type of relationship in the information-level design?

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

Foreign keys allow you to create relationships among tables and enforce certain types of ____________________ constraints in a database.

After the information-level design is completed,the ____ is the next step.

The following is an example of DBDL documentation for an Employee table ____.

The ____________________ design method begins with a general database design that models the overall enterprise and repeatedly refines the model to achieve a design that supports all necessary applications.

When you use an E-R diagram to represent a database,it visually illustrates all the information listed in the DBDL.

On an E-R diagram,the number closest to the rectangle represents ____ cardinality.

In IEDF1X,complete categories are represented by ____ horizontal line(s) below the category symbol.

A relationship that is not necessary for identification is called a(n) ____________________ relationship.

The type of information collected on the survey form that describes reports that must be produced is ____.

When implementing the physical-level design,you must ensure that it is possible to retrieve data rapidly on the basis of a value of any ____ keys.

An entity that depends on another entity for its own existence is called a weak entity.

You create a many-to-many relationship by creating a new table whose primary key is the combination of the primary keys of the original tables.

Entity integrity is the property that states that a secondary key in one table is required to match the value of the primary key for some row in another table or is required to be null.

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.

You can recognize entity subtypes by the fact the primary key is also a(n) ____________________.

If you combine the two tables shown above,the result would be ____.

When the existence of one entity depends on the existence of another related entity,there is a(n) ____________________.

When designing a database,you might find it helpful to design a(n) ____ to obtain the required information from users.

The basic relationships are one-to-many,many-to-many,and one-to-one. How do you create each type of relationship in the information-level design?

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

Foreign keys allow you to create relationships among tables and enforce certain types of ____________________ constraints in a database.

After the information-level design is completed,the ____ is the next step.

The following is an example of DBDL documentation for an Employee table ____.

The ____________________ design method begins with a general database design that models the overall enterprise and repeatedly refines the model to achieve a design that supports all necessary applications.

When you use an E-R diagram to represent a database,it visually illustrates all the information listed in the DBDL.

On an E-R diagram,the number closest to the rectangle represents ____ cardinality.

In IEDF1X,complete categories are represented by ____ horizontal line(s) below the category symbol.

A relationship that is not necessary for identification is called a(n) ____________________ relationship.

The type of information collected on the survey form that describes reports that must be produced is ____.

When implementing the physical-level design,you must ensure that it is possible to retrieve data rapidly on the basis of a value of any ____ keys.

An entity that depends on another entity for its own existence is called a weak entity.

You create a many-to-many relationship by creating a new table whose primary key is the combination of the primary keys of the original tables.

Entity integrity is the property that states that a secondary key in one table is required to match the value of the primary key for some row in another table or is required to be null.

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