Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A weak entity is represented in the rela

Question 3

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 4

The key for an intersection table is always the combination of the keys of the parent entities.

Accepted Answer

A) True 
 B)False

Question 5

To create a 1:1 relationship between two tables in Microsoft Access ________.

Accepted Answer

A)  the Indexed property of the foreign key column must be set to No 
B)  the Indexed property of the foreign key column must be set to Yes (Duplicates OK) 
C)  the Indexed property of the foreign key column must be set to Yes (No Duplicates) 
D)  the Data Type of the foreign key column must be set to AutoNumber 
E)  the Smart Tag property of the foreign key column must be set to Foreign Key 
A)  the Indexed property of the foreign key column must be set to No 
B)  the Indexed property of the foreign key column must be set to Yes (Duplicates OK) 
C)  the Indexed property of the foreign key column must be set to Yes (No Duplicates) 
D)  the Data Type of the foreign key column must be set to AutoNumber 
E)  the Smart Tag property of the foreign key column must be set to Foreign Key

Question 6

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

Accepted Answer

A)  1:1 relationships 
B)  1:N relationships 
C)  N:1 relationships 
D)  N:M relationships 
E)  recursive relationships 
A)  1:1 relationships 
B)  1:N relationships 
C)  N:1 relationships 
D)  N:M relationships 
E)  recursive relationships

Question 7

The identifier of the entity becomes the ________ of the corresponding table.

Accepted Answer

A)  primary key 
B)  foreign key 
C)  supertype 
D)  subtype 
E)  either A or B 
A)  primary key 
B)  foreign key 
C)  supertype 
D)  subtype 
E)  either A or B

Question 8

An example of a join in SQL is the situation where two attributes of two separate tables are compared for equality in a WHERE clause.

Accepted Answer

A) True 
 B)False

Question 9

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

The answer of To create a 1:1 relationship between two...

Question 10

Explain the process of representing an entity using the relational model.

Accepted Answer

To represent an entity using the relatio

Question 11

A surrogate key is appropriate when the primary key of a table contains a lengthy text field.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is the correct technique for representing a M:N relationship using the relational model?

Accepted Answer

A)  An intersection relation is created, and the key of either entity is placed as a key in both the intersection relation and in the other relation. 
B)  An intersection relation is created with a surrogate key, which is placed in each of the parent entities. 
C)  An intersection relation is created, and the keys of both parent entities are placed as a composite key in the intersection relation. 
D)  The key from either relation is placed as a foreign key in the other relation. 
E)  None of the above 
A)  An intersection relation is created, and the key of either entity is placed as a key in both the intersection relation and in the other relation. 
B)  An intersection relation is created with a surrogate key, which is placed in each of the parent entities. 
C)  An intersection relation is created, and the keys of both parent entities are placed as a composite key in the intersection relation. 
D)  The key from either relation is placed as a foreign key in the other relation. 
E)  None of the above

Question 16

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

Accepted Answer

A)  1:1 relationship 
B)  1:N relationship 
C)  N:M relationship 
D)  association relationship 
E)  recursive relationship 
A)  1:1 relationship 
B)  1:N relationship 
C)  N:M relationship 
D)  association relationship 
E)  recursive relationship

Question 17

The key of the parent entity becomes part of the key of an ID-dependent entity.

Accepted Answer

A) True 
 B)False

Question 18

What relationship pattern is illustrated in the following schema?
VEHICLE (VehicleID,Cost)
CAR (VehicleID,NumberOfSeats)
TRUCK (VehicleID,CargoCapacity)
VehicleID in CAR must exist in VehicleID in VEHICLE
VehicleID in TRUCK must exist in VehicleID in VEHICLE

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 19

In certain circumstances,there may be a preference as to which table in a 1:1 relationship contains the foreign key.

Accepted Answer

A) True 
 B)False

Question 20

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

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

Explain the representation of ID-dependent weak entities 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?

The key for an intersection table is always the combination of the keys of the parent entities.

To create a 1:1 relationship between two tables in Microsoft Access ________.

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

The identifier of the entity becomes the ________ of the corresponding table.

An example of a join in SQL is the situation where two attributes of two separate tables are compared for equality in a WHERE clause.

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 process of representing an entity using the relational model.

A surrogate key is appropriate when the primary key of a table contains a lengthy text field.

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

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

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

Which of the following is the correct technique for representing a M:N relationship using the relational model?

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

The key of the parent entity becomes part of the key of an ID-dependent entity.

What relationship pattern is illustrated in the following schema? VEHICLE (VehicleID,Cost) CAR (VehicleID,NumberOfSeats) TRUCK (VehicleID,CargoCapacity) VehicleID in CAR must exist in VehicleID in VEHICLE VehicleID in TRUCK must exist in VehicleID in VEHICLE

In certain circumstances,there may be a preference as to which table in a 1:1 relationship contains the foreign key.

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

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

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

Explain the representation of ID-dependent weak entities 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?

The key for an intersection table is always the combination of the keys of the parent entities.

To create a 1:1 relationship between two tables in Microsoft Access ________.

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

The identifier of the entity becomes the ________ of the corresponding table.

An example of a join in SQL is the situation where two attributes of two separate tables are compared for equality in a WHERE clause.

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 process of representing an entity using the relational model.

A surrogate key is appropriate when the primary key of a table contains a lengthy text field.

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

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

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

Which of the following is the correct technique for representing a M:N relationship using the relational model?

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

The key of the parent entity becomes part of the key of an ID-dependent entity.

What relationship pattern is illustrated in the following schema? VEHICLE (VehicleID,Cost) CAR (VehicleID,NumberOfSeats) TRUCK (VehicleID,CargoCapacity) VehicleID in CAR must exist in VehicleID in VEHICLE VehicleID in TRUCK must exist in VehicleID in VEHICLE

In certain circumstances,there may be a preference as to which table in a 1:1 relationship contains the foreign key.

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

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