answersLogoWhite

0

the traditional database do not follow these rulesDr. E. F. Codd's 12 rulesfor defining a fully relational database

Note that based on these rules there is no fully relational database management system available today. In particular, rules 6, 9, 10, 11 and 12 are difficult to satisfy.

  1. Foundation Rule

    A relational database management system must manage its stored data using only its relational capabilities.

  2. Information Rule

    All information in the database should be represented in one and only one way - as values in a table.

  3. Guaranteed Access Rule

    Each and every datum (atomic value) is guaranteed to be logically accessible by resorting to a combination of table name, primary key value and column name.

  4. Systematic Treatment of Null Values

    Null values (distinct from empty character string or a string of blank characters and distinct from zero or any other number) are supported in the fully relational DBMS for representing missing information in a systematic way, independent of data type.

  5. Dynamic On-line Catalog Based on the Relational Model

    The database description is represented at the logical level in the same way as ordinary data, so authorized users can apply the same relational language to its interrogation as they apply to regular data.

  6. Comprehensive Data Sublanguage Rule

    A relational system may support several languages and various modes of terminal use. However, there must be at least one language whose statements are expressible, per some well-defined syntax, as character strings and whose ability to support all of the following is comprehensible:

    1. data definition
    2. view definition
    3. data manipulation (interactive and by program)
    4. integrity constraints
    5. authorization
    6. transaction boundaries (begin, commit, and rollback).
  7. View Updating Rule

    All views that are theoretically updateable are also updateable by the system.

  8. High-level Insert, Update, and Delete

    The capability of handling a base relation or a derived relation as a single operand applies nor only to the retrieval of data but also to the insertion, update, and deletion of data.

  9. Physical Data Independence

    Application programs and terminal activities remain logically unimpaired whenever any changes are made in either storage representation or access methods.

  10. Logical Data Independence

    Application programs and terminal activities remain logically unimpaired when information preserving changes of any kind that theoretically permit unimpairment are made to the base tables.

  11. Integrity Independence

    Integrity constraints specific to a particular relational database must be definable in the relational data sublanguage and storable in the catalog, not in the application programs.

  12. Distribution Independence

    The data manipulation sublanguage of a relational DBMS must enable application programs and terminal activities to remain logically unimpaired whether and whenever data are physically centralized or distributed.

  13. Nonsubversion Rule

    If a relational system has or supports a low-level (single-record-at-a-time) language, that low-level language cannot be used to subvert or bypass the integrity rules or constraints expressed in the higher-level (multiple-records-at-a-time) relational language.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What are the features of traditional management?

What are the features of traditional management


What are the features of Database?

mail merge


What are the features of foxpro?

There are many features of FoxPro, same with other programming language it depends on what application you will build. Let me give you an outline of the features of Microsoft Visual FoxPro. Database Local Database LAN Database SQL Database Server Type Window DOS Tables/View Local Remote


Database approach VS traditional approach?

Database Approach vs. Traditional File ProcessingSelf contained nature of database systems (database contains both data and meta-data).Data Independence: application programs and queries are independent of how data is actually stored.Data sharing.Controlling redundancies and inconsistencies.Secure access to database; Restricting unauthorized access.Enforcing Integrity Constraints.Backup and Recovery from system crashes.Support for multiple-users and concurrent access.


What security features of the operating system can be used to simplify the design of the database management system?

A)What security features of the operating system can be used to simplify the design of the database management system?


Database Application Development?

form_title=Database Application Development form_header=Once you have your database, you will need apps to make your business run smoother. What is your budget for the development?=_ What features do you want on your database application?=_ Why do you want to develop a database application?=_


Features of distributed database?

distributed data base means noting


What is the features homogeneous database?

Its primary feature would be setting up a database link between Oracle and another database such as SQL Server. Homogeneous database links are set up as new listeners which can be referred to in your TNSnames.


What is the traditional Danish dish that features the keyword g?

The traditional Danish dish that features the keyword g is ggekage, which is a type of Danish omelette.


Database properties are also known as?

Database properties are also known as database attributes or characteristics. These properties describe the features and characteristics of the database, such as data types, constraints, relationships, and indexing among others. They are essential for defining the structure and behavior of a database system.


Web Databases?

form_title=Web Databases form_header=Improve your workflow with databases created specifically for your business! What do you want your database to be used for?=_ What specific features do you want in your database?=_ How many employees will be access this database?=_


What is a traditional Italian pastry that features lobster tail as a key ingredient?

A traditional Italian pastry that features lobster tail as a key ingredient is called "sfogliatella."