|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 17th, 2005, 12:49 PM
|
|||
|
|||
Normalization
How can i normalised my data to 1NF, 2NF and 3NF using excel.
|
|
#2
October 17th, 2005, 01:46 PM
|
|||
|
|||
|
Normalization
Normalizations usually involve the transformation of data in the format
y=a*x+b Let's put you a-factor in A1 and your b-factor in B1. If your raw data is in C1 thru C100, then in D1 enter: =$A$1*C1+$B$1 and copy down -- Gary's Student "Jar" wrote: How can i normalised my data to 1NF, 2NF and 3NF using excel.
|
|
#3
October 17th, 2005, 05:03 PM
|
|||
|
|||
|
Normalization
Excel isn't a database, so it doesn't support relational database concepts.
(assume 1NF means first normal form and so forth as defined by Codd). -- Regards, Tom Ogilvy "Jar" wrote in message ... How can i normalised my data to 1NF, 2NF and 3NF using excel.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Questions on database design and normalization | Charles W. Stricklin | Database Design | 2 | September 1st, 2005 03:01 PM |
| Help! - Table design: Normalization and subclassing questions | stgpatrick | Database Design | 1 | May 12th, 2005 06:51 PM |
| I need help with normalization | Charles W. Stricklin | Database Design | 2 | May 10th, 2005 09:12 PM |
| Integrity concerns and the importance of normalization in database | whutareyou | General Discussion | 2 | April 29th, 2005 08:49 PM |
| Nasty Normalization for Newbie | Steve Hills | New Users | 4 | July 14th, 2004 03:21 PM |
Linear Mode
