What is dml (data manipulation language)?, Database Management System

Assignment Help:

This language that enable user manipulate to or access data as organized by appropriate data model.

Low level or Procedural DML: DML needs a user to specify what data are required and how to get those data.
High level or Non-Procedural DML: DML needs a user to specify what data are required without specifying how to get those data.

639_DML data manipulation language.png

Related Discussions:- What is dml (data manipulation language)?

Management information system, management information system based on funct...

management information system based on functional organisation

Explain the fourth normal form, Fourth Normal Form (4NF) When attribut...

Fourth Normal Form (4NF) When attributes in a relation have multi-valued dependency, further Normalization to 4NF and 5NF are needed. Let us first find out what multi-valued d

Get details of employee working on both comp354 and comp345, Consider the r...

Consider the relations EMPLOYEE(emp#, name) ASSIGNED_TO(project#, emp#) PROJECT(project#, project_name, chief) Express the subsequent queries in Relational Algebra (i) Ge

How do you find the final model after iterative analysis, How do you find t...

How do you find the final model after iterative analysis? Why is iterative analysis of any of the problem needed? The final model serves as the base for system architectur

Class&object, deffine class&object

deffine class&object

Explain how the object classes are mapped to tables, Explain how the object...

Explain how the object classes are mapped to tables. Each object class maps to one or more than one tables in the database. The objects in the class may be partitioned horizont

Serialisable schedules, Serialisable Schedules: If the processes of two tra...

Serialisable Schedules: If the processes of two transactions conflict with each other, how to verify that no concurrency related problems have happened? For this, serialisability t

Explain dynamic two-phase locking, Explain Dynamic Two-Phase Locking H...

Explain Dynamic Two-Phase Locking Here a transaction locks a data item instantly earlier than any operation is applied on the data item. After finishing all the operations on

What is hash file organization, What is hash file organization? What are t...

What is hash file organization? What are the causes of bucket overflow within a hash file organization? What can be completed to decrease the occurrence of bucket overflow?

How many levels can be viewed architecture of the database, How many levels...

How many levels can be viewed in Architecture of the database ? Architecture of the database can be viewed as three levels.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages