Logical and Physical Design

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.

· Speculate the risks that might present themselves for each step mentioned, and how you would avoid or mitigate those risks.