homepage Welcome to WebmasterWorld Guest from 54.227.215.140
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Is SQL similar to 'formal logic'?
Makaveli2007

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 3630302 posted 4:36 am on Apr 19, 2008 (gmt 0)

I assume for databases 'logical thinking' is important. However, I think there are different forms of logical thinking:

1) logic riddles (I think the hard part here is often more coming up with the right idea to look at it in the first place and the logical thinking afterwards isn't overly difficult)

2) formal logic (or pure logical thinking?) --> The neighbor has a cat, that cat likes mice, the third neighbor eats mice, what can the wife of the neighbor who doesn't like cats, but has three mice, one of those mice is 7 and the product of the ages of the mice is 42, whereas their sum is xyz do so the cat only eats the youngest mouse (blabla you get the idea lol)

Is SQL similar to this 'formal logic' stuff? I looked at a few of the SQL problems in this forum and it seems to me that this is the main thing one needs to have for SQL - would you agree?

thanks!

P.S.: Yes, I'm a bit crazy and possibly to curious, I know!;)

 

syber

10+ Year Member



 
Msg#: 3630302 posted 2:56 pm on Apr 22, 2008 (gmt 0)

I don't agree that "formal logic" skill is important for SQL.

I have found in teaching SQL that the greatest difficulty is in changing one's thinking from procedural (one row at a time) to thinking in terms of sets. Once you can start thinking about data as interrelated sets, SQL becomes fairly easy to use.

Makaveli2007

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 3630302 posted 7:15 pm on Apr 27, 2008 (gmt 0)

So it's important to be a "systems thinker" when it comes to SQL?

mjwalshe

5+ Year Member



 
Msg#: 3630302 posted 10:20 am on May 12, 2008 (gmt 0)

predicate logic is what you are looking for for that is the mathamatics of Sets.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved