Question 1

Explain the difference between maximum and minimum cardinality.

Accepted Answer

Cardinality is the number of entities that can be involved in a relationship.There can be both a maximum and minimum constraint on cardinality.The crow's-foot notation shows the maximum number of entities that can be involved in a relationship.Accordingly,they are called the relationship's maximum cardinality.Common examples of maximum cardinality are 1:N,N:M,and 1:1.Constraints on minimum requirements are called minimum cardinalities.

Question 2

A vertical bar on a line representing a relationship indicates that there is a minimum requirement for the entity.

Accepted Answer

A) True 
 B)False  True

Question 3

The N:N notation indicates that the same number of entities are present on each end of the relationship.

Accepted Answer

A) True 
 B)False  True

Question 4

Explain the database development process.

Accepted Answer

A database application consists of forms

Question 5

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

Accepted Answer

Entities in a data model have relationsh

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

________ describe the characteristics of entities.

Accepted Answer

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

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

In an entity-relationship (E-R)diagram,a line is used to represent a relationship between two entities.

Accepted Answer

A) True 
 B)False

Question 10

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

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) normalisation 
C) actualisation 
D) integration 
A) replication 
B) normalisation 
C) actualisation 
D) integration

Question 12

How is a data model transformed into a database design?

Accepted Answer

Database design is the process of conver

Question 13

What are the steps involved in transforming a data model into a relational database design?

Accepted Answer

The first step in transforming a data mo

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Maximum cardinality in an E-R diagram refers to the maximum number of ________.

Accepted Answer

A) attributes an entity can have 
B) entities that can be involved in a relationship 
C) relationships possible in a diagram 
D) identifiers possible in a particular diagram 
A) attributes an entity can have 
B) entities that can be involved in a relationship 
C) relationships possible in a diagram 
D) identifiers possible in a particular diagram

Question 16

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

Accepted Answer

A) normal forms 
B) cardinalities 
C) attributes 
D) entities 
A) normal forms 
B) cardinalities 
C) attributes 
D) entities

Question 17

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 18

A(n)________ notation signifies that an adviser can be related to many students and that a student can be related to many advisers.

Accepted Answer

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

Question 19

In an organisation,a single clerk is working in the administrative department.The notation that accurately indicates this relationship is ________.

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 17: Database Design

Explain the difference between maximum and minimum cardinality.

A vertical bar on a line representing a relationship indicates that there is a minimum requirement for the entity.

The N:N notation indicates that the same number of entities are present on each end of the relationship.

Explain the database development process.

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

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

________ describe the characteristics of entities.

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

In an entity-relationship (E-R)diagram,a line is used to represent a relationship between two entities.

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

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

How is a data model transformed into a database design?

What are the steps involved in transforming a data model into a relational database design?

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

Maximum cardinality in an E-R diagram refers to the maximum number of ________.

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

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

A(n)________ notation signifies that an adviser can be related to many students and that a student can be related to many advisers.

In an organisation,a single clerk is working in the administrative department.The notation that accurately indicates this relationship is ________.

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

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