DBMS-Enhanced Entity-Relationship (EER) Model - Practice Questions

Question 1

SDLC stands for

Accepted Answer

Question 2

The top-down database design approach starts at the

Accepted Answer

Question 3

The conceptual database design is the process of

Accepted Answer

Question 4

Relative costs of fixing a fault at later phases, is less as compared to fixing the fault at the early phases of the software process

Accepted Answer

Question 5

A partial participation is represented using a single line between the supertype and the specialiasation/generalisation circle.

Accepted Answer

Question 6

Generalization is the process of identifying some common characterstics of a collection of entity sets and creating a new entity set that contains entities processing these common characterstics.

Accepted Answer

Question 7

The objective of developing a prototype of the system is to demonstrate the understanding of the user requirement and the functionality that will be provided in the proposed system.

Accepted Answer

Question 8

Attribute inheritance is the property by which supertype entities inherit values of all attributes of the subtype.

Accepted Answer

Question 9

The bottom-up approach is appropriate for the design of simple database with a relatively small number of attributes.

Accepted Answer

Question 10

The uses of specialisation or generalisation technique for a particular situation depends on

Accepted Answer