T2220 - DBD5024 : QUIZ 2

Relations should always be normalized to the highest degree possible.

• TRUE

• FALSE

E. F. Codd and R. Boyce developed Boyce-Codd Normal Form (BCNF) to resolve anomalies in the 3NF.

• TRUE

• FALSE

Which of the following would be a reason to denormalise a relation?

• Improve security

• Lack of design time

• End user preference

• Improve performance

Which of the following functions model business rules?

• Database planning

• Data analysis and requirements

• Database design

• Operations

Which of the following is NOT part of the implementation process?

• Testing

• System analysis

• Evaluating the system

• Creating detailed design specifications

Changes in hardware, software, documentation, or production to a database system to correct errors, meet new requirements, or improve processing efficiencies are called maintenance.

• TRUE

• FALSE

“A stage of database design that maps the data-storage and access characteristics of the database.” refers to DBMS software selection.

• TRUE

• FALSE

The most common style for a logical database model is the relational database model.

• TRUE

• FALSE

Invoices and mailing labels are examples of forms.

• TRUE

• FALSE

The most used method for data entry and retrieval in business-based systems is ______ interaction.

• object-based

• command language

• form

• menu