[Year 12 IT Apps] Boolean?

[Mark]

True Boolean data should be true/false, since they are stored as zero
(false) or non-zero (true) bits, not as text.

But other binary options can happen if you encode the data appropriately,
e.g. using IsMale or IsFemale would allow a nice, normal Boolean response
to the gender question.

But, to complicate matters, some databases (like Filemaker) let you choose
how true Boolean values are displayed (e.g. M/F, True/False, Yes/No).

So it does get murky.
I wish ITA exams would keep well away from such murky, argumentative, iffy
issues and stick to the clear and obvious key knowledge.

Mark


On 7 November 2014 15:06, Christopher Jansen <
Christopher.Jansen at sjc.vic.edu.au> wrote:

>  I think you can use boolean as a data type to describe any field with
> just two options..
>
> I would say you can use it for male / female... It would make the database
> more efficient.
>
>
>
> Thanks,
>
> Chris
>
>
>
>
>
> *From:* itapps-bounces at edulists.com.au [mailto:
> itapps-bounces at edulists.com.au] *On Behalf Of *Simone Tynan
> *Sent:* Friday, 7 November 2014 2:25 PM
> *To:* itapps at edulists.com.au
> *Subject:* [Year 12 IT Apps] Boolean?
>
>
>
> Hi everyone.
>
>
>
> Is it safe to talk yet??
>
> I have told my students that boolean data type is ‘true/false’. We
> discussed how M or F (male or female) is text, not boolean.
>
> The exam, question 5 has Travel-style or Business-style (T or B) as
> boolean. Have I taught my students incorrectly?
>
>
>
>
>
> With thanks,
>
>
>
>
>
>
>
> --

Mark Kelly
mark AT vceit DOT com
http://vceit.com

*I love the sound of people's voices after they stop talking.*

I, Mark Kelly, am entirely responsible for the offensive verbiage I spew
forth.
Have I offended anyone with this post?  I would not be surprised.
If offended, please whinge to me at the email address above.
Please leave poor Kevork alone.  It is not his fault.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20141107/247c4659/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 53605 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20141107/247c4659/image001-0001.png