Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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
Define lock? Lock is the most common used to execute the requirement is to permit a transaction to access a data item only if it is currently holding a lock on that item.
Client Server Databases- The concept behind the Client/Server systems is simultaneous, cooperative processing. It is an approach that presents a one systems view from a user's vie
A software contract and consultancy firm maintains details of all the various projects in which its employees are currently involved. These details comprise: Employee Numbe
Define Network DBMS The NDBMS is built primarily on a one-to-many relationship, but where a parent-child representation between the data items cannot be ensured. This may occur
What is meant by software and hardware RAID systems? RAID can be executed with no change at the hardware level, using only software modification. Such RAID implementations are
it can be possible to create any table without primary key
1) Information about a bank is about customers and their account. Customer has a name, address which consists of house number, area and city, and one or more phone numbers. Ac
What disadvantage of ODBC does OLE DB overcome? By breaking the features and the methods of a DBMS into COM objects, OLE DB characteristic overcomes a main disadvantage of ODBC
Can we delete data element, which is being used by table fields. No we cant delete data element.
What is the aim of logical schema ? The main motive of the logical schema is to ensure the portability of procedures and models on various physical schemas at runtime.
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!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd