Advanced Database Management System - Tutorials and Notes: Codd's Twelve Rules - Rule 5 - Comprehensive Data Sublanguage Rule

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

Wednesday, 18 February 2015

Codd's Twelve Rules - Rule 5 - Comprehensive Data Sublanguage Rule


Codd's Twelve Rules - Rule 5 - Comprehensive Data Sublanguage Rule



Rule 5
Comprehensive Data Sublanguage Rule
Rule
A relational system may support several languages and various modes of terminal use. However, there must be at least one relational language that has a linear syntax, can be used both interactively and within application programs, supports data definition operations (including view definitions), data manipulation operations (update as well as retrieval), security and integrity constraints, and transaction management operations (begin, commit, and rollback).
Description
This rule insist the existence of SQL like language to manipulate data. Manipulation should involve all the above said things (highlighted in blue color).
Example
Transact-SQL satisfies the manipulation in SQL Server,
SQL satisfies the data manipulation in Oracle and
MySQL support a subset of ANSI SQL.
Some DBMS that fulfills this property
T-SQL in SQL Server, SQL in Oracle, ANSI SQL in MySQL, SQL in IBM DB2




No comments:

Post a comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents