Database is not showing up in the SSMS
Just converting the part of comment to an answer so as to close this question:

It seems like someone had the database detached, because of which database was not visible and hence you were also able to view its respective mdf and ldf.

Right Click Databases-->  click Attach--> Choose the respective mdf files for the database in question.

Refresh and check , the database should be visible.