Question 1

When creating a table in the relational database design from an entity in the extended E-R model,the attributes of the entity become the rows of the table.

Accepted Answer

A) True 
 B)False  False

Question 2

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, StuMajor, StuPhone, AdvisorID) ADVISOR (AdvisorID, AdvName, AdvOffice, AdvPhone) AdvisorID in STUDENT must exist in AdvisorID in ADVISOR.

Question 3

To create a 1:1 relationship between two tables in Microsoft Access,the Indexed property of the foreign key column must be set to ________.

Accepted Answer

Yes (No Duplicates)

Question 4

Explain the representation of ID-dependent weak entities using the relational model.

Accepted Answer

A weak entity is represented in the rela

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

In many-to-many relationships in a relational database design,________.

Accepted Answer

A) the key of the child is placed as a foreign key into the parent 
B) the key of the parent is placed as a foreign key into the child 
C) the keys of both tables are placed in a third table 
D) the keys of both tables are joined into a composite key 
E) C and D 
A) the key of the child is placed as a foreign key into the parent 
B) the key of the parent is placed as a foreign key into the child 
C) the keys of both tables are placed in a third table 
D) the keys of both tables are joined into a composite key 
E) C and D

Question 7

As far as Microsoft Access is concerned,there are no ________.

Accepted Answer

The answer of As far as Microsoft Access is concerned,there...

Question 8

When applied to 1:N relationships,the term "parent" refers to the many side of the relationship since a child may have many parents.

Accepted Answer

A) True 
 B)False

Question 9

In a relational database design,all relationships are expressed by ________.

Accepted Answer

A) creating a primary key 
B) creating a foreign key 
C) creating a supertype 
D) creating a subtype 
E) creating a line between entities 
A) creating a primary key 
B) creating a foreign key 
C) creating a supertype 
D) creating a subtype 
E) creating a line between entities

Question 10

What relationship pattern is illustrated in the following schema? EMPLOYEE EmployeeID,OfficePhone,Manager)
Manager in EMPLOYEE must exist in EmployeeID in EMPLOYEE

Accepted Answer

A) Association relationship 
B) Intersection relationship 
C) Recursive relationship 
D) Strong entity relationship 
E) Supertype/subtype relationship 
A) Association relationship 
B) Intersection relationship 
C) Recursive relationship 
D) Strong entity relationship 
E) Supertype/subtype relationship

Question 11

Which of the following is not true about representing subtypes in a relational database design?

Accepted Answer

A) One table is created for the supertype and one for each subtype. 
B) All of the attributes of the supertype are added to the subtype relations. 
C) The key of the supertype is made the key of the subtypes. 
D) A subtype and its supertype are representations of the same underlying table. 
E) An instance of the supertype may be related to one instance each of several subtypes. 
A) One table is created for the supertype and one for each subtype. 
B) All of the attributes of the supertype are added to the subtype relations. 
C) The key of the supertype is made the key of the subtypes. 
D) A subtype and its supertype are representations of the same underlying table. 
E) An instance of the supertype may be related to one instance each of several subtypes.

Question 12

For a 1:1 relationship,the key of each table should be placed in the other table as the foreign key.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

One-to-one recursive relationships are a

Question 14

To represent a M:N relationship in the relational model,an intersection relation is created to represent the relationship itself.

Accepted Answer

A) True 
 B)False

Question 15

The technique for representing E-R relationships in the relational model is dependent on the minimum cardinality.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

Which of the following is true when representing a 1:1 binary relationship using the relational model?

Accepted Answer

A) The key of the entity with the highest minimum cardinality must be placed in the other entity as a foreign key. 
B) The key of each entity must be placed in the other as a foreign key. 
C) The key of either entity is placed in the other as a foreign key. 
D) The key of the entity with the most attributes must be placed in the other entity as a foreign key. 
E) Both entities must have the same primary key. 
A) The key of the entity with the highest minimum cardinality must be placed in the other entity as a foreign key. 
B) The key of each entity must be placed in the other as a foreign key. 
C) The key of either entity is placed in the other as a foreign key. 
D) The key of the entity with the most attributes must be placed in the other entity as a foreign key. 
E) Both entities must have the same primary key.

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

By default,the identifier of the entity becomes the foreign key of the corresponding table.

Accepted Answer

A) True 
 B)False

When creating a table in the relational database design from an entity in the extended E-R model,the attributes of the entity become the rows of the table.

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

To create a 1:1 relationship between two tables in Microsoft Access,the Indexed property of the foreign key column must be set to ________.

Explain the representation of ID-dependent weak entities using the relational model.

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

In many-to-many relationships in a relational database design,________.

As far as Microsoft Access is concerned,there are no ________.

When applied to 1:N relationships,the term "parent" refers to the many side of the relationship since a child may have many parents.

In a relational database design,all relationships are expressed by ________.

What relationship pattern is illustrated in the following schema? EMPLOYEE EmployeeID,OfficePhone,Manager) Manager in EMPLOYEE must exist in EmployeeID in EMPLOYEE

Which of the following is not true about representing subtypes in a relational database design?

For a 1:1 relationship,the key of each table should be placed in the other table as the foreign key.

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

To represent a M:N relationship in the relational model,an intersection relation is created to represent the relationship itself.

The technique for representing E-R relationships in the relational model is dependent on the minimum cardinality.

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

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

Which of the following is true when representing a 1:1 binary relationship 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?

By default,the identifier of the entity becomes the foreign key of the corresponding table.

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

When creating a table in the relational database design from an entity in the extended E-R model,the attributes of the entity become the rows of the table.

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

To create a 1:1 relationship between two tables in Microsoft Access,the Indexed property of the foreign key column must be set to ________.

Explain the representation of ID-dependent weak entities using the relational model.

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

In many-to-many relationships in a relational database design,________.

As far as Microsoft Access is concerned,there are no ________.

When applied to 1:N relationships,the term "parent" refers to the many side of the relationship since a child may have many parents.

In a relational database design,all relationships are expressed by ________.

What relationship pattern is illustrated in the following schema? EMPLOYEE EmployeeID,OfficePhone,Manager) Manager in EMPLOYEE must exist in EmployeeID in EMPLOYEE

Which of the following is not true about representing subtypes in a relational database design?

For a 1:1 relationship,the key of each table should be placed in the other table as the foreign key.

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

To represent a M:N relationship in the relational model,an intersection relation is created to represent the relationship itself.

The technique for representing E-R relationships in the relational model is dependent on the minimum cardinality.

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

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

Which of the following is true when representing a 1:1 binary relationship 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?

By default,the identifier of the entity becomes the foreign key of the corresponding table.

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