data base and some constraints?

Question

it's simple to write a check constraint for validating male female for instance
but in a GUI it's simpler to specify a radio check box

the question is choose and with specifying reasons

Answer 1

I think I know what you are asking. Yes, it is easy to create a check constraint, and yes it is also easy to just present the user with a radio button. These two seem redundent.

The more validation you can have on data, the better off you will be. If that validation comes both with a UI and at the database level then that's okay too. This is especially true if the data in the database is ever going to be manipulated without using the UI.

Take it from those of us that learned the hard way. VALIDATE, VALIDATE and VALIDATE some more.