Database Design

Which of the following is related to information?

• data

• communication

• knowledge

• all of these

Data is ...

• a piece of fact

• metadata

• information

• none of these

Which of the following is an advantage of using a database system?

• security enforcement

• avoidance of redundancy

• reduced inconsistency

• all of these

The appearance of the same data over and over again in the combined data file which should not have happened

• data inconsistency

• data dependence

• data redundancy

• data isolation

These are the database basic operation, except ...

• create database

• make database

• insert

• drop table

The data is organized in a tree-like structure

• network model

• object-oriented model

• relational model

• hierarchical model

In a relational database model, which one is referred to as an entity?

• a table

• a row

• a column

• a record

These are the stages of DDLC, except ...

• testing and validation

• database design

• database implement

• identify business rule

Business rules are generally provided by ...

• managers

• policymakers

• interviews with end users

• all of these

What represents a correspondence between the various data elements?

• data

• constraints

• relationships

• schema