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.
