Question 1

In a university,each adviser can advise multiple students,but each student can have only one adviser.In a data model,this can be best represented by ________.

Accepted Answer

A) N:M relationships 
B) N:N relationships 
C) 1:N relationships 
D) 1:1 relationship 
A) N:M relationships 
B) N:N relationships 
C) 1:N relationships 
D) 1:1 relationship

Question 2

A data model should be transformed into a database design only after the users have approved and validated it.

Accepted Answer

A) True 
 B)False

Question 3

________ describe the characteristics of entities.

Accepted Answer

A) Attributes 
B) Dependencies 
C) Cardinalities 
D) Alternatives 
A) Attributes 
B) Dependencies 
C) Cardinalities 
D) Alternatives

Question 4

The general goal of normalization is to construct tables such that every table has a single topic or theme.

Accepted Answer

A) True 
 B)False

Question 5

Explain the role of users in designing a database.

Accepted Answer

A database is a model of how the users v

Question 6

The easiest time to change the database structure is ________.

Accepted Answer

A) during the data modeling stage 
B) after constructing the database 
C) during the database designing stage 
D) after creating database reports 
A) during the data modeling stage 
B) after constructing the database 
C) during the database designing stage 
D) after creating database reports

Question 7

Which of the following notations signifies that an adviser can be related to many students and that a student can be related to many advisers?

Accepted Answer

A) 1:N 
B) N:M 
C) N:1 
D) N:N 
A) 1:N 
B) N:M 
C) N:1 
D) N:N

Question 8

Once the users have validated and approved the data model,it is transformed into a ________.

Accepted Answer

A) database design 
B) technical report 
C) knowledge system 
D) data repository 
A) database design 
B) technical report 
C) knowledge system 
D) data repository

Question 9

Normalization is a database design concept that helps to construct well-structured tables.

Accepted Answer

A) True 
 B)False

Question 10

The data integrity problem can occur only if data are missing.

Accepted Answer

A) True 
 B)False

Question 11

The process of converting poorly structured tables into two or more well-structured tables is referred to as ________.

Accepted Answer

A) replication 
B) integration 
C) actualization 
D) normalization 
A) replication 
B) integration 
C) actualization 
D) normalization

Question 12

An identifier is an attribute whose value is associated with every entity in the data model.

Accepted Answer

A) True 
 B)False

Question 13

The maximum number of entities that can be involved in a relationship is known as maximum cardinality.

Accepted Answer

A) True 
 B)False

Question 14

1:N means that more than one entity is allowed on each side of the relationship.

Accepted Answer

A) True 
 B)False

Question 15

The notation N:N is used to indicate a many-to-many relationship in an E-R diagram.

Accepted Answer

A) True 
 B)False

Question 16

How is a data model transformed into a database design?

Accepted Answer

Database design is the process of conver

Question 17

Database practitioners classify tables into various normal forms according to the kinds of problems they have.

Accepted Answer

A) True 
 B)False

Question 18

To represent an N:M relationship between two entities,two normalized tables are sufficient.

Accepted Answer

A) True 
 B)False

Question 19

In an organization,the administrative department consists of one clerk whose sole responsibility is the management of various administrative functions.The notation that accurately indicates this relationship is ________.

Accepted Answer

A) 1:N 
B) N:N 
C) 1:1 
D) N:M 
A) 1:N 
B) N:N 
C) 1:1 
D) N:M

Question 20

What are the different types of relationships represented in a data model?

Accepted Answer

Entities in a data model have relationsh

Exam 17: Database Design

In a university,each adviser can advise multiple students,but each student can have only one adviser.In a data model,this can be best represented by ________.

A data model should be transformed into a database design only after the users have approved and validated it.

________ describe the characteristics of entities.

The general goal of normalization is to construct tables such that every table has a single topic or theme.

Explain the role of users in designing a database.

The easiest time to change the database structure is ________.

Which of the following notations signifies that an adviser can be related to many students and that a student can be related to many advisers?

Once the users have validated and approved the data model,it is transformed into a ________.

Normalization is a database design concept that helps to construct well-structured tables.

The data integrity problem can occur only if data are missing.

The process of converting poorly structured tables into two or more well-structured tables is referred to as ________.

An identifier is an attribute whose value is associated with every entity in the data model.

The maximum number of entities that can be involved in a relationship is known as maximum cardinality.

1:N means that more than one entity is allowed on each side of the relationship.

The notation N:N is used to indicate a many-to-many relationship in an E-R diagram.

How is a data model transformed into a database design?

Database practitioners classify tables into various normal forms according to the kinds of problems they have.

To represent an N:M relationship between two entities,two normalized tables are sufficient.

In an organization,the administrative department consists of one clerk whose sole responsibility is the management of various administrative functions.The notation that accurately indicates this relationship is ________.

What are the different types of relationships represented in a data model?

The Importance of MIS

Business Processes, information Systems, and Information

Organizational Strategy, information Systems, and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Collaboration Information Systems for Decision Making problem Solving and Project Management

Collaborative Information Systems for Student Projects

Mobile Systems

Introduction to Microsoft Excel 2013

Using Microsoft Access 2013

Using Excel and Access Together

Network and Cloud Technology

Enterprise Resource Planning ERP Systems

Supply Chain Management

Enterprise Social Networks and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters