1.) Data integrity
The complete data belonging to each entity should be stored in the database. Depending on the database design, the data may be present in a single table or multiple related tables. Parent-child relationships should exist in the data. There should not be any missing data.
a.)Is the data stored in tables is correct.
b.)Is there any unnecessary data present.
c.)Is the data present in the correct table.
d.)Is the data present in correct field within the table.
2.)Database performance (query execution times, throughput etc.) and locking problems
You may identify the main queries (or procedures) that are used in the application and time them with sample data. Locking problems may become apparent when multiple inserts/ updates are being made
to the same entity simultaneously.
3.)Data security
You may check if any data that should be encrypted e.g. passwords, credit card numbers is in plain text or not. The database should not have the default passwords. Even application accounts should have passwords that are complex and not easily guessed.
Miscellaneous
a.)Are the log events added in database for all login events
b.)Does scheduled jobs execute timely.
c.)SQL Injection should not be allowed and handled properly
d.)Backup and Recovery:Is timely backup of Database taken.
e.)Security:Is the data secured from unauthorized access: Are different user roles created with different permissions
Do all the users have access on Database
f.)Is the Field length specified on UI same as field length specified in table to store same element from UI into database.
g.)Check for Primary key: For Primary key 'Allow Null' condition should not be allowed.
h.)Check for each field and UI element: Field length of field in data base and on UI(if mentioned) should be same.
You may check if any data that should be encrypted e.g. passwords, credit card numbers is in plain text or not. The database should not have the default passwords. Even application accounts should have passwords that are complex and not easily guessed.
Miscellaneous
a.)Are the log events added in database for all login events
b.)Does scheduled jobs execute timely.
c.)SQL Injection should not be allowed and handled properly
d.)Backup and Recovery:Is timely backup of Database taken.
e.)Security:Is the data secured from unauthorized access: Are different user roles created with different permissions
Do all the users have access on Database
f.)Is the Field length specified on UI same as field length specified in table to store same element from UI into database.
g.)Check for Primary key: For Primary key 'Allow Null' condition should not be allowed.
h.)Check for each field and UI element: Field length of field in data base and on UI(if mentioned) should be same.
Thanks you for sharing this unique useful information content with us. Really awesome work. keep on blogging
ReplyDeleteJava training in Chennai | Java training institute in Chennai | Java course in Chennai
Java training in Bangalore | Java training in Electronic city
Java training in Bangalore | Java training in Marathahalli
Java training in Bangalore | Java training in Btm layout
I would really like to read some personal experiences like the way, you've explained through the above article. I'm glad for your achievements and would probably like to see much more in the near future. Thanks for share.
ReplyDeletepython course in pune
python course in chennai
python course in Bangalore
I am sure this post has helped me save many hours of browsing other related posts just to find what I was looking for. Many thanks!
ReplyDeleteData Science training in rajaji nagar | Data Science Training in Bangalore
Data Science with Python training in chennai
Data Science training in electronic city
Data Science training in USA
Data science training in pune
I always enjoy reading quality articles by an individual who is obviously knowledgeable on their chosen subject. Ill be watching this post with much interest. Keep up the great work, I will be back
ReplyDeleteangularjs Training in chennai
angularjs-Training in tambaram
angularjs-Training in sholinganallur
angularjs-Training in velachery
angularjs-Training in pune
angularjs Training in bangalore
The knowledge of technology you have been sharing thorough this post is very much helpful to develop new idea.
ReplyDeletehere by i also want to share this.
Java training in Bangalore|best Java training in Bangalore
Java training in Chennai
Java training in Bangalore
Java online training
Java training in Pune
Nice Post! Thank you for sharing very good post, it was so Nice to read and useful to improve my knowledge as updated one, keep blogging.
ReplyDeleteAngular js Training in Electronic City
It is explained in clear way. It is very easy to understand the information.
ReplyDeleteBest SAP Training in Bangalore for SAP, we provide the sap training project with trainers having more than 5 Years of sap training experience, we also provide 100% placement support.
Great site you have got here.. It’s difficult to find high quality writing like yours these days. I truly appreciate individuals like you! Take care!!
ReplyDeleteI am sure that this post helped me lot.
ReplyDeleteAngularJS training in chennai | AngularJS training in anna nagar | AngularJS training in omr | AngularJS training in porur | AngularJS training in tambaram | AngularJS training in velachery
nice work! This is the type of information that should follow the web. Embarrassment captivating position Google for not positioning this transmit higher!keep on sharing!!
ReplyDeleteAndroid Training in Chennai
Android Online Training in Chennai
Android Training in Bangalore
Android Training in Hyderabad
Android Training in Coimbatore
Android Training
Android Online Training
Myself so glad to establish your blog entry since it's actually quite instructive. If it's not too much trouble continue composing this sort of web journal and I normally visit this blog. Examine my administrations.
ReplyDeleteRead these Salesforce Admin Certification Topics which are really helpful. I read these Salesforce Admin and Developer Certification Dumps and very much useful for me.
Thanks a lot very much for the high your blog post quality and results-oriented help. I won’t think twice to endorse to anybody who wants and needs support about this area.
ReplyDeletejava training in chennai
java training in velachery
aws training in chennai
aws training in velachery
python training in chennai
python training in velachery
selenium training in chennai
selenium training in velachery
Great thoughts you got there, believe I may possibly try just some of it throughout my daily life.
ReplyDeleteoracle training in chennai
oracle training in annanagar
oracle dba training in chennai
oracle dba training in annanagar
ccna training in chennai
ccna training in annanagar
seo training in chennai
seo training in annanagar
Thank you for taking the time and sharing this information with us. It was indeed very helpful and insightful while being straight forward and to the point.
ReplyDeletehadoop training in chennai
hadoop training in tambaram
salesforce training in chennai
salesforce training in tambaram
c and c plus plus course in chennai
c and c plus plus course in tambaram
machine learning training in chennai
machine learning training in tambaram
Inspiring writings and I greatly admired what you have to say , I hope you continue to provide new ideas for us all and greetings success always for you.
ReplyDeleteKeep update more information..
data science training in chennai
data science training in omr
android training in chennai
android training in omr
devops training in chennai
devops training in omr
artificial intelligence training in chennai
artificial intelligence training in omr
ReplyDeleteNice blog! Thanks for sharing this valuable information
Java Training in Hyderabad
Java Training in Delhi
Java Training in Gurgaon
This post is so interactive and informative.keep update more information...
ReplyDeleteAndroid Training in Tambaram
Android Training in Chennai
Great post. keep sharing such a worthy information.
ReplyDeleteSwift Developer Course in Chennai
Swift Training in Bangalore
Swift Online Course
Mindblowing blog very useful thanks
ReplyDeleteDevOps Training in Porur
DevOps Training in Chennai