homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Is SQL similar to 'formal logic'?

 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?


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



 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.


 7:15 pm on Apr 27, 2008 (gmt 0)

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


 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