In order to ensure optimal database performance, the logical and physical design should consider the user requirements thoroughly. Suppose you have been hired to transform a conceptual model into a logical model for a sales database. Describe the specific steps that you must perform in order to appropriately construct the database model. For each step mentioned, speculate the risks that might present themselves and how you would avoid or mitigate those risks.

There are three levels to data modeling when we are considering designing a database for optimal database performance and they are logical data modeling, conceptual data modeling and physical data modeling.

(1). IMPORTANT FEATURES NEEDED IN LOGICAL DATA MODELING:

- entity names.

- attributes.

- foreign key.

- primary key.

(2). IMPORTANT FEATURES NEEDED CONCEPTUAL DATA MODELING:

- entity relationships.

- entity names.

For complexity sake, always start with THE CONCEPTUAL DATA MODELING (least complex).

The following steps can be used in CONSTRUCTION OF DATABASE MODEL.

(1). IDENTIFY THE ENTITIES: Identify entities such as the events, people and so on.

The RISK=> efficient identification of entities such as events, location, people has to occur.

(2). IDENTIFY RELATIONSHIPS: check for relationships such as customers to sales, customers to shops and many more.

The RISK=> it must be arranged in definite order.

(3). IDENTIFY ATTRIBUTES: check for attributes such as address, names and so on.

(4). DEFINE DATATYPE FOT THE ATTRIBUTES: Datatypes should be define for the attributes that was Identifed.

(5). NORMALIZATION: which may include first, second and third.

SUMMARY: database modeling involves the following; domain, functionality, entities, relationships and design.

RISKS TO AVOID IN DATABASE MODELING;

- analysis of the basic requirements.

- users should be given specifications.

- change should be checked in business.