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.