Question 1

Which doesn't DBMS allow?

Accepted Answer

A) creation of database 
B) classification of database 
C) modification of database 
D) updating the database 
E) retrieval of data 
A) creation of database 
B) classification of database 
C) modification of database 
D) updating the database 
E) retrieval of data

Question 2

Referential integrity governs the nature of records in a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 3

Which order is correct in the retrieval and presentation of data? I. Select rows from the relation.
II. Derive new attributes.
III. Join two relations together.
IV. Present data.
V. Choose a relation from the database.
VI. Project columns from the relation.
VII. Calculate totals and performance measures.
VIII. Index or sort rows.

Accepted Answer

A) V - III - II - I - VIII - IV - VI - VII 
B) V - III - VI - I - II - VIII - VII - IV 
C) III - V - VI - I - II - VIII - VII - IV 
D) V - III - II - I - VI - IV - VII - VIII 
E) III - V - II - I - VI - VII - VIII - IV 
A) V - III - II - I - VIII - IV - VI - VII 
B) V - III - VI - I - II - VIII - VII - IV 
C) III - V - VI - I - II - VIII - VII - IV 
D) V - III - II - I - VI - IV - VII - VIII 
E) III - V - II - I - VI - VII - VIII - IV

Question 4

A ________ represents more than one of the other entity.

Accepted Answer

A) crow's foot 
B) single line 
C) double line 
D) dotted line 
A) crow's foot 
B) single line 
C) double line 
D) dotted line

Question 5

What is a collection of data items that have something in common with the entity?

Accepted Answer

A) a record 
B) an attribute 
C) a data item 
D) an entity 
A) a record 
B) an attribute 
C) a data item 
D) an entity

Question 6

A master file contains information used to update master files and produce reports.

Accepted Answer

A) True 
 B)False

Question 7

What is the difference between a primary key and a secondary key?

Accepted Answer

A primary key is a key that uniquely ide

Question 8

A(n)________ represents additional attributes of an entity that may not be present on every record of the entity.

Accepted Answer

A) entity subtype 
B) entity type 
C) primary entity 
D) secondary entity 
A) entity subtype 
B) entity type 
C) primary entity 
D) secondary entity

Question 9

Any object or event about which someone chooses to collect data is an attribute.

Accepted Answer

A) True 
 B)False

Question 10

Data mining is used to verify or validate patterns that humans are able to make themselves.

Accepted Answer

A) True 
 B)False

Question 11

A many-to-many relationship may be implemented using three tables.

Accepted Answer

A) True 
 B)False

Question 12

Give two examples of primary keys that can be used to identify a person or thing.

Accepted Answer

Students may have a wide range of exampl

Question 13

An associative entity is used for repeating groups.

Accepted Answer

A) True 
 B)False

Question 14

What is denormalization?

Accepted Answer

Denormalization is the process

Question 15

A deletion anomaly occurs when the entire primary key is not known and the database cannot delete a record.

Accepted Answer

A) True 
 B)False

Which doesn't DBMS allow?

Referential integrity governs the nature of records in a one-to-many relationship.

A ________ represents more than one of the other entity.

What is a collection of data items that have something in common with the entity?

A master file contains information used to update master files and produce reports.

What is the difference between a primary key and a secondary key?

A(n)________ represents additional attributes of an entity that may not be present on every record of the entity.

Any object or event about which someone chooses to collect data is an attribute.

Data mining is used to verify or validate patterns that humans are able to make themselves.

A many-to-many relationship may be implemented using three tables.

Give two examples of primary keys that can be used to identify a person or thing.

An associative entity is used for repeating groups.

What is denormalization?

A deletion anomaly occurs when the entire primary key is not known and the database cannot delete a record.

Systems, roles, and Development Methodologies

Understanding and Modeling Organizational Systems

Project Management

Information Gathering: Interactive Methods

Information Gathering: Unobtrusive Methods

Agile Modeling, prototyping, and Scrum

Using Data Flow Diagrams

Analyzing Systems Using Data Dictionaries

Process Specifications and Structured Decisions

Object-Oriented Systems Analysis and Design Using UML

Designing Effective Output

Designing Effective Input

Human-Computer Interaction and Ux Design

Designing Accurate Data Entry Procedures

Quality Assurance and Implementation

Filters

Exam 13: Designing Databases

Which doesn't DBMS allow?

Referential integrity governs the nature of records in a one-to-many relationship.

A ________ represents more than one of the other entity.

What is a collection of data items that have something in common with the entity?

A master file contains information used to update master files and produce reports.

What is the difference between a primary key and a secondary key?

A(n)________ represents additional attributes of an entity that may not be present on every record of the entity.

Any object or event about which someone chooses to collect data is an attribute.

Data mining is used to verify or validate patterns that humans are able to make themselves.

A many-to-many relationship may be implemented using three tables.

Give two examples of primary keys that can be used to identify a person or thing.

An associative entity is used for repeating groups.

What is denormalization?

A deletion anomaly occurs when the entire primary key is not known and the database cannot delete a record.

Systems, roles, and Development Methodologies

Understanding and Modeling Organizational Systems

Project Management

Information Gathering: Interactive Methods

Information Gathering: Unobtrusive Methods

Agile Modeling, prototyping, and Scrum

Using Data Flow Diagrams

Analyzing Systems Using Data Dictionaries

Process Specifications and Structured Decisions

Object-Oriented Systems Analysis and Design Using UML

Designing Effective Output

Designing Effective Input

Human-Computer Interaction and Ux Design

Designing Accurate Data Entry Procedures

Quality Assurance and Implementation

Filters