|
|
third normal form ==>
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.
4-Bay mATX Case w/230W PS/ Light/Handle (Black)4-Bay mATX Case w/230W PS/ Light/Handle (Black) ** 4-Bay mATX Charcoal Black Computer Case** This mATX computer case will provide the foundation to getyou started building a great computer system! This case comes in a sleek charcoal black design and a top handlefor easy transport! The front panel emits a cool neon bluelight when it's all fired up! It features four drive bays,four expansion slots, and a 230-watt power supply! Add thesystem board, expansion cards, and drives to get you started!!General Features:- Charcoal Black case design- Front case lights up blue neon light- Molded plastic top handle- Power button- Reset button- Two (2) USB ports at front of case- Front headphone and microphone jacks- Space saving design with matching standsDrive Bay Features:- One (1) 5.25-inch external drive bay- One (1) 3.5-inch external drive bay- Two (2) 3.5-inch internal drive baysExpansion Features:- Four (4) punchout expansion slotsSupported Form Factors:- mATXCase Supply Support:- Two (2) 60 mm fans on back of case (Not included)Power Supply Features:- Model: LP6100A- 230-watt power supply- 115v-230v manual switchPower Supply Input:- 115-230 VAC, 50-60 Hz, 3A/2.5A-> Power Supply Output:- +5V,18A- +3.3V,10A- -12V, 0.8A- +12V, 7A- +5Vsb, 2A- +5V and +3.3V total output = 123WCase Dimensions:- 15.5 x 5.25 x 14-inches (H x W x D)Package Includes:- 4-Bay Charcoal Black mATX Case- Screw Pack- Power Cord- Stands Compatibility/Requirements/Disclosures: ** Requirements *** Supported mATX motherboard* Rest of system* Available power outlet More ...
Dinosaur Hunter 1Dinosaur Hunter 1 This CD-ROM provides kids with everything they ever wanted to know about dinosaurs. As they explore the atmospheric corridors of this prehistoric museum, they can investigate huge 3-D models, watch fascinating animations, answer quiz questions, and much more!Windows 95/98/ME/2000/XP More ...
Intel PRO/100 CardBus II Type III LAN PC CardIntel PRO/100 CardBus II Type III LAN PC Card ** Intel PRO/100 CardBus II PC Card **This Intel MBLA3400 PRO/100 CardBus II PC Cardprovides Fast, Reliable LAN connections for mobile PCs with a Type III expansion slot!With a fast 10/100 Mbps data rate, and hot-swapcapability, this Intel PRO/100 will keep your notebook PC connected! Order yours today! General Features:- Type III CardBus- 10/100 Mbps Data Rate - 32-bit- Intel 82559 controller- 4KB On-board Memory - INTA Interrupt Levels - Bus-master DMA - Auto-run installation utility- Wired for Management 2.0- Full Duplex Capable - Auto-negotiation - Hot Swap capability Regulatory Approvals:- FCC- CERetail Box Includes:- Intel PRO/100 CardBus II PC Card- Software on CD-ROM- Quick Installation GuideNotes- Model: MBLA3400 Compatibility/Requirements/Disclosures: ** Requirements *** Windows 95/98/98SE/2000/NT4.0/ME/XP* Notebook with available Type III PC slot* CD-ROM Drive (to load software) More ...
96-CD/DVD Hard Plastic Carrying Case (Neon Blue)96-CD/DVD Hard Plastic Carrying Case (Neon Blue) ** 96-CD/DVD Hard Plastic Carrying Case **Protect CDs, DVDs and blank recordable discs with this handycase. The Non-woven fabric sleeves keepdirt away to prevent scratching the discs! The ruggedconstruction offers the best protection when traveling.General Features:- Sturdy neon blue press-proof plastic construction- 96-disc capacity- Durable zipper enclosure- Non-woven fabric sleeves Compatibility/Requirements/Disclosures: ** Requirements *** Need for this product More ...
Biostar M7VIG 400 Socket A ATX MB w/Sempron 2200+Biostar M7VIG 400 Socket A ATX MB w/Sempron 2200+ ** Biostar M7VIG 400 Socket A ATX Motherboard w/Sempron 2200+ CPU **Offer your customers this complete motherboard package! The Biostar M7VIG 400 socket A microATXmotherboard features the VIA KM266 Pro+ and VT8235 chipsets. Two 184-pin DIMM sockets support up to 2 GB DDR SDRAM. S3 UniChrome Pro 2D/3D Graphics with 64 MB shared video memory and integrated C-Media CMI9761A 6-Channel AC'97 CODEC is also included. Ethernet is controlled by the VIA VT6103 LAN. An AMD Sempron 2200+ socket Aprocessor is already included making this one quality motherboard package!General Features:- Socket A AMD Sempron 2200+ CPU INCLUDED- VIA KM266 Pro+ VT8235 chipset- Socket A- microATX form factor- 200/266/333 MHz system interface speed - Supports up to 2.0 GB DDR266/333/400 SDRAM- S3 UniChrome Pro 2D/3D Graphics - 64 MB Shared Memory - C-Media CMI9761A 6-Channel AC'97 CODEC - VIA VT6103 ethernet controllerExpansion Slots:- One (1) 4x AGP slot- Three (3) PCI slots- One (1) CNR slot- Two (2) 184-pin DIMM slotsI/O Ports:- Two (2) PS/2 ports- One (1) 9-pin Serial port- One (1) Parallel port- One (1) 15-pin VGA port- Two (2) USB ports- Mic in, Line in, Line out- One (1) RJ-45 ethernet jackHardware Monitor Function:- CPU/System Fan Speed - System Voltage - CPU/System Temperature Supported Processors:- AMD Athlon XP 3000+ (166 MHz) - AMD Athlon XP 2600+ (133 MHz) - AMD Sempron 2800+ (166 MHz) - AMD Athlon 1.4 GHz (133 MHz) - AMD Duron 1.8 GHz (133 MHz) - AMD Duron 1.3 GHz (100 MHz) Regulatory Approvals:- CERetail Box Includes:- Biostar M7VIG 400 Socket A ATX Motherboard- AMD Sempron 2200+ Socket A CPU w/Heatsink and Fan- Drivers and Utilities CD- Application Pack CD- User's Manual- One (1) 40-pin, 80-wire IDE cable- One (1) floppy disk cable- I/O shield Compatibility/Requirements/Disclosures:** Requirements *** ATX Case* ATX Power Supply* Supported RAM* Rest of system Informational Links:http://www.biostar.com.tw/products/mainboard/board.php3?name=M7VIG%20400%20(7.x) More ...
6-Foot 15-Pin Male To Female VGA Cable (Black)6-Foot 15-Pin Male To Female VGA Cable (Black) ** 6-Foot 15-Pin Male to Female VGA Cable **Use these heavy duty 6-foot cables to connect a standard VGA video card to your monitor with a VGA connector. Get yours today!General Features:- Black cable- 6-foot length- 15-pin male to female connector- Heavy duty cableNotes:- Cable only Compatibility/Requirements/Disclosures:** Requirements *** The need fo this cable More ...
|
