Application of the Standardization of the Relationship in the Database Design

Cai Xia Ma; Yan Min Wang

doi:10.4028/www.scientific.net/AMM.401-403.1809

Paper Titles

A WSN-Oriented Key Agreement Protocol in Internet of Things
p.1792

A High-Capacity Mobile Storage Device Data Protection Scheme
p.1796

An Enhanced Monte Carlo Localization Algorithm for Mobile Node in Wireless Sensor Networks
p.1800

An Improved PSO Algorithm of Optimizing Selection for Multi-Objective Controller Parameter
p.1805

Application of the Standardization of the Relationship in the Database Design
p.1809

Application of Virtualization Emulator in Network Environment
p.1813

Construction of Integrated Logistics Resources Service Platform Based on Cloud Computing
p.1817

Control Strategy of Energy Saving Based on Intelligence-Fusion in Water Supply Engineering
p.1822

Decay Analysis of a 5kW PEMFC Stack in Sightseeing Bus
p.1826

HomeApplied Mechanics and MaterialsApplied Mechanics and Materials Vols. 401-403Application of the Standardization of the...

Application of the Standardization of the Relationship in the Database Design

Abstract:

The library database design needs to accord certain rules, in relational database, this rule is paradigm. Paradigm is in line with a certain level of relational schema collections. Relational database relationship must meet certain requirements, namely to meet the different paradigms. At present, there are six kinds of relationship database paradigm: the first normal form (1NF), the second normal form (2NF), the third normal form (3NF), BC normal form (BCNF), the fourth normal form (4NF), the fifth normal form (5NF) and the sixth Normal Form (6NF). The 1NF is the minimum paradigm for requirement. Basing on the 1NF, further meeting more requirements is the 2NF and a higher level paradigm, in practical design application, you only need to reach the 3NF.