All relationships and the various needs for REPORTS must be taken into account when designing the database.
Designing a database is a process of making a data model of a particular database. Database designing includes determining the data to be stored, determining the relationship between different elements of the data and producing a logical structure based on the relationship.