Question 1

A natural key is also called a(n)____ key.​

Accepted Answer

A)  ​surrogate 
B)  ​intelligent 
C)  ​secondary 
D)  ​defining

Question 2

​There are two types of primary keys that you can use in your database design.

Accepted Answer

A) True 
 B)False

Question 3

Convert the following table to first normal form:​ Branch (BranchNum,BranchName,(BookCode,Title,OnHand))

Accepted Answer

A)  ​Branch (BranchNum, BranchName)?Book (BookCode, Title) 
B)  ​Branch (BranchNum, BranchName) 
C)  ​Book (BookCode, Title) 
D)  ​Branch (BranchNum, BranchName, BookCode, Title, OnHand )

Question 4

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 5

A design that supports all user views is called a constructive design.​

Accepted Answer

A) True 
 B)False

Question 6

A column that you create for an entity to serve solely as the primary key and that is visible to users is called a(n)____.​

Accepted Answer

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

Question 7

The use of an "m" and an "n" in an E-R diagram indicates a many-to-many relationship.​

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

The second step in creating a user view is to represent the user view as a collection of tables.​

Accepted Answer

A) True 
 B)False

Question 10

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 11

List the types of information that must be included on a survey form in order for it to be considered valuable to the design process.​

Accepted Answer

The answer of List the types of information that must...

Question 12

A weak entity corresponds to the term ____________________.​

Accepted Answer

The answer of A weak entity corresponds to the term...

Question 13

If each employee works in a single department and each department has only one employee,the relationship between employees and departments is ____.​

Accepted Answer

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

Question 14

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

Accepted Answer

A)  ​maximum 
B)  ​minimum 
C)  ​midvalue 
D)  ​largest

Question 15

In DBDL,you represent a table by listing all columns and then underlining the primary key.​

Accepted Answer

A) True 
 B)False

Question 16

The basic relationships among entities are: one-to-many,many-to-many,and one-to-one.​

Accepted Answer

A) True 
 B)False

Question 17

Describe the different types of primary keys.​

Accepted Answer

The answer of Describe the different types of primary keys.​...

Question 18

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 19

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)  ​data dependence 
C)  ​redundancy 
D)  ​cardinality

Question 20

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

Exam 6: Database Design 2: Design Method

A natural key is also called a(n) ____ key.

There are two types of primary keys that you can use in your database design.

Convert the following table to first normal form: Branch (BranchNum,BranchName,(BookCode,Title,OnHand) )

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

A design that supports all user views is called a constructive design.

A column that you create for an entity to serve solely as the primary key and that is visible to users is called a(n) ____.

The use of an "m" and an "n" in an E-R diagram indicates a many-to-many relationship.

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

The second step in creating a user view is to represent the user view as a collection of tables.

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

List the types of information that must be included on a survey form in order for it to be considered valuable to the design process.

A weak entity corresponds to the term ____________________.

If each employee works in a single department and each department has only one employee,the relationship between employees and departments is ____.

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

In DBDL,you represent a table by listing all columns and then underlining the primary key.

The basic relationships among entities are: one-to-many,many-to-many,and one-to-one.

Describe the different types of primary keys.

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

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

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

Exam 6: Database Design 2: Design Method

A natural key is also called a(n) ____ key.​

​There are two types of primary keys that you can use in your database design.

Convert the following table to first normal form:​ Branch (BranchNum,BranchName,(BookCode,Title,OnHand) )

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

A design that supports all user views is called a constructive design.​

A column that you create for an entity to serve solely as the primary key and that is visible to users is called a(n) ____.​

The use of an "m" and an "n" in an E-R diagram indicates a many-to-many relationship.​

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

The second step in creating a user view is to represent the user view as a collection of tables.​

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

List the types of information that must be included on a survey form in order for it to be considered valuable to the design process.​

A weak entity corresponds to the term ____________________.​

If each employee works in a single department and each department has only one employee,the relationship between employees and departments is ____.​

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

In DBDL,you represent a table by listing all columns and then underlining the primary key.​

The basic relationships among entities are: one-to-many,many-to-many,and one-to-one.​

Describe the different types of primary keys.​

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

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

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

A natural key is also called a(n) ____ key.

There are two types of primary keys that you can use in your database design.

Convert the following table to first normal form: Branch (BranchNum,BranchName,(BookCode,Title,OnHand) )

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

A design that supports all user views is called a constructive design.

A column that you create for an entity to serve solely as the primary key and that is visible to users is called a(n) ____.

The use of an "m" and an "n" in an E-R diagram indicates a many-to-many relationship.

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

The second step in creating a user view is to represent the user view as a collection of tables.

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

List the types of information that must be included on a survey form in order for it to be considered valuable to the design process.

A weak entity corresponds to the term ____________________.

If each employee works in a single department and each department has only one employee,the relationship between employees and departments is ____.

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

In DBDL,you represent a table by listing all columns and then underlining the primary key.

The basic relationships among entities are: one-to-many,many-to-many,and one-to-one.

Describe the different types of primary keys.

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

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

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