Database Detail

Database design in a system tool is used to provide the details of the project’s backend. In this project, the backend used to store the database is SQL Server 2005. SQL Server 2005 is a widely used as backend database. The project uses the database to keep of following table.

1. Table Name: LoginUser

Function: The function of this table is to keep track of the administrator who has logged into the system by entering the appropriate user name and password.

Table Content:

   Field         DataType

   UniqueID        Char

   UserName        Char

   UserPassword    Char

2. Table Name: CustomizeFunction: 

Function: The function of this table is to keep the details of basic company profile used to be displayed in home page.

Table Content:

   Field            DataType

   CompanyName        Char         Primary Key

   CompanyContent     Text
   CompanyLogo        Image

3. Table Name: Disignation

Function: The function of this table is to keep the Types of designation of the company need

Table Content:

   Field             DataType

   DesignationType     Char       Primary Key

4. Table Name: EmployerMast

Function: The function of this table is to keep track of the Employer who are in the company

Table Content:

   Field          DataType

   EmpID            Char      Primary Key
   EmpName          Char
   Designation      Char   Foreign Key related Designation Table
   Date of Birth    Date
   Sex              Char
   Address          Char
   Telephone1       Char
   Telephone2       Char
   SalaryAccount    Char
   BloodGroup       Char
   Basic            Number
   HRA              Number
   DA               Number
   TA               Number
   MA               Number
   SA               Number
   PF               Number
   PT               Number
   GI               Number
   Canteen          Number
   CT               Number
   GS               Number
   TD               Number
   TotalSalary      Number

   Remark1          Char
   Remark2          Char

5. Table Name: EmployerTran

Function: The Function of this table is to keep track of the Employer Salary Compared to each Month who employers in the company.

Table Content:

   Field          DataType

   EmpID            Char      Foreign Key related EmployerMast
   SalaryType       Char      C,R,Q
   Date             Date  

6. Table Name: Dealers

Function: The Function of this table is to keep details of all the Dealers Detail in the Company

Table Content:

   Field          DataType

   DNo              Char        Primary Key

   DName            Char 
   DAdd1            Char
   DAdd2            Char
   DTel1            Char
   DTel2            Char
   DAcNo1           Char
   DAcNo2           Char

7. Table Name: Customer

Function: The Function of this table is to keep details of all the Customer Detail in the Company

Table Content:

   Field          DataType

   CNo              Char        Primary Key

   CName            Char 
   CAdd1            Char
   CAdd2            Char
   CTel1            Char
   CTel2            Char
   CAcNo1           Char
   CAcNo2           Char

8. Table Name: Group

Function: The Function of this table is to keep details of the type of group Names which are used to stock item detail.

Table Content:

   Field          DataType

   GroupName        Char        Primary Key

9. Table Name: StockItem

Function: The function of this table is to keep details of the Stock item in the Company

Table Content:

   Field            DataType

ItemNo   Char   PrimaryKey

5. Table Name: 

Function: 

Table Content:

   Field            DataType

5. Table Name: 

Function: 

Table Content:

   Field            DataType

5. Table Name: 

Function: 

Table Content:

   Field            DataType

5. Table Name: 

Function: 

Table Content:

   Field            DataType