|
|
2NF ==>
database normalisation
<database> A series of steps followed to obtain a database
design that allows for efficient access and storage of data
in a relational database. These steps reduce data
redundancy and the chances of data becoming inconsistent.
A table in a relational database is said to be in normal
form if it satisfies certain constraints. Codd's original
work defined three such forms but there are now five generally
accepted steps of normalisation. The output of the first step
is called First Normal Form (1NF), the output of the second
step is Second Normal Form (2NF), etc.
First Normal Form eliminates repeating groups by putting
each into a separate table and connecting them with a
one-to-many relationship.
Second Normal Form eliminates functional dependencies on a
partial key by putting the fields in a separate table from
those that are dependent on the whole key.
Third Normal Form eliminates functional dependencies on
non-key fields by putting them in a separate table. At this
stage, all non-key fields are dependent on the key, the whole
key and nothing but the key.
Fourth Normal Form separates independent multi-valued facts
stored in one table into separate tables.
Fifth Normal Form breaks out data redundancy that is not
covered by any of the previous normal forms.
http://www.bkent.net/Doc/simple5.htm.
[What about non-relational databases?]
(2004-05-19)
Try this search on OneLook / Google
Nearby terms:
database machine « database management system « database manager « database normalisation » database query language » database server » Data/BASIC
This article was derived from the Free Online Dictionary of Computers and is available under ther terms of the GNU Free Documentation License.
Intel Pentium 75MHz Socket 7 CPUIntel Pentium 75MHz Socket 7 CPU ** Intel Pentium 75MHz Socket 7 CPU **General Features:- Original Intel Pentium Classic- 75MHz- Socket 7- Ceramic PGA packaging- CPU OnlyCompatibility/Requirements/Disclosures:** Requirements *** Socket 7 Heatsink & Fan* Motherboard that supports 75MHz Pentium CPU's More ...
Slimline Twin Point Stylus and Pen ComboSlimline Twin Point Stylus and Pen Combo ** Slimline Twin Point Stylus and Pen Combo **A stylus and ball point pen for PDA's, its like having two pens in one. It features a convenient removable cap that protects the pen and a pocket clip for attachement to your PDA case or shirt! Order today!!General Features:- Dual function ball point pen and stylus in one- Removable cap protects pen- Metal pocket clip and stainless steel barrel- Fits securely inside compact PC companion stylus port- Fits securely inside Casio Cassiopeia Pocket PCUnit Dimensions:- 4.75 x .25 x .25-inches (H x W x D)Notes:- UPC: 0 92636 10600 3 Compatibility/Requirements/Disclosures: ** Requirements *** Compact PC companion stylus port* Casio Cassiopeia Pocket PC More ...
Intellivision Greatest Hits: 20th Anniversary EditionIntellivision Greatest Hits: 20th Anniversary Edition The 1980s saw the dawn of the home video game system. One of the most popular was INTELLIVISION - Intelligent Television! Rediscover what the frenzy was all about with 25 of their greatest hits, faithfully recreated for your computer. Windows 98/ME/2000/XP and Mac More ...
Seagate Cheetah 9.1GB 10K RPM Ultra 160 SCSI HDDSeagate Cheetah 9.1GB 10K RPM Ultra 160 SCSI HDD ** Seagate Cheetah 9.1GB 10K RPM Ultra 160 SCSI HDD **Seagate presents its fourth generation of Cheetah products. This family of 10,000-RPM drives supports a capacity of 9.2 GBytes in a 3.5-inch form-factor for mainstream and high-performance users. Seagate has increased the Cheetah performance by 45 percent over the previous generation.General Features:- Capacity: 9.2 GB - Interface: 80 pin SCA SCSI Ultra160- Form factor: 3.5 x 1/3H - Spindle speed: 10000 rpm- Seek time: 5.2 ms - Data transfer rate: 160 MBps - Buffersize: 1MBNotes:- Drive onlyCompatibility/Requirements/Disclosures:** Requirements *** Available SCSI controller* Available 3.5-inch drive bay* Available 4-pin power connector* Available SCSI cable (Ultra160 recommended) -NOT Included More ...
Calendar Creator v 5.0Calendar Creator v 5.0 The world's #1 selling calendar-making software! Stay on top of your busy home and work schedules, keep your entire family organized, and more with Calendar Creator 5.0. Perfect software for creating and printing beautiful custom calendars... Get unlimited flexibility and ease-of-use in creating and printing calendars! Windows 95/98 More ...
Wireless Keyboard for PDA and SmartPhoneWireless Keyboard for PDA and SmartPhone ** Wireless Keyboard for PDA and Smart Phone **This SK6688 Wireless keyboard for PDAs and SmartPhone can help make your mobile lifeeasier! The infrared wireless covers up toa 210 degree area and features 67 full sizestandard keys and 10 programmable Hot Keys.Make your mobile life easier, get this Wirelesskeyboard for your PDA or SmartPhone!General Features:- Black and Silver- Wireless keyboard brings freedom and converience- Infrared wireless covers up to 210 degree area- Standard QWERTY layout- 67 Full Size Standard Keys- 10 dedicated Programmable Hot Keys- Key Height: 5.5 mm- Key Switch: Scissor type- Compatible with Palm OS, Windows CE/2002 Smartphone- Powered by One (1) AAA battery (included)Dimensions (Folded)- 5.6" x 3.7" x 1.02 (approximate inches)Dimensions (Open):- 11.4" x 3.7" x 0.4" (approximate inches)Compatible List:- Nokia: Model 6600, 7650- SonyEricsson: Model P800, P900- Samsung: Model i600- DELL: Axim X5 Series- HP: 3600 Series, 3700 Series, 3800 Series, iPaq H1920, Ipaq H1940, iPaq H2210, IPaq H4150 - Toshiba: e310, e330, e400, e740, e800- Palm: m500, m505, Palm VX, Zire 71, Tungsten T.T2.T3.E.C- Sony CLIE: PEG SJ30, NX70, NX73, PEG TJ25Regulatory Approvals:- FCC- CERetail Box includes:- SK6688 Smart Keyboard- Driver/Software CD- Quick Installation Guide- One (1) AAA batteryNotes:- Model: SK6688 Compatibility/Requirements/Disclosures: ** Requirements *** Windows 95/98/ME/NT/2000/XP* Compatible PDA* Compatible Smart Phone* CD-ROM drive (to load software) More ...
|
