Question 1

What kind of attribute would be given for a person who does not have an email address?

Accepted Answer

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

Question 2

What 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)  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 A

Question 3

Which of the following is a possible business rule?

Accepted Answer

A)  A customer can purchase many DVDs 
B)  DVDs can be purchased by many customers 
C)  A DVD title can have many copies 
D)  All of these choices 
A)  A customer can purchase many DVDs 
B)  DVDs can be purchased by many customers 
C)  A DVD title can have many copies 
D)  All of these choices D

Question 4

Which of the following statements is accurate?

Accepted Answer

A)  A correct business rule for one organization may not be correct for another organization. 
B)  Each business rule will have entities and sometimes even attributes. 
C)  A typical business may have hundreds of business rules. 
D)  All of these choices. 
A)  A correct business rule for one organization may not be correct for another organization. 
B)  Each business rule will have entities and sometimes even attributes. 
C)  A typical business may have hundreds of business rules. 
D)  All of these choices.

Question 5

What expresses the specific number of instances in an entity?

Accepted Answer

A)  Cardinality 
B)  Composite entity 
C)  Business rule 
D)  Null-valued attribute 
A)  Cardinality 
B)  Composite entity 
C)  Business rule 
D)  Null-valued attribute

Question 6

What is a collection of related data elements?

Accepted Answer

A)  Field 
B)  Table 
C)  Record 
D)  Key 
A)  Field 
B)  Table 
C)  Record 
D)  Key

Question 7

What kind of attribute can be calculated using the value of another attribute?

Accepted Answer

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

Question 8

What occurs between two entities in which an instance of one entity can be related to many instances of a related entity?

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 9

What kind of attribute is age?

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 10

What is composed of rows and columns that represent an entity?

Accepted Answer

A)  Field 
B)  Table 
C)  Record 
D)  Key 
A)  Field 
B)  Table 
C)  Record 
D)  Key

Question 11

What is a characteristic of a table?

Accepted Answer

A)  Field 
B)  Table 
C)  Record 
D)  Key 
A)  Field 
B)  Table 
C)  Record 
D)  Key

Question 12

What occurs when two entities can be related to each other in many instances?

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 13

What is a technique for document the entities and relationships in a database environment?

Accepted Answer

A)  Entity-relationship diagram 
B)  Data model 
C)  Database 
D)  Relational database model 
A)  Entity-relationship diagram 
B)  Data model 
C)  Database 
D)  Relational database model

Question 14

Date of birth would be a stored attribute.

Accepted Answer

A) True 
 B)False

Question 15

What is a statement that defines an aspect of a business?

Accepted Answer

A)  Attribute 
B)  Entity 
C)  Business relational diagram 
D)  Business rule 
A)  Attribute 
B)  Entity 
C)  Business relational diagram 
D)  Business rule

Question 16

What is a primary 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

Question 17

A primary key is a field that uniquely identifies a given record in a table.

Accepted Answer

A) True 
 B)False

Question 18

A field is composed of rows and columns that represent an entity.

Accepted Answer

A) True 
 B)False

Question 19

What has the potential to contain more than one value for an 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 20

What has only a single value of each attribute of an entity?

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

What kind of attribute would be given for a person who does not have an email address?

What occurs between two entities in which an instance of one entity can be related to only one instance of a related entity?

Which of the following is a possible business rule?

Which of the following statements is accurate?

What expresses the specific number of instances in an entity?

What is a collection of related data elements?

What kind of attribute can be calculated using the value of another attribute?

What occurs between two entities in which an instance of one entity can be related to many instances of a related entity?

What kind of attribute is age?

What is composed of rows and columns that represent an entity?

What is a characteristic of a table?

What occurs when two entities can be related to each other in many instances?

What is a technique for document the entities and relationships in a database environment?

Date of birth would be a stored attribute.

What is a statement that defines an aspect of a business?

What is a primary key?

A primary key is a field that uniquely identifies a given record in a table.

A field is composed of rows and columns that represent an entity.

What has the potential to contain more than one value for an attribute?

What has only a single value of each attribute of an entity?

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 kind of attribute would be given for a person who does not have an email address?

What occurs between two entities in which an instance of one entity can be related to only one instance of a related entity?

Which of the following is a possible business rule?

Which of the following statements is accurate?

What expresses the specific number of instances in an entity?

What is a collection of related data elements?

What kind of attribute can be calculated using the value of another attribute?

What occurs between two entities in which an instance of one entity can be related to many instances of a related entity?

What kind of attribute is age?

What is composed of rows and columns that represent an entity?

What is a characteristic of a table?

What occurs when two entities can be related to each other in many instances?

What is a technique for document the entities and relationships in a database environment?

Date of birth would be a stored attribute.

What is a statement that defines an aspect of a business?

What is a primary key?

A primary key is a field that uniquely identifies a given record in a table.

A field is composed of rows and columns that represent an entity.

What has the potential to contain more than one value for an attribute?

What has only a single value of each attribute of an entity?

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