For database design, which of the following two options, will be better? What will be pros and cons?
1) For a field like 'Designation' using varchar(), and giving actual values like, Driver, Mechanic and Electrican.
or
2) Using integer say, 1 for Driver, 2 for Mechanic and 3 for Electrician.
Google for "Data Normalization".
Use the second option. The first option is not in second normal form (2NF) - the cons [there are no pros] are well discussed in any literature about the Relational Calculus and normal forms.
-- Regards, Varun Varma --------------------------------------- Mindframe Software & Services Pvt. Ltd. http://www.mindsw.com ---------------------------------------
------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
