Is your data model catering for nearly all current and some future system requirements? It should be! The first step in designing a great database for a system is at the requirements analysis stage – in other words, finding out what’s needed, and working out the best way to deliver a system that fulfils those needs.
Getting the data-model right is always an iterative process. An initial draft data model will be sketched, reviewed then improved upon. Issues that arise from the database design process will feed into the overall system design. Problems that are identified here may throw up questions that need to be addressed elsewhere.