QA Tutorials

DATABASE CONCEPTS

DATABASE MANAGEMENT

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?
Facebook Comments
Tags

23 Comments

  1. 1) Database is a collection of information which are stored in an organised manner so that the data can be easily accessed, managed and updated. Database management system (DBMS) is software system to create, access, manage and update the database.

    2) Ex : of DBMS are MySQL, Oracle, Microsoft SQL Server

  2. 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. e information entered by the user is stored in database on the database server. Database is collection of information stored in organised way so that data can be accessed, managed and updated.
    Database management system is software system to create, access, manage and update the database.Example:Oracle, Microsoft Access, MySQL, SQLite

  3. What is database and DBMS?
    Database is a collection of Data or Information. Data is information related to an entity- e.g. Students, Patients, Customers,Clients etc.Database is a system of storage of data in an organised manner so that it can be easily accessed, updated or managed.
    DBMS or Database management system is a system or software or set of programs which helps access database to manage,change,manipulate,test data.
    Name a few DBMS?
    Toad, SQL server,Oracle.

  4. 1.What is database and DBMS?
    Database is a collection of information which are stored in an oraganised manner so that the data can be easily accessed, managed and updated. Database management system (DBMS) is software system to create, access, manage and update the database.

    2.Name a few DBMS?
    Example of DBMS are MySQL, Oracle, Microsoft SQL

  5. 1.Back-End testing is a testing which deals with server side or database.It is also called as database testing. The data which almost entered will be stored in the back-end as a database.

    2. The database could be MySql, Oracle or MS-Access.

  6. Database is collection of information stored in organized way so that data can be accessed, managed and updated.
    Database management system is software system to create, access, manage and update the database.

  7. 1.What is database and DBMS?
    Database is collection of information stored in organised way so that data can be accessed, managed and updated.Database
    management system is software system to create, access, manage and update the database.
    2.Name a few DBMS.
    Microsoft SQL server,IBM DB2,Oracle,MySQL

  8. 1.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. & Database is collection of information stored in organized way so that data can be accessed, managed and updated.
    Database management system(DBMS) is software system to create, access, manage and update the database.
    2.MySql, Oracle & MS-Access

  9. 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.

  10. Database is a collection of information that is organized so that it can be accessed, managed and updated.
    A database management system (DBMS) is a system software for creating and managing database. It makes possible for end user to create, read, update and delete data in a database .
    Few examples of DBMS are SQL server ,My SQL ,Oracle.

  11. Database is a collection of related data organised in a way that data can be easily accessed, managed and updated. Database can be software based or hardware based, with one sole purpose, storing data.

    DBMS is a software that allows creation, definition and manipulation of database, allowing users to store, process and analyse data easily. DBMS provides us with an interface or a tool, to perform various operations like creating database, storing data in it, updating data, creating tables in the database and a lot more.

    DBMS also provides protection and security to the databases. It also maintains data consistency in case of multiple users.

    MySql
    Oracle
    SQL Server
    IBM DB2
    PostgreSQL
    Amazon SimpleDB

  12. 1. A database is a collection of information that is stored in an organized matter so it can be easily accessed, managed, and updated. A DBMS is a software system used to create, access, manage, and update the database.

    2. Examples of DBMS include MySql, Oracle, and Microsoft Access.

  13. Database: Database is a system intended to easily organize, store and retrieve large amounts of data.
    DBMS: Database Management System is a software system to create, access, manage and update the database.
    DBMS examples: Microsoft Sql Server, MySql, Oracle, Microsoft Access, IBM DB2

  14. 1.) A database is a data storage system utilized to organize, store, and retrieve large amounts of data from many sources. Data brought into a database is transformed to be uniform. DBMS is database management system which is a system software used to create, access, manage, and update the database.
    2.) DBMS examples include MySQL, Oracle, Microsoft Access, FoxPro, Clipper, and dBASE.

  15. Database is collection of Information stored in organised way so that data can be accessed,managed and updated.
    Database Management System is softwaresystem to create access,manage and update the database
    Microsoft,SQL,Oracle

  16. What is database and DBMS?
    A database is a collection of related data which represents some aspect of the real world.
    Database management system is a software for storing and retrieving users’ data while considering appropriate security measures.

    Name a few DBMS?
    MySQL, Microsoft Access, Oracle, PostgreSQL

  17. What is database and DBMS?
    Database is collection of information stored in organized way so that data can be accessed, managed and updated. The database testing is also called as backend testing. And Database management system (DBMS) is software system to create, access, manage and update the database.
    Name a few DBMS?
    Example: MySQL, Microsoft SQL Server, Microsoft Access, Oracle, etc.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Articles

Back to top button
Close
Close