In order to ensure optimal database performance, the logical

In order to ensure optimal database performance, the logical andphysical design should consider the user requirements thoroughly.Suppose you have been hired to transform a conceptual model into alogical model for a sales database. Describe the specific steps that youmust perform in order to appropriately construct the database model.For each step mentioned, speculate the risks that would take place andhow you would avoid or mitigate those risks.