What could be the best DBMS to store airbnb data for price prediction
You can certainly accomplish this with any modern RDBMS, as 400,000 records is actually small data nowadays. 
Since it's a school project, I assume you'll want to use a free edition of the system you choose. PostgreSQL and MySQL are free out the gate, Microsoft SQL Server also offers a free edition called &quot;Express&quot; edition, and I believe even Oracle offers a free edition of their database system as well.
My somewhat subjective recommendation out of those choices would be to use PostgreSQL or Microsoft SQL Server, just because of their mainstream use and plethora of documentation on how to setup, use, and query in either system. And both offer a sufficient amount of features, that I think they'll meet your data needs without a second thought.
The final criteria to help you decide on which one to use should be based off of which procedural programming language / tech stack you're most familiar with (if you need to use one as part of this project). If you're used to the Microsoft tech stack then SQL Server is a fitting choice, otherwise most other cases will plug into PostgreSQL just fine. If you're planning to use Python for the application side, it probably can plug into either database system just as easily.