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