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