What are the dbms languages, Database Management System

Assignment Help:

What are the DBMS languages? Briefly explain?

Data Definition language (DDL):A database schema is specified through a set of definitions expressed through a special language called data definition language. For instance, the subsequent statement in the SQL describes the account table

Create table account (account_number char(10), balance integer)

Execution of the above DDL statement creates the account table. DDL permits a user to specify storage structure and access techniques used through the database system as well as specify certain consistency constraints such as balance of an account should on fall below Rs1000.

Data Manipulation language (DML): A data-manipulation language (DML) is a language which enables users to access or manipulate data as organized through the appropriate data model.

There are basically two types:

1) Procedural DMLs needs a user to specify what data are required and how to get those data.
2) Declarative DMLs (also referred to as nonprocedural DMLs) need a user to specify what data are required without specifying how to get those data.


Related Discussions:- What are the dbms languages

Student, explain exhausitively the problems associated with er diagrams wit...

explain exhausitively the problems associated with er diagrams with ellustrations

What are the benefits of ooa technology, What are the benefits of OOA techn...

What are the benefits of OOA technology? Using OOA technology can produce many benefits, such as:  i) Reusability of code  ii) Productivity is gained through direct mappi

What is boyce-code normal form, Boyce-Code Normal Form (BCNF) A relatio...

Boyce-Code Normal Form (BCNF) A relationship is said to be in BCNF if it is already in 3NF and the left hand side of each dependency is a candidate key. A relation who is in 3N

Creating database for library, i need help with creating database system fo...

i need help with creating database system for a library

Define lock, Define lock? Lock is the most common used to execute the r...

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.

Properties of a transaction , Properties of a Transaction        A tra...

Properties of a Transaction        A transaction has four main properties. These are: Atomicity Consistency Isolation or Independence Durability or Permanen

Related fields in a database are grouped in which form, Related fields in a...

Related fields in a database are grouped in which form? Related data fields in a database are grouped to form a data record. (A record is a collection of related fields)

Database, 3. (10 points) Assume that you have been presented with the follo...

3. (10 points) Assume that you have been presented with the following relation for the Baxter Aviation database: Charters (Pilot#, Pilot name, Aircraft ID#, #seats, Village, Fligh

What is the use of group by clause, What is the use of group by clause? ...

What is the use of group by clause? Group by clause is used to be relevant aggregate functions to a set of tuples. The attributes given in the group by clause are used to shape

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