What is dbms and what are functions of dbms, Database Management System

Assignment Help:

What is DBMS and what are functions of DBMS?

DBMS consist of collection of integrated data and set of program to admission those data.

The functions performed by a typical DBMS are the subsequent:

• Data Definition: The DBMS gives functions to define the structure of the data in the application. These involved defining and modifying the record structure, the kind and size of fields and the several constraints/conditions to be satisfied through the data in each field.

• Data Manipulation: Once the data structure is described, data required to be inserted, modified or deleted. The functions that perform these operations are also element of the DBMS. These functions can handle planned and unplanned data manipulation required. Planned queries are those that form part of the application. Unplanned queries are ad-hoc queries that are performed on a required basis.

• Data Security & Integrity: The DBMS contains functions that handle the security and integrity of data in the application. These can be therefore the DBMS provides an environment which is both convenient and efficient to use while there is a large volume of data and several transactions to be proved


Related Discussions:- What is dbms and what are functions of dbms

Describe the term- state diagram, Describe the term- State Diagram Sta...

Describe the term- State Diagram State Diagram: An object could receive a sequence of the input instructions. The state of the object can differ depending upon sequence of in

Datamodels, explain thee diffrent types of data models

explain thee diffrent types of data models

Table handling, Table Handling  In RDBMS more than one table can be tac...

Table Handling  In RDBMS more than one table can be tackled at a time by using join operation. Join operation is a relational operation that causes 2 tables with a common domai

Illustrate the deployment diagram, Illustrate the Deployment Diagram A...

Illustrate the Deployment Diagram A deployment diagram shows all nodes on network, their processor execution and interconnections. In a dynamic model, this is used to represen

What is object oriented model, What is Object Oriented model? This mod...

What is Object Oriented model? This model is based on collection of objects. An object has values stored in instance variables with in the object. An object also having bodies

What is a data dictionary, What is a data dictionary?  A data dictionar...

What is a data dictionary?  A data dictionary is a data structure which keeps Meta data about the structure of the database i.e.  the schema of the database.

Explain different types of keys and relational model., Relational Model: T...

Relational Model: The relational model uses a collection of tables to represent both data and the relationships among those data. Each table has multiple columns and each column h

What is a recovery scheme, What is a recovery scheme? An integral part ...

What is a recovery scheme? An integral part of a database system is a recovery scheme that can restore the database to the reliable state that existed before the failure.

Objectives of database manangement system, OBJECTIVES After going thro...

OBJECTIVES After going through this unit you should be capable to: Explain the File Based system and its limitations; Explain the structure of DBMS; Explain the

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd