Question 1

The easiest time to change the database structure is after the database has been constructed and loaded with data.

Accepted Answer

A) True 
 B)False

Question 2

Normalised tables eliminate ________.

Accepted Answer

A) data entry 
B) data duplication 
C) data dependency 
D) data conversion 
A) data entry 
B) data duplication 
C) data dependency 
D) data conversion

Question 3

Entities have attributes that describe characteristics of the entity.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

A data model does not depict the relationships among the data.

Accepted Answer

A) True 
 B)False

Question 8

The little lines in an E-R diagram used as shorthand to represent multiple relationships are referred to as a(n)________.

Accepted Answer

A) crow's foot 
B) attribute 
C) entity 
D) identifier 
A) crow's foot 
B) attribute 
C) entity 
D) identifier

Question 9

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

Accepted Answer

A) replaced 
B) duplicated 
C) missing 
D) insufficient 
A) replaced 
B) duplicated 
C) missing 
D) insufficient

Question 10

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 11

The crow's-foot notation shows the minimum number of entities that can be involved in a relationship.

Accepted Answer

A) True 
 B)False

Question 12

Explain the role of users in designing a database.

Accepted Answer

A database is a model of how the users v

Question 13

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(n)________.

Accepted Answer

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

Question 14

The easiest time to change the database structure is ________.

Accepted Answer

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

Question 15

Entities have relationships to attributes but not to each other.

Accepted Answer

A) True 
 B)False

Question 16

The general goal of normalisation is to ________.

Accepted Answer

A) convert two or more tables into a single table 
B) create a copy of an existing table 
C) construct tables such that every table has a single topic 
D) construct tables such that all tables have a similar topic 
A) convert two or more tables into a single table 
B) create a copy of an existing table 
C) construct tables such that every table has a single topic 
D) construct tables such that all tables have a similar topic

Question 17

Which of the following is a highly popular technique for creating a data model with which the developers describe the content of a database by defining what is to be stored in the database and the associations among them?

Accepted Answer

A) Unified Modeling Language (UML) 
B) data integrity model 
C) entity-relationship (E-R)data model 
D) object-relational model 
A) Unified Modeling Language (UML) 
B) data integrity model 
C) entity-relationship (E-R)data model 
D) object-relational model

Question 18

Normalisation is the process of converting a poorly structured table into two or more well-structured tables.

Accepted Answer

A) True 
 B)False

Question 19

A data model is a logical representation of the structure of the data.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is true of entities?

Accepted Answer

A) The relationships between entities are known as attributes. 
B) Entities' characteristics are described by attributes. 
C) Entities can only represent a logical construct or transaction,not a physical object. 
D) An identifier's value is associated with every entity in the data model. 
A) The relationships between entities are known as attributes. 
B) Entities' characteristics are described by attributes. 
C) Entities can only represent a logical construct or transaction,not a physical object. 
D) An identifier's value is associated with every entity in the data model.

Exam 17: Database Design

The easiest time to change the database structure is after the database has been constructed and loaded with data.

Normalised tables eliminate ________.

Entities have attributes that describe characteristics of the entity.

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

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

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

A data model does not depict the relationships among the data.

The little lines in an E-R diagram used as shorthand to represent multiple relationships are referred to as a(n)________.

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

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

The crow's-foot notation shows the minimum number of entities that can be involved in a relationship.

Explain the role of users in designing a database.

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(n)________.

The easiest time to change the database structure is ________.

Entities have relationships to attributes but not to each other.

The general goal of normalisation is to ________.

Which of the following is a highly popular technique for creating a data model with which the developers describe the content of a database by defining what is to be stored in the database and the associations among them?

Normalisation is the process of converting a poorly structured table into two or more well-structured tables.

A data model is a logical representation of the structure of the data.

Which of the following is true of entities?

The Importance of Mis

Business Processes, Information Systems and Information

Organisational Strategy, Information Systems and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Organisations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Development

Information Systems Management

Information Security Management

Collaboration Information Systems for Decision Making, Problem Solving and Project Management

Collaboration 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

Hyper-Social Organisations and Knowledge Management

Database Marketing

Reporting Systems and Olap

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters