Question 1

The first step of database design is to define a table for each ________.

Accepted Answer

The answer of The first step of database design is...

Question 2

As far as Microsoft Access is concerned,there are no 1:N relationships.

Accepted Answer

A) True 
 B)False

Question 3

The ideal primary key is short,numeric,and fixed.

Accepted Answer

A) True 
 B)False

Question 4

Recursive relationships can be represented in the relational model using the same techniques that are used for binary relationships.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is not true about surrogate keys?

Accepted Answer

A) They are identifiers that are supplied by the system,not the users. 
B) They have no meaning to the users. 
C) They are nonunique within a table. 
D) They can be problematic when combining databases. 
E) The DBMS will not allow their values to be changed. 
A) They are identifiers that are supplied by the system,not the users. 
B) They have no meaning to the users. 
C) They are nonunique within a table. 
D) They can be problematic when combining databases. 
E) The DBMS will not allow their values to be changed.

Question 6

To represent a 1:N relationship in the relational model,the key of the entity on the one side of the relationship is placed as a foreign key in the entity on the many side of the relationship.

Accepted Answer

A) True 
 B)False

Question 7

By default,when Microsoft Access creates a relationship between two tables it creates a(n)________ relationship.

Accepted Answer

The answer of By default,when Microsoft Access creates a relationship...

Question 8

The first step in representing entities using the relational model is to determine which identifier will be used as the key.

Accepted Answer

A) True 
 B)False

Question 9

The ideal primary key is ________.

Accepted Answer

A) short 
B) numeric 
C) fixed 
D) A and B 
E) A,B,and C 
A) short 
B) numeric 
C) fixed 
D) A and B 
E) A,B,and C

Question 10

Explain the representation of a one-to-many strong entity relationship in a relational database design.

Accepted Answer

One-to-many relationships are represente

Question 11

Given the tables 
TABLE_A (Attribute1, Attribute2, Attribute3) 
TABLE_B (Attribute4, Attribute5, Attribute6) 
As shown in the figure below,which of the following would display the correct placement of foreign keys in the relational model?

Accepted Answer

A) 
TABLE_A (Attribute1, Attribute2, Attribute3)
TABLE B (Attribute4, Attribute5, Attribute6, Attributel) 
B) 
TABLE_A (Attribute1, Attribute2, Attribute3, Attribute4, Attribute5) 
TABLE_B (Attribute4, Attribute5, Attribute6) 
C) 
TABLE_A (Attribute1, Attribute2, Attribute3, Attribute4)
TABLE_B (Attribute4 , Attribute5, Attribute6, Attributel) 
D) 
TABLE_A (Attribute1, Attribute2, Attribute3)
TABLE B (Attribute4, Attribute5, Attribute6) 
E) 
TABLE_A (Attribute1, Attribute2, Attribute3, Attribute6)
TABLE_B (Attribute4, Attribute5, Attribute6) 
A) 
TABLE_A (Attribute1, Attribute2, Attribute3)
TABLE B (Attribute4, Attribute5, Attribute6, Attributel) 
B) 
TABLE_A (Attribute1, Attribute2, Attribute3, Attribute4, Attribute5) 
TABLE_B (Attribute4, Attribute5, Attribute6) 
C) 
TABLE_A (Attribute1, Attribute2, Attribute3, Attribute4)
TABLE_B (Attribute4 , Attribute5, Attribute6, Attributel) 
D) 
TABLE_A (Attribute1, Attribute2, Attribute3)
TABLE B (Attribute4, Attribute5, Attribute6) 
E) 
TABLE_A (Attribute1, Attribute2, Attribute3, Attribute6)
TABLE_B (Attribute4, Attribute5, Attribute6)

Question 12

Which of the following would be a reason to denormalize a relation?

Accepted Answer

A) Relax security 
B) Lack of design time 
C) End user preference 
D) Improve performance 
E) None of the above 
A) Relax security 
B) Lack of design time 
C) End user preference 
D) Improve performance 
E) None of the above

Question 13

To represent a 1:N relationship in the relational model,the key of either entity may be placed as a foreign key in the other entity.

Accepted Answer

A) True 
 B)False

Question 14

Relationships that are 1:1 do not require referential integrity constraints.

Accepted Answer

A) True 
 B)False

Question 15

Microsoft Access uses the same pure N:M relationships that occur in data modeling.

Accepted Answer

A) True 
 B)False

Question 16

Relations should always be normalized to the highest degree possible.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is not true of recursive relationships?

Accepted Answer

A) When the recursive relationship is M:N,an intersection table is created. 
B) The rows of a single table can play two different roles. 
C) The techniques for representing the tables are the same as for non-recursive relationships except the rows are in the same table. 
D) Recursive relationships can be 1:1,1:N,or M:N relationships. 
E) Even when the relationship is 1:N,a new table must be defined to represent the relationship. 
A) When the recursive relationship is M:N,an intersection table is created. 
B) The rows of a single table can play two different roles. 
C) The techniques for representing the tables are the same as for non-recursive relationships except the rows are in the same table. 
D) Recursive relationships can be 1:1,1:N,or M:N relationships. 
E) Even when the relationship is 1:N,a new table must be defined to represent the relationship.

Question 18

Once a table has been defined,it should be examined according to ________ criteria.

Accepted Answer

The answer of Once a table has been defined,it should...

Question 19

Given the tables
PRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
As shown in the figure below,which of the following would represent the correct placement of foreign keys?

Accepted Answer

A) PRODUCT (ProductID,Description,Cost) SUPPLIER  (SupplierID,ContactName,PhoneNumber) 
B) PRODUCT (ProductID,Description,Cost) SUPPLIER  (SupplierID,ContactName,PhoneNumber,ProductI
D)  
C) PRODUCT (ProductID,Description,Cost,SupplierI
D)  SUPPLIER  (SupplierID,ContactName,PhoneNumber,ProductI
D)  
D) PRODUCT (ProductID,Description,Cost,ContactName) SUPPLIER  (SupplierID,ContactName,PhoneNumber) 
E) PRODUCT (ProductID,Description,Cost,SupplierI
D)  SUPPLIER  (SupplierID,ContactName,PhoneNumber) 
A) PRODUCT (ProductID,Description,Cost) SUPPLIER  (SupplierID,ContactName,PhoneNumber) 
B) PRODUCT (ProductID,Description,Cost) SUPPLIER  (SupplierID,ContactName,PhoneNumber,ProductI
D)  
C) PRODUCT (ProductID,Description,Cost,SupplierI
D)  SUPPLIER  (SupplierID,ContactName,PhoneNumber,ProductI
D)  
D) PRODUCT (ProductID,Description,Cost,ContactName) SUPPLIER  (SupplierID,ContactName,PhoneNumber) 
E) PRODUCT (ProductID,Description,Cost,SupplierI
D)  SUPPLIER  (SupplierID,ContactName,PhoneNumber)

Question 20

How are 1:1,1:N and N:M relationships handled in Microsoft Access?

Accepted Answer

By default,when Microsoft Access creates

The first step of database design is to define a table for each ________.

As far as Microsoft Access is concerned,there are no 1:N relationships.

The ideal primary key is short,numeric,and fixed.

Recursive relationships can be represented in the relational model using the same techniques that are used for binary relationships.

Which of the following is not true about surrogate keys?

To represent a 1:N relationship in the relational model,the key of the entity on the one side of the relationship is placed as a foreign key in the entity on the many side of the relationship.

By default,when Microsoft Access creates a relationship between two tables it creates a(n)________ relationship.

The first step in representing entities using the relational model is to determine which identifier will be used as the key.

The ideal primary key is ________.

Explain the representation of a one-to-many strong entity relationship in a relational database design.

Given the tables TABLE_A (Attribute1, Attribute2, Attribute3) TABLE_B (Attribute4, Attribute5, Attribute6) As shown in the figure below,which of the following would display the correct placement of foreign keys in the relational model?

Which of the following would be a reason to denormalize a relation?

To represent a 1:N relationship in the relational model,the key of either entity may be placed as a foreign key in the other entity.

Relationships that are 1:1 do not require referential integrity constraints.

Microsoft Access uses the same pure N:M relationships that occur in data modeling.

Relations should always be normalized to the highest degree possible.

Which of the following is not true of recursive relationships?

Once a table has been defined,it should be examined according to ________ criteria.

Given the tables PRODUCT (ProductID, Description, Cost) SUPPLIER (SupplierID, ContactName, PhoneNumber) As shown in the figure below,which of the following would represent the correct placement of foreign keys?

How are 1:1,1:N and N:M relationships handled in Microsoft Access?

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Administration

Database Processing Applications

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters

Exam 5: Database Design

The first step of database design is to define a table for each ________.

As far as Microsoft Access is concerned,there are no 1:N relationships.

The ideal primary key is short,numeric,and fixed.

Recursive relationships can be represented in the relational model using the same techniques that are used for binary relationships.

Which of the following is not true about surrogate keys?

To represent a 1:N relationship in the relational model,the key of the entity on the one side of the relationship is placed as a foreign key in the entity on the many side of the relationship.

By default,when Microsoft Access creates a relationship between two tables it creates a(n)________ relationship.

The first step in representing entities using the relational model is to determine which identifier will be used as the key.

The ideal primary key is ________.

Explain the representation of a one-to-many strong entity relationship in a relational database design.

Given the tables TABLE_A (Attribute1, Attribute2, Attribute3) TABLE_B (Attribute4, Attribute5, Attribute6) As shown in the figure below,which of the following would display the correct placement of foreign keys in the relational model?

Which of the following would be a reason to denormalize a relation?

To represent a 1:N relationship in the relational model,the key of either entity may be placed as a foreign key in the other entity.

Relationships that are 1:1 do not require referential integrity constraints.

Microsoft Access uses the same pure N:M relationships that occur in data modeling.

Relations should always be normalized to the highest degree possible.

Which of the following is not true of recursive relationships?

Once a table has been defined,it should be examined according to ________ criteria.

Given the tables PRODUCT (ProductID, Description, Cost) SUPPLIER (SupplierID, ContactName, PhoneNumber) As shown in the figure below,which of the following would represent the correct placement of foreign keys?

How are 1:1,1:N and N:M relationships handled in Microsoft Access?

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Administration

Database Processing Applications

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters