Filters
Question type
Study Flashcards

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


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

E) A) and C)
F) All of the above

Correct Answer

verifed

verified

Which of the following is a type of attribute?


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

E) All of the above
F) B) and C)

Correct Answer

verifed

verified

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


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

E) C) and D)
F) A) and C)

Correct Answer

verifed

verified

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


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

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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


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

E) B) and C)
F) A) and C)

Correct Answer

verifed

verified

What is a collection of related data elements?


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

E) A) and D)
F) None of the above

Correct Answer

verifed

verified

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.

A) True
B) False

Correct Answer

verifed

verified

What kind of attribute would be age?


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

E) A) and D)
F) All of the above

Correct Answer

verifed

verified

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


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

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

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


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

E) A) and C)
F) All of the above

Correct Answer

verifed

verified

B

What is a foreign key?


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

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

What is a characteristic of a table?


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

E) A) and D)
F) A) and C)

Correct Answer

verifed

verified

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.

A) True
B) False

Correct Answer

verifed

verified

What is a primary key?


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

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

____________ expresses the specific number of instances in an entity.

Correct Answer

verifed

verified

Cardinality

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

A) True
B) False

Correct Answer

verifed

verified

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


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

E) A) and B)
F) All of the above

Correct Answer

verifed

verified

C

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


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

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

What expresses the specific number of instances in an entity?


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

E) C) and D)
F) A) and B)

Correct Answer

verifed

verified

Showing 1 - 20 of 32

Related Exams

Exam 1

Management Information Systems: Business Driven MIS

209 Questions

Exam 2

Decision and Processes: Value Driven Business

243 Questions

Exam 3

Ebusiness: Electronic Business Value

269 Questions

Exam 4

Ethics and Information Security: MIS Business Concerns

225 Questions

Exam 5

Infrastructure: Sustainable Technologies

161 Questions

Exam 6

Data: Business Intelligence

206 Questions

Exam 7

Networks: Mobile Business

145 Questions

Exam 8

Enterprise Applications: Business Communications

177 Questions

Exam 9

Systems Development and Project Management: Corporate Responsibility

114 Questions

Exam 11

Networks and Telecommunications

46 Questions

Exam 12

Designing Databases

39 Questions

Show Answer