Each database have minimum of two files associated with database. If database has more than one filegroup it will have many files associated with one database. Following quick script will give you recordset per file of a database which are stored in master database.
SELECT name, physical_name, type_desc, state_desc
Above script will return following result set.
Reference : Pinal Dave (http://blog.SQLAuthority.com)