|
|
1NF ==>
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.
irock! 150VM 64MB MP3 Player and Voice Recorderirock! 150VM 64MB MP3 Player and Voice Recorder ** irock! 150VM 64MB MP3 Player and Voice Recorder **The irock! 150 VM is a great little companion that provides up to 18 hours of voice storage or 1 hour of MP3 in any combination. With 64MB of built-in memory, USB interface, voice operated recording, digital clock, and alarm. The irock! 150VM fits easily in your hand, and slips into a purse or pocket and is useful at work, school, or the gym.General Features:- Silver aluminum construction- 64MB internal memory- Voice operated recording- Built-in alarm clock- Built in speaker- Microphone and headphone jacks- EL backlighting and time/date stamping- 5 mode equalizer for MP3 music files- Up to 18 hours of voice recording timeSpecifications:- Flash based memory- USB Interface - Stereo Output- Bass Boost- Built-in Digital clock- Battery level indication- Hold button- Voice activated- Microphone sensitivity selection- Built-in LCD displayEqualizer Settings: - Normal- Bass Boost- Rock- Jazz- ClassicRegulatory Approvals:- FCCRetail Package Includes: - irock! DigitalVoice Recorder and MP3 Player- USB cable- Stereo earphones- Hand strap- Driver CDNotes: - Model: 150VM- UPC: 6 79437 30101 3 Compatibility/Requirements/Disclosures: ** Requirements *** Pentium 166MHz or higher* Windows 98SE/Me/2000XP* 64MB available RAM (recommended)* USB port Internet access (recommended)* Sound card* CD-ROM 4x or higher More ...
PlatoonPlatoon Control an entire platoon through missions based on historical events in the Vietnam War from 1965 to 1968. Manage up to 30 soldiers, plus tanks, helicopters and trucks. Dynamic weather and changing terrain affect your soldiers' abilities, forcing you to improvise on the battlefield. Windows 98/ME/2000/XP More ...
Intel Celeron 500MHz 66MHz 128KB Socket 370 CPUIntel Celeron 500MHz 66MHz 128KB Socket 370 CPU ** Intel Celeron 500MHz 66MHz 128KB Socket 370 CPU **- Intel Celeron 500MHz- PPGA Socket 370- 128K Cache - CPU Only (Heatsink and Fan NOT Included) Compatibility/Requirements/Disclosures:* Motherboard that supports Celeron 500MHz CPUs* Socket 370 Heatsink & Fan More ...
FireWire Cable 6-pin to 6-pin Cable - 6-FootFireWire Cable 6-pin to 6-pin Cable - 6-Foot ** 6-pin to 6-pin Firewire Cable - 6 Foot **Firewire, also called i.Link or IEEE 1394, is fast becoming the interface of choice for all the cool, must-have geek gadgets like digital video cameras, portable external hard drives, high speed external CDRW drives and the newest portable MP3 players like the iPod. But what good are these devices if you can't transfer data to and from them with your computer? That's where these high-quality 6-pin to 6-pin Firewire cables come in! At 6 feet long, you have plenty of room to run the cable where you need it! General Features:- Standard Firewire cable- 6-pin to 6-pin type (Male to Male)- 6 feet longNotes:- Cable only Compatibility/Requirements/Disclosures: ** Requirements *** FireWire port and device to connect with More ...
3-Piece 2.1 Channel MultiMedia Speaker System3-Piece 2.1 Channel MultiMedia Speaker System ** 3-Piece 2.1 Channel MultiMedia Speaker System **This SP-330 3-piece 2.1 Channel MultiMedia SubWoofer Speaker system is ideal for audio sources such as a Walkman, Cassette Player, CD-Player, Sound card, MP3 players and more! Order yours today!General Features:- Silver profile- Active separating circuits for frequencies- Reinforced module structure- Magnetically shielded- Rotating satellite speakers- In-line remote control- 120 – 240 V~ 50/60 Hz power specificationsSpecifications:- Frequency Response: 40 Hz - 160 Hz (SubWoofer),- 4-inch driver subwoofer - Frequency Response: 100 Hz - 20 KHz (Satellite)- Two (2) 2.5-inch full range driver- One (1) 2-inch tweeter- Control Panel: Power/VolumeSize:- Two (2) Satellite Speakers: 3.5 x 9.25 x 3.5-inches (W x H x L approximate)- One (1) SubWoofer: 5.5 x 9.5 x 10.75-inches (W x H x L approximate)Package Includes:- One (1) SubWoofer Speaker Unit- Two (2) Satellite Speakers- Manual Compatibility/Requirements/Disclosures: ** Requirements *** Audio source with stereo mini-din jack* Available power outlet More ...
2-Piece MultiMedia Speaker System - 2 for $6.992-Piece MultiMedia Speaker System - 2 for $6.99 ** 2-Piece MultiMedia Speaker System - 2 for $6.99 **This 2-Piece MultiMedia Speaker System delivers richhi-fidelity sound in a sleek compact design! It features two 2 x 3.5 drivers and includes headphone jack, and power and volume controls! This MultiMedia Speaker System is perfect for your desktop or laptop computers, portable games, MP3s, or CD players!General Features:- Beige color- 2 speakers- Amplified MultiMedia Speaker System - Two (2) 2 x 3.5 drivers- 8 Ohm load impedance- 110 Hz - 18 kHz frequency response- 0.5W output power per channel- Power/Volume control- LED indicator- Heaphone jackUnit Dimensions:- 7.09 x 2.83 x 4.33-inches (H x W x D)Retail Package Includes:- 2-Piece Amplified MultiMedia Speaker System- Manual- AC adapter (120VAC, 60Hz; 6.0V AC 200mA) Compatibility/Requirements/Disclosures:** Requirements *** 3.5 mm stereo jack* Available power outlet More ...
|
