• whenever you create a database with multiple data files, the first file will be created as .mdf and all other as .ndf.

    Normally we create database with multiple data files to keep the data on different IO disk, for better performace and management.