Question 1

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

Accepted Answer

By default,when Microsoft Access creates

Question 2

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 3

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 4

Relations should always be normalized to the highest degree possible.

Accepted Answer

A) True 
 B)False

Question 5

From a pragmatic standpoint,the only important rule of normalization is that the determinant of every functional dependency must be a candidate key.

Accepted Answer

A) True 
 B)False

Question 6

In relational database design,ID-dependent entities are used to ________.

Accepted Answer

A)  represent 1:1 relationships 
B)  represent 1:N relationships 
C)  represent N:M relationships 
D)  handle recursive relationships 
E)  eliminate the need for weak entities being converted to tables 
A)  represent 1:1 relationships 
B)  represent 1:N relationships 
C)  represent N:M relationships 
D)  handle recursive relationships 
E)  eliminate the need for weak entities being converted to tables

Question 7

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 8

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 9

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 10

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, Attribute1) 
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, Attribute1) 
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, Attribute1) 
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, Attribute1) 
D)  TABLE _A (Attribute1, Attribute2, Attribute3) TABLE _B (Attribute4, Attribute5, Attribute6) 
E)  TABLE _A (Attribute1, Attribute2, Attribute3, Attribute6) TABLE _B (Attribute4, Attribute5, Attribute6)

Question 11

How are one-to-one recursive relationships addressed using the relational model?

Accepted Answer

One-to-one recursive relationships are a

Question 12

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, SupplierI
D)  SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductI
D)  
C)  PRODUCT (ProductID, Description, Cost) SUPPLIER (SupplierID, ContactName, PhoneNumber)
PRODUCT_SUPPLIER (ProductID, SupplierID, PhoneNumber) 
D)  PRODUCT (ProductID, Description, Cost, SupplierI
D)  SUPPLIER (SupplierID, ContactName, PhoneNumber) 
E)  PRODUCT (ProductID, Description, Cost) SUPPLIER (SupplierID, ContactName, PhoneNumber)
PRODUCT_SUPPLIER (ProductID, SupplierI
D)  
A)  PRODUCT (ProductID, Description, Cost) SUPPLIER (SupplierID, ContactName, PhoneNumber) 
B)  PRODUCT (ProductID, Description, Cost, SupplierI
D)  SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductI
D)  
C)  PRODUCT (ProductID, Description, Cost) SUPPLIER (SupplierID, ContactName, PhoneNumber)
PRODUCT_SUPPLIER (ProductID, SupplierID, PhoneNumber) 
D)  PRODUCT (ProductID, Description, Cost, SupplierI
D)  SUPPLIER (SupplierID, ContactName, PhoneNumber) 
E)  PRODUCT (ProductID, Description, Cost) SUPPLIER (SupplierID, ContactName, PhoneNumber)
PRODUCT_SUPPLIER (ProductID, SupplierI
D)

Question 13

Write the schema to represent the entities below,including tables,the proper placement of the foreign key,and referential integrity constraint.

Accepted Answer

STUDENT (StudentID,StuName,Stu

Question 14

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

Accepted Answer

Many-to-many relationships cannot be dir

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

After a 1:1 relationship has been created between two tables in Microsoft Access,the Relationship Type of One-To-One appears in the ________.

Accepted Answer

Edit Relat

Question 17

One of the important properties of an attribute is whether or not it is required.

Accepted Answer

A) True 
 B)False

Question 18

By default,Microsoft Access creates 1:1 relationships between tables.

Accepted Answer

A) True 
 B)False

Question 19

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 20

What is denormalization and why can it be desirable?

Accepted Answer

Denormalization is the process of consol

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

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

Which of the following is not true of recursive relationships?

Relations should always be normalized to the highest degree possible.

From a pragmatic standpoint,the only important rule of normalization is that the determinant of every functional dependency must be a candidate key.

In relational database design,ID-dependent entities are used to ________.

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

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.

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?

How are one-to-one recursive relationships addressed using the relational model?

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?

Write the schema to represent the entities below,including tables,the proper placement of the foreign key,and referential integrity constraint.

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

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

After a 1:1 relationship has been created between two tables in Microsoft Access,the Relationship Type of One-To-One appears in the ________.

One of the important properties of an attribute is whether or not it is required.

By default,Microsoft Access creates 1:1 relationships between tables.

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

What is denormalization and why can it be desirable?

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters

Exam 5: Database Design

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

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

Which of the following is not true of recursive relationships?

Relations should always be normalized to the highest degree possible.

From a pragmatic standpoint,the only important rule of normalization is that the determinant of every functional dependency must be a candidate key.

In relational database design,ID-dependent entities are used to ________.

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

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.

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?

How are one-to-one recursive relationships addressed using the relational model?

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?

Write the schema to represent the entities below,including tables,the proper placement of the foreign key,and referential integrity constraint.

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

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

After a 1:1 relationship has been created between two tables in Microsoft Access,the Relationship Type of One-To-One appears in the ________.

One of the important properties of an attribute is whether or not it is required.

By default,Microsoft Access creates 1:1 relationships between tables.

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

What is denormalization and why can it be desirable?

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters