Agile method used to develop in small parts to quick response to customer,what about designing SQL it should be designed entirely or partial ?

I think database should be designed entirely,it is correct that when the project improved ,the database may be changed ,but designing entire databse makes a roadmap for development of project to help forcast any feature needs  or ...