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.