Database Design and Normalization

In 1NF the record can repeat

• true

• false

Designing a proper database can reduces the maintenance cost

• true

• false

Designing a proper database improving______

• storage space

• data consistency

• maintenance cost

• cost

The designer should follow the constraints

• true

• false

Database design can be generally defined as a collection of tasks or processes

that enhance the _________________ of

enterprise data management system.

• implementation

• designing

• development

• maintenance

The designer should decide how the______correlate and what kind of data must be stored.

• number

• elements

• price

• date

Database normalization is a process used to organize a database into___and___

• rows

• tables

• lines

• columns

The designing principles defined for a database give a clear idea of the behavior of any application

• true

• false

Database designs provide the blueprints of how the______

• data is going to be stored in a disk

• data is store in regster

• instructions in the disk are executed

• data is going to be stored in a system.

A proper design of a database highly affects the overall performance of any application.

• true

• false