DATABASE CONCEPTS - H2KINFOSYS

The database concepts is a major part of study for the testers, because data storage and processing is one the important requirement from the client. The information has to be stored in every organisation. e.g.: Banks, library, flight companies, hospitals, universities etc. The information is stored for the future reference. The information can be used for future reference to generate the reports. The data in any organisation has below roles:
  • data can be used to identify the problems, performance of various entities in organization.
  • data is used to analyse the various scenarios in the organisation.
  • data is used by the management for administration
  • data is used to provide the explanation for various events
  • data is used to monitor the performance and progress in organisations.
  • data is used for planning, monitoring and controlling.
  • data is used for making major decisions in the organisation.
Since the data plays very important role in any of the organisation, below factors become important:
  • data should be stored in organised way
  • it should be possible to generate the any formats of reports
  • the report generation should be quick and available as and when required.
Hence the data is stored using software systems.
The database testing is also called as backend testing. The user interface is connected to the database. The information entered by the user is stored in database on the database server. The tester validates the data in the database for its correctness, authenticity, format, location etc which is termed as database testing. The database testing is performed by software testers along with or after functional testing. Below are some of the basic concepts or terminologies associated with database testing:

Entity:

It is anything about which information can be stored. Eg: students, employees, courses, patients, departments, sales, raw materials, inventory, etc.

Data:

Data is an information about a particular entity.

Database:

Database is collection of information stored in organised way so that data can be accessed, managed and updated.

Database management system:

Database management system is software system to create, access, manage and update the database.

Questions:

  1. What is database and DBMS?
  2. Name a few DBMS?

 FOR MORE INFORMATION
visit https://www.h2kinfosys.com/blog/database-concepts/
Email: training@h2kinfosys.com
Call: 7707771269

:

Comments

Post a Comment

Popular posts from this blog

5 Steps to Becoming a Certified Business Analyst

Image
  Business analysts are among the most in-demand professionals today, and demand for them is only going up. So how can you demonstrate to potential employers that you have the skills necessary to complete this task? Getting one of the various business analysis credentials by holding a business analyst certification would be the answer for it. If you have a business analyst certification after completing an   online business analyst course , your resume will have the qualifications the employers are looking for. The certification you have will prove that you finished and passed the test that evaluates your abilities.  Your qualifications can make you stand out among other job participants. You can get the benefit of more salary, career prospects, and greater job stability. If you have interest in becoming a certified business analyst, here are the five steps you should take: What is a business analyst certification? Business analysts use the information they gather from an organization&
Read more

How to perform gap analysis as a Business Analyst

  A firm compares its present performance to its performance objectives or goals through a gap analysis. Its purpose is to assist companies in locating any weaknesses or holes they may have so that a plan can be developed to address them and enhance corporate operations. Even if it might appear complicated initially, a gap analysis can be finished in the simple steps indicated in the free gap analysis template. But anyone can complete the procedure with training and a well-made gap analysis template. Here mentioned are the steps to perform gap analysis as a business analyst: What can a gap analyst do? A gap analysis compares actual results to anticipated ones to pinpoint ineffective or absent strategies, processes, technology, or abilities. Utilize the gap analysis findings to suggest steps your business should take to achieve its objectives. Companies, business units, or teams can identify what they need to focus on to improve performance or results and move more quickly toward the de
Read more

Will qa engineers get replaced?

  An individual who employs software quality assurance concepts and methods throughout the life cycle of software development is known as a quality assurance analyst. Software quality assurance covers the entire software development life cycle, including software design, requirements management, testing, coding, and release management. Software testing is designed, planned, and carried out with quality assurance analysts. The development team, business analyst, and quality assurance analyst collaborate closely to approve test cases based on software requirements. The person who tries to break software most often is a QA analyst. Every time the program fails, the QA analyst feels some sense of achievement because it helps to prevent the flaws from making it to the production stage. Below listed are the future scopes of QA engineers: How it works: The same test suite must be run repeatedly over the product development cycle. You should attend  software testing training online   to become
Read more