1. File Form      

• SQL server database have three types of file:

a.Primary File:-       

• The primary data file contains the startup information for the database and point to the others file in database.
• User data and object can be stored in this file or secondary data file.
• Every database has one primary data file.
• The recommended file name extension for primary data file is ".mdf ".         

b.Secondary File:-      

• Secondary data files are optional,are user defined and store user data.
• Secondary files can be  used  to spread data across multiple disk by putting each file on a different disk drive.
• If a database exceeds the maximum size for a single windows file you can use secondary data files so the database can continue grow.
• The recommended file name extension for secondary data files is ".ndf".

c.Transaction Log:-

• The  transaction log files hold the log information that is used to recover the database.
• There must be at least one log file for each database.
• The recommended file name extension for transaction log is ".ldf".

2.Table Form

• SQL table is a collection of data which is organized in terms of rows and columns.
• In DBMS,the table as known as relation and row as a tuples.
• Table is a simple form of  data storage.A table  is also convenient representation of relation.
• Tables contains multiple records (Rows and Columns ).

What is Database

• A database is a systematic collection of data .
• Database support storage and manipulation of data.
• Database make data management easy.

Table And Record

• A table in a relational database is a predefined format of rows and column that define an entity.
• Each column contains a different type of attribute and each row corresponds to a single record.
• Each table is provided with a name.

• SQL is used to create new database.
• SQL is used to create new tables in a database.
• SQL is used to insert records, update records,delete record in a database.
• SQL is used to retrieve data from database.
• SQL can set permission on tables procedures and views.
• SQL is used to create stored procedures in a database.
• SQL is used to create view in a database.

• Database Developers.
• Database Admistrators.(DBA)
• Database Testers.

1. Verify data Integrity ( completeness and correctness of data).
2. Verify data Manipulation (Add,Update,Delete).
3. Verify data Comparison (two database front end data with back end data).