Question 1

What exists to represent the relationship between two other entities?

Accepted Answer

A)  One-to-one relationship 
B)  One-to-many relationship 
C)  Many-to-many relationship 
D)  Composite entity 
A)  One-to-one relationship 
B)  One-to-many relationship 
C)  Many-to-many relationship 
D)  Composite entity

Question 2

What kind of attribute is date of birth?

Accepted Answer

A)  Null-valued attribute 
B)  Multi-valued attribute 
C)  Derived attribute 
D)  Stored attribute 
A)  Null-valued attribute 
B)  Multi-valued attribute 
C)  Derived attribute 
D)  Stored attribute

Question 3

Which of the following is a type of attribute?

Accepted Answer

A)  Single-valued attribute 
B)  Multi-valued attribute 
C)  Null-valued attribute 
D)  All of these choices 
A)  Single-valued attribute 
B)  Multi-valued attribute 
C)  Null-valued attribute 
D)  All of these choices

Question 4

A foreign key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Accepted Answer

A) True 
 B)False

Question 5

What kind of attribute is assigned to an attribute when no other value applies or when a value is unknown?

Accepted Answer

A)  Single-valued attribute 
B)  Multi-valued attribute 
C)  Derived attribute 
D)  Null-valued attribute 
A)  Single-valued attribute 
B)  Multi-valued attribute 
C)  Derived attribute 
D)  Null-valued attribute

Question 6

A one-to-many relationship occurs between two entities in which an instance of one entity can be related to only one instance of a related entity.

Accepted Answer

A) True 
 B)False

Question 7

What is a foreign key?

Accepted Answer

A)  A field that uniquely identifies a given record in a table 
B)  A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables 
C)  A table that uniquely identifies a given record in a field 
D)  A foreign key of one table that appears as an entity in another table and acts to provide a logical relationship between the two records 
A)  A field that uniquely identifies a given record in a table 
B)  A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables 
C)  A table that uniquely identifies a given record in a field 
D)  A foreign key of one table that appears as an entity in another table and acts to provide a logical relationship between the two records

What exists to represent the relationship between two other entities?

What kind of attribute is date of birth?

Which of the following is a type of attribute?

A foreign key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

What kind of attribute is assigned to an attribute when no other value applies or when a value is unknown?

A one-to-many relationship occurs between two entities in which an instance of one entity can be related to only one instance of a related entity.

What is a foreign key?

Management Information Systems: Business Driven MIS

Decisions Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics Information Security: MIS Business Concerns

Infrastructures: Sustainable Technologies

Data: Business Intelligence

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Understanding Computer Hardware and Software: From CPUs to Operating Systems

Understanding Telecommunication Systems and Network Topologies

Filters

Exam 12: Database Design and Entity Relationships

What exists to represent the relationship between two other entities?

What kind of attribute is date of birth?

Which of the following is a type of attribute?

A foreign key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

What kind of attribute is assigned to an attribute when no other value applies or when a value is unknown?

A one-to-many relationship occurs between two entities in which an instance of one entity can be related to only one instance of a related entity.

What is a foreign key?

Management Information Systems: Business Driven MIS

Decisions Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics Information Security: MIS Business Concerns

Infrastructures: Sustainable Technologies

Data: Business Intelligence

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Understanding Computer Hardware and Software: From CPUs to Operating Systems

Understanding Telecommunication Systems and Network Topologies

Filters