Three database paradigm

2010-10-20  来源:本站原创  分类:Java  人气:174 

The beginning of the database when the database is simply do not know what (the school which did not open, only learned C, Oh 。。。), So when the class is always in the tangled issue, and then went to see their own some information about the database.

In fact, the database file structure is stored in one series of information sheets, this file structure makes it possible to access these tables, select the table column to sort the table, and according to various criteria to select rows. Databases usually have multiple indexes and many of the columns in these tables is associated, so that we can quickly access these tables. As with the communications, construction database must follow certain rules (communication to follow certain protocols to achieve). In a relational database, this rule is the paradigm. Paradigm is consistent with the pattern of relationships of a set of levels. Relational database must meet a different paradigm, now has six relational database paradigm: the first paradigm (1NF), second normal form (2NF), third normal form (3NF), fourth normal form (4NF), Fifth Normal Form (5NF ), the sixth paradigm (6NF). The first normal form (1NF) is a relational database must be satisfied the minimum requirements for relational databases. In the first paradigm to further meet the additional requirements on the basis of the paradigm known as the second normal form (2NF), the rest of the paradigm and so on. Under normal circumstances, the database need only meet the third normal form (3NF) on it.

Here's a simple paradigm to talk about the first (1NF), second normal form (2NF), third normal form (3NF):

A first paradigm (1NF)

Paradigm of the so-called first (1NF) is the column for each database table the basic data items are indivisible, the same column can not have multiple values, that is, entities (objects with similar java classes) in the property can not have more than one value or can not have duplicate attributes. If repeated properties, you may need to define a new entity. In the first paradigm (1NF) tables contain only one instance of each line of information. The first paradigm (1NF) relational database can also be said of the atomic (each property values are no longer the smallest unit of data points.) In short, the first paradigm (1NF) is no duplication of columns.

In any relational database, the first paradigm (1NF) is the basic requirement of the relational model does not satisfy the first normal form (1NF) of the database is not relational databases.

Second, the second normal form (2NF)

Second normal form (2NF) is in first normal form (1NF) built on the basis that meet the second paradigm (2NF) must first meet the first paradigm (1NF). Second normal form (2NF) requires a database table or row for each instance must be the only distinction. Usually need to achieve distinction as a table with a column, a unique identifier for each instance storage (that is, we say that the primary key.)

Second normal form (2NF) requires an entity of the property is totally dependent on primary key (primary key). The so-called is not entirely dependent on the existence depends only on the primary key part of the property, if it exists, then this property and this part of the main keyword should be separated out to form a new entity, the new entity and the original is the one to many relationship between entities . In short, the second normal form (2NF) is not part of the non-primary properties depend on the primary key.

Third, the third normal form (3NF)

By the same token meet the third paradigm (3NF) must first meet the second paradigm (2NF). In short, the third normal form (3NF) requires a database table is not included in the table has been included in other non-primary key information. Third normal form (3NF), also known to eliminate indirect dependencies (which are not totally dependent on the primary key information, you can remove it.)

In short, the relationship between time to follow the database design database design paradigm. The first paradigm (1NF) is the most fundamental requirements, only if they meet the first paradigm (1NF), in order to achieve a variety of other paradigms.

相关文章
  • Database paradigm (1NF 2NF 3NF BCNF) Detailed II 2010-09-29

    Model applications A forum for us to gradually get the database, the following information: (1) User: user name, email, homepage, telephone, contact address (2) Posts: post title, post content, respond to the title, your reply The first time we desig

  • Three database paradigm 2010-10-20

    The beginning of the database when the database is simply do not know what (the school which did not open, only learned C, Oh ...), So when the class is always in the tangled issue, and then went to see their own some information about the database.

  • 1NF 2NF 3NF BCNF database paradigm 2010-10-30

    1NF 2NF 3NF BCNF database paradigm (From: http://www.itisedu.com/phrase/200604241410105.html) Design paradigm (paradigm, database design paradigm, the database design paradigm) is a level consistent with the pattern of relationships of a collection.

  • Understanding of the database paradigm 2010-11-07

    Database design, database paradigm is essential knowledge, no understanding of the paradigm, it is impossible to design efficient, elegant databases. Maybe even the wrong database. And want to understand and grasp the paradigm are not so easy. Genera

  • Database paradigm (1NF 2NF 3NF BCNF) Detailed one 2010-09-29

    Database design paradigm is needed to meet database design specifications to meet these specifications database is simple, clear structure, at the same time, does not occur insert (insert), delete (delete) and update (update) operation exception. On

  • Detailed explanation refer to the database paradigm 2011-02-12

    Detailed explanation refer to the database paradigm Database and Design 2009-07-04 15:31:40 Read 20 Comments 0 Word Count: Subscribe Quote The sea 's detailed explanation of the database paradigm T size = "2" color = "# ff0033"> whe

  • Database paradigm concept analysis (first normal form, second normal form, third normal form) 2011-02-22

    Paradigm: the English name is Normal Form, which is the British EFCodd (relational database of ancestors) in the 1970s after the conclusion of the relational database model made out of, the relational database paradigm is the basis of the theory, but

  • Database paradigm (rpm) 2011-03-23

    Currently we are using mainstream database is a relational database, so I recorded in the relational database paradigm some understanding of and views. Database library paradigm is divided into six (in fact there is a BCNF), respectively, from first

  • The definition of the database paradigm [excerpt] 2010-07-14

    The first paradigm (1NF) is the database table for each column of basic data items are indivisible, the same column can not have more than one value, that entity can not have more than one attribute value or can not have duplicate attributes. The sec

  • Database paradigm (1NF 2NF 3NF BCNF) A Detailed 2010-09-29

    Database design paradigm is needed to meet database design specifications that meet these specifications of the database is simple, clear structure, while the insertion does not occur (insert), delete (delete) and update (update) operation exception.

  • Three instances of the database paradigm 2010-12-29

    The first paradigm: the elimination of duplication of the group, that column is stored in other columns of information (field no longer points) The second paradigm: the elimination of partially dependent on the column, that is whether there is depend

  • (Database paradigm) first normal form (1NF): The second paradigm (2NF): third normal form (3NF) 2011-05-30

    The first paradigm (1NF) Unique Columns column without repeating The first paradigm (INF) for each database table column basic data items are indivisible; in the first paradigm (1NF) tables contain only one instance of each line of information. In sh

  • Database paradigm (reproduced) 2011-07-28

    Database design criteria (first, second, third normal form description) I, 1.1 relational database design paradigm introduced the first paradigm (1NF) no repeat of the column The so-called first paradigm (1NF) is the database table for each column of

  • Database paradigm (1NF 2NF 3NF BCNF) Detailed two 2010-09-29

    Paradigm Application We gradually get to a forum's database, the following information: (1) User: user name, email, homepage, phone, address (2) Posts: post title, post content, respond to the title, your reply We will first design for the mere exist

  • Database paradigm to understand 2011-06-17

    Paradigm for the understanding of the database has been a difficult, but the paradigm, it is quite abstract, but understanding the theory, but it is so simple. The first paradigm (1NF) In fact, the first paradigm refers to a database table for each r

  • Several database paradigm 2010-05-24

    1. 1NF Entity's property can not be re-divided data items. 2. 2NF Satisfy the 1NF and every non-primary property entirely dependent on the code. For example: Students (Student ID, the host system, address, course number, results), the students agreed

  • Three simple database paradigm 2010-05-24

    The first paradigm: the first paradigm is no repeat of the second and Paradigm: Paradigm is the second part of non-primary property of non-dependent on primary key third paradigm: The third paradigm is the property does not depend on other non-primar

  • Three brief database paradigm 2010-08-15

    1, 1NF: the field can not be separated; Second, 2NF: a primary key, primary key and non-primary key does not exist between some functional dependency; 3, 3NF: non-primary key field does not exist between the transmission dependence; Explained: 1, Tab

  • 9 referring to the next database paradigm: the classification of design patterns 2011-04-18

    1.1 First Normal Form (1NF) without repeating columns such as the oracle of the date type, month, day general will / time put together a field. 1.2 Second Normal Form (2NF) is totally dependent on the primary key attribute [remove part of the subrout

  • Three simple version of the database paradigm 2010-06-21

    1, no duplicate columns 2, the only primary key 3, atoms of (Column does not depend on other non-primary key column)