On 21/04/04 14:40 +0530, H S Rai wrote:
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.
If you can perceive that field 'Designation' will not be used in other tables then go for 1 if not then go for 2. Also have a look at oracles default/sample tables/database. I think they were/are called emp, dept etc.
-Krishna
------------------------------------------------------- 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
