Finally and surprisingly, I managed to get my wireless network to work for Fedora Core 6 on my Dell D620 laptop. The setup procedures have been long and tedious somewhat, which includes installing drivers, daemon as well as configuring the wireless profile. For the sake of making a note so that I won't have to google again whenever I have to repeat the task, here's the steps I've taken:
1) Download (you can get them all from this website) and install the IntelĀ® PRO/Wireless 3945 network adaptor RPMS packages for Zod(*1) (yes! packages, alltogether 3 modules), which are ipw3945d (the daemon), ipw3945-firmware (the firmware of the adaptor) and dkms-ipw3945 (the driver) respectively. Note that the order is very important as they are actually depending on each other in sequence, where the order is kind of weird though. Installing RPMS is easy, just double click it on your Gnome desktop(*2).
2) Restart the machine, by then you should see the driver is automatically listed under the Hardware tab at Network Configuration (you can launch this by selecting System -> Administration -> Network from the gnome application panel with root access). Then you can add the wireless profile under the Devices tab, unlike Windows, there is no wireless network auto-detection therefore we have to put in the wireless parameters such as SSID, channel and so on by hand. If you are not lucky enough to see the driver appears under the Hardware tab, don't be panic. I came across that too, just issue the command (in console of course) "modprobe ipw3945" and you will probably see it right away. In case modprobe command is not in your path, it is under /sbin directory.
3) Well, almost done, what we need to do now is just activating the device (under Devides tab), and here you go.
*1 - Zod is the codename of Fedora Core 6
*2 - Assuming you've chosen Gnome as your desktop, though I believe it won't be having much different on KDE