Quiz 2 - DBD5024

Which of the following best defines the term normalisation?

• When you cannot enter data because other data is required.

• When you must edit the same information in several places.

• When removing data accidentally causes the loss of other data.

• The process of removing anomalies and redundancies from database design.

Which of the following is the normal form that removes all repeating groups?

• First Normal Form

• Second Normal Form

• Third Normal Form

• Boyce Codd Normal Form

When should you denormalise a database?

• Never denormalise a database.

• Always denormalise a database.

• Only the denormalised design needs to be documented.

• When performance is an issue and there is no other way to achieve the performance goals.

Organising the database in computer disk storage is done in the ______ phase.

• design

• maintenance

• analysis

• implementation

The traditional methodology used to develop, maintain and replace information systems is called the ______.

• Unified Model

• Systems Development Life Cycle

• Enterprise Resource Model

• Systems Deployment Life Cycle

The statement “A single designer is responsible to create the whole design alone. This kind of design is used in a simple system development.” refers to ______.

• top-down design

• bottom-up design

• centralised design

• decentralised design

Which of the following is NOT the common factors affecting the DBMS software selection?

• DBMS features and tools

• Cost

• Stationary

• DBMS hardware requirements

Which of the following best defines the term well-structured relation?

• A named, two-dimensional table of data.

• A relation that contains a minimum amount of redundancy and inconsistency.

• Data represented as a set of related tables or relations.

• Entries in columns are from the same set of values.

______ refers to a design approach that involves an understanding of the target audience, their tasks and goals, information needs, and experience levels.

• Prototyping

• User-centered design

• ER diagram

• Data flow diagram

Users enter explicit statements into a system to invoke operations refers to ______ interaction.

• command language

• menu

• form

• object-based