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

Is a QA tester better than a software developer?

  Software development and software testing, are the two main paths in software science, have long clashed. When choosing one of them for their career, people frequently need clarification. This is because these career alternatives are the subject of numerous myths that conflict with one another. Graduates can find employment in various fields, including software development and testing. One needs in-depth topic knowledge and practical experience to overcome the obstacles in each work area. However, when software testing is compared to software development, people mistakenly believe it needs to be more critical. Software testers are in great demand because the career opportunities are on par with those of software developers. Let's see about does a QA tester is better than a software developer: Significance Testing is a requirement for software to be complete. Software testing examines the program to see if it adheres to industry standards, how satisfied users are with it, and if t...
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 th...
Read more