MS SQL server database is a relational database management system. It used by those organization or company that has branches of the organization or company. Because a single MS SQL server database can be used by its entire branch at the same time, so that it provides all update information or data to the all of its branch. If a company has a database of its product availability and this database are shared by its entire branch and if the database is updated then it is necessary that the updated database are available to the all of its branch.

This task can be achieved by MS SQL server database, because it works on very efficient mechanism and reduce data redundancy, protect database from the unauthorized person, provides concurrency etc. this application is developed by the Microsoft for the other application software, actually application software provides only user interface but the actual task is done by the MS SQL database. The all information are stored in the database, data are modified on it, deleted from database and fetched from the database. It stores data in the tabular format, so that when user enters any query then database can easily give the result to the user. This database uses many keys to store and maintain the data like primary key, foregoing key etc. it store the information in to several files such as ‘.mdf’ file is use to store the primary data, ‘.ndf’ file is use to store the secondary data and ‘.ldf’ file is use to store the additional data.