|
|
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.
WinFax Pro 10.03 OEMWinFax Pro 10.03 OEM ** WinFax Pro 10.03 OEM **WinFax PRO V10.03 is the leading fax management software for small businesses. Its high-quality faxes help you project a professional image to your clients and customers. When image clarity is vital, you can generate photo-quality faxes. You can even send or forward faxes via email to people who don’t have fax hardware or software. (Requires a free viewer available for download here.) WinFax PRO is easy to set up, learn, and use. And it integrates smoothly with key business applications to simplify your management of client and customer interactions.- System Requirements:Minimum processor: Pentium 166MHz processor for Windows 98, Me, NT and 2000, Pentium 233MHz processor for Windows XP Operating system: Windows 2000 Professional, Windows XP Professional, Windows 98, Windows NT Workstation V4.0, Windows XP Home, Windows Me Millennium Edition.- Minimum Memory Requirements: 32MB for Windows 98, and Me , 64MB for Windows NT, 2000 and XP Recommended memory requirements: 128MB for Windows NT, 2000 and XP , 64MB for Windows 98 and Me Status: Complete User: ruthnie - Minimum Disk Space Requirements: 57MBNotes:- Picture is for representational purposes only- OEM CD ONLY More ...
HP 52x 700MB 80-Minute CD-R Media 200-PackHP 52x 700MB 80-Minute CD-R Media 200-Pack ** HP 52x 700MB 80-Minute CD-R Media 200-Pack **This HP 100-pack CD-R media makes burning discs easy!Featuring 700 MB data storage, 80 minutes of digital audio and a maximum 52x recording speed, disc creationonly takes minutes! General Features:- HP branded CD-R media- 80-minute audio capacity- 700 MB data capacity- Rated for use with 52x speeds - Separated into handy 50 piece cake packs- Easy carry boxNotes:- 200-piece case- P/N: CR00045- UPC: 6 37668 10031 7 Compatibility/Requirements/Disclosures: ** Requirements *** CD-R/RW drive More ...
3 Compartment Wheeled Travel Case w Portfolio3 Compartment Wheeled Travel Case w Portfolio ** 3 Compartment Wheeled Travel Case w Portfolio **General Features:- Rolling laptop case and portfolio.- Separate suspended and padded area for your computer.- Ample room for cables and other accessories.- External side pouch thats great for the power supply brick.- Two front outside compartments and front mounted zippered areas for small papers, tickets, reciepts, etc.- Computer area 12.5 x 1 x 10 .Notes:- New More ...
HP 52x 700MB 80-Minute CD-R Media 50-Piece SpindleHP 52x 700MB 80-Minute CD-R Media 50-Piece Spindle ** HP 52x 700MB 80-Minute CD-R Media 50-Pack **Create CDs in minutes with the Hewlett Packard CD-R media!It features 700 MB data storage, 80 minutes of digital audio and a maximum 52x recording speed. Get yours today!-General Features:- 50-Pack- 80-minute audio capacity- 700 MB data capacity- Rated for use with 52x speedsNotes:- Media Only Compatibility/Requirements/Disclosures: ** Requirements *** CD-R/RW drive More ...
Magic Mirror MultiMedia WorkstationMagic Mirror MultiMedia Workstation ** Magic Mirror MultiMedia Workstation **Great for an Office, Home or School! Easily add additional workstations with full multimedia functionality to an existing PC. This MultiMedia Workstation includes two USB ports, two PS/2 ports, and Microphone and Headphone in jacks! Also included is an ATI Rage 128 GL 32 MB PCI Video card! The included 9-foot long USB A to B cable makes it easy to connect peripherals. Just add PS/2 keyboard, mouse, monitor and speakers! MultiMedia Workstation Features: - One (1) USB-B Uplink port - Two (2) USB-A 2.0 ports - Two (2) PS/2 ports - Microphone in jack - Headphone in jack LEDs: - Power - PS/2 - PS/2 - USB - USB PCI Display Card Features: - ATI Rage 128GL GPU - 32 MB memory - PCI interface - 15-pin VGA port Regulatory Approvals; - FCC - CE - VCCI - C-Tick Retail Box Includes: - MultiMedia Workstation - PCI Video Card - 9-foot USB A-B cable - Power Adapter (100-240V ~ 50-60Hz) - Installation Driver CD - User Guide Compatibility/Requirements/Disclosures:** Requirements *** 500MHz CPU or above * Windows 2000/XP * Available USB port * Available Power Outlet 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 ...
|
