|
|
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.
S-Video Out to Composite Out Cable-2 for $2.99S-Video Out to Composite Out Cable-2 for $2.99 ** S-Video Out to Composite Out Cable-2 for $2.99 **This cable converts an S-Video signal to a composite video signal. Use this cable to connect video cards to a TV orVCR, or any device with S-Video! This product comes in a bulk package.General Features:- 3-inch cable length- 4-pin S-Video male connector and RCA connector- Molded strain reliefs at both ends- Cable only Compatibility/Requirements/Disclosures:** Requirements *** Video card or other item with S-Video Out More ...
Intel PIII 650MHz 100MHz 256KB Slot 1 CPUIntel PIII 650MHz 100MHz 256KB Slot 1 CPU ** Intel Pentium III 650MHz 256KB 100MHz Secc 2 **- Standard Intel Pentium III Processor- 650 MHz- Slot 1, SECC2 Package- 100 MHz Bus Speed- 256KB L2 Cache - CPU Only Compatibility/Requirements/Disclosures:Note: CPU's are pulls More ...
Sharp VGA 9.4-Inch Mono LCD LM64P83LSharp VGA 9.4-Inch Mono LCD LM64P83L ** Sharp VGA 9.4-Inch Mono LCD LM64P83L **- Display size 9.4 - Brightness 65 cd/m 2 - Dot format (H x V) 640 x 480 dot - Duty ratio 1/240 - Dot pitch (H x V) 0.30 x 0.30 mm - Backlight type 1CCFT(E) - Active area (H x V) 192.0 x 144.0 mm - Power consumption 2 380 mW - Outline dimensions (W x H x D) 253.0(260.0)* 2 x 174.0 x 7.0 mm - Panel mode Transmissive - Weight 340 g - B/W - Operating temperature 0 to +45 C - Storage temperature -25 to +60 C - Response time 350 ms - Contrast Ratio 18:1 More ...
3.5-Inch Int Serial ATA HDD Enclosure (Beige)3.5-Inch Int Serial ATA HDD Enclosure (Beige) ** 3.5-Inch Serial ATA Drive Case **This drive case makes it easy to store and transportyour 3.5-inch Serial ATA hard drive. This internal case fitsany 5.25-inch drive bay, is hot-swappable and is easy toinstall.General Features:- Beige case- Supports 3.5-inch drives- Internal design- Serial ATA (SATA) interface- Removable drive bay- Serial ATA and 4-pin Molex power connectors- Simple installation- Cable-less connection- Fits any 5.25-inch drive bay- Plug and Play- Hot-swappableFront Panel Features:- Lock- Power button- Drive tray release button- Power LED indicator- HDD LED indicatorReat Panel Features:- 4-pin Molex power connector- Serial ATA power connector- Serial ATA data connectorRegulatory Approvals:- CERetail Package Includes:- 3.5-inch Serial ATA internal drive case- Screw pack- User's ManualNotes:- To open the drive, unlock the lock and press the releasebutton on the left side of the lock. Compatibility/Requirements/Disclosures: ** Requirements *** Serial ATA hard disk drive* Available Serial ATA or 4-pin Molex power connector* Available 5.25-inch drive bay More ...
GeForce PC5300TM 128MB GDDR3 16x PCI Express CardGeForce PC5300TM 128MB GDDR3 16x PCI Express Card ** GeForce PC5300TM 128MB GDDR3 16x PCI Express Video Card **Introducing GeForce PCX Mainstream PCI Express GPUs. The GeForce PCX 5300 GPUs deliver best-in class performance and features at a great price. With a GeForce PCX mainstream GPU inside your PC, you can experience cinematic-quality effects, studio-quality color, and the industry-leading performance and rock-solid driver stability you expect from NVIDIA. The only DirectX 9 compatible GPUs in their class, the GeForce PCX 5300 models are engineered for compatibility with the latest gaming and multimedia software.General Features:- nVidia GeForce PCX 5300 GPU- 16x PCI Express interface - 128 MB DDR memory- 128-bit memory interface- 350 MHz RAMDAC- 250 MHz core clock- 400 MHz memory clock- 6.4 GB/sec memory bandwidth- CineFX 3.0 Shading Architecture - 64-Bit Texture Filtering and Blending- Intellisample 3.0 Technology- UltraShadow II Technology - Advanced Video and Display Functionality - Advanced Display Functionality - Advanced Engineering - Nvidia Digital Vibrance Control (DVC) 3.0- Complete DirectX support, including the latest version of Microsoft DirectX 9.0 Shader Model 3.0 - Full OpenGL support, including OpenGL 1.5- Integrated HDTV encoder- Up to 3x Geometry performanceConnectors:- 15-pin VGA - DVI- S-VideoRegulatory Approvals:- FCC- CE- BSMIRetail Box Includes:- GeForce PC5300TM 16x PCI Express Video Card- User Manual- VGA driver on CD- InterVideo WinDVD Creator- Component/Composite/S-Video Out cableNotes: - Model: PC5300TM Compatibility/Requirements/Disclosures: ** Requirements *** Intel Pentium III, AMD Duron orAthlon CPU or higher* Windows95 OSR2/98/98Se/ME/NT4.0/2000/XP* 128 MB of RAM* 10 MB available hard disk space (50 MB for full installation* 250 watt min. / 300 watt recommended power supply* Available 16x PCI Express compliant slot or better* CD-ROM drive* Monitor with DVI-I, VGA or S-Video connector** Disclosures:* This card uses the new 16x PCI Express interface, please make sure that the motherboard that this card goes into has a PCI Express slot (most older boards will not have this type of slot). More ...
USB Travel Notebook Web Camera - 2 for $20USB Travel Notebook Web Camera - 2 for $20 ** USB Travel Notebook Web Camera - 2 for $20 **Explore the exciting world of Internet video conferencing in just minutes! It's that easy. This USB PC camera captures video on a PC, send it via e-mail, or go for a face to face chat! Plug it in, click, send... All in a manner of minutes!General Features:- USB 1.1 PC camera- Compact design- 15-inch flexible USB connection- 19.5-inches overall length- Auto white balance- Produce and store video- Hold live video conferencesCamera Specifications:- 300 k Pixels (software enhanced)- 100 k Pixel CMOS image sensor- 640 x 480 (VGA through software only)- 352 x 288 (CIF)- 176 x 144 (QCIF)- AVI file format- 24 fps frame rate - F2.4 Aperture- 2.9 mm Fixed lensRegulatory Approvals:- FCC- CERetail Package Includes:- USB PC camera- Software CD- Users Manual Compatibility/Requirements/Disclosures:** Requirements *** Windows 98SE/ME/2000/XP* 200 MHz CPU or above* 32 MB RAM or above* 125 MB free Hard drive space* CD-ROM* Available USB port More ...
|
