5.2 DATABASE DESIGN STEPS

A major purpose of a database system is

• to provide users with an abstract view of the data

• to display all data to the user

• to retrieve the data from database

Types of database access levels are:

• internal level

• outside level

• conceptual level

• external level

When a case that needs a database creation is presented, before to switch on the computer, it is better to think about:

• The type of information to work with

• The types of questions that the database should answer

• What information needs to be stored

Even the simplest database should be thought through on paper before being created in any tool

• True

• False

In planning the database, regardless of its size and complexity the following basic steps are used:

• Investigate the information

• Identify the objects and Model the object

• Identify the types of information for each object and Identify the relationship between objects

• Database optimization through normalization

• Data entry and manipulation