Setting up new project

 a. Make sure the folder and file name are in small letter or camel case . Avoid special characters in the file and folder name.

 b. Make sure the folder and file name does not have spaces.

 c. Make sure the file extension is all small letters(.sql, .java,.ts,.html)

 d. If a function (database, java, angular) or stored procedure is used more than one then create as common

 e. Try to maintain master table for associating the files to Task like tbl_service_master etc.

 f. Instead of Sqlite kindly use relational database as much as possible for thitd party prodcuts like Helix ALM.

g. Defect status should be like following in the environment Assuming we have environments like DEV, UIT  and SIT

      Environment : DEV

              New --> when a defect is created 

              Dev-InProgress --> when a developer is working on the defect 

              Dev-Completed  --> when a developer assumes he is done with development of the defect

              Ready for UIT build  --> To build in UIT environment the code is ready

              UIT build inProgess --> when build is happening so end user know that the defect is included as part of the build.

              UIT Test InProgress --> The defect is eligible for  testing in UIT region.

              UIT Completed        --> Tester or Developer has verified and  passed the test          

              Ready for SIT build --> To make the defect is ready for next code promotion

              SIT build InProgress --> Currently build is happening with this defect 

              SIT Test InProgress   --> Currently Tester is testing in SIT region

   h. For Selenium have the database queries in json file instead of Excel so it will be easy for troubleshooting in linux environment.

  i.  For Database we have following 

       i. DDL --> Create table and these will be modified through out the project

      ii. DML --> We will define