so, awesome books

Discussion in 'Space Junk' started by ijffdrie, Nov 15, 2009.

so, awesome books

Discussion in 'Space Junk' started by ijffdrie, Nov 15, 2009.

  1. ijffdrie

    ijffdrie Lord of Spam

    Joined:
    Aug 23, 2007
    Messages:
    5,725
    Likes received:
    17
    Trophy points:
    38
    so, for school i am gonna make an SQL database in, and i am gonna make it about books. So i'll need suggestions for some awesome books to put in it(comics are also welcome, i made a different table for those).

    Of course kevin j. anderson's and timothy zahn's star wars books. Maybe some work by lovecraft. The wheel of time and the saga of the seven suns. The hobbit, lord of the rings, and probably some other books in that universe. watchmen by alan moore, and the ultimates vol1 and vol2 by mark millar represent comics.


    any more suggestions?


    on a related note: mysql doesnt work on my pc, and i cant find any instructions for open office base. any other places i can try to get a DBMS?
     
    Last edited: Nov 15, 2009
  2. Kaaraa

    Kaaraa Space Junkie

    Joined:
    Sep 19, 2007
    Messages:
    1,335
    Likes received:
    3
    Trophy points:
    0
    From:
    United States
    So should the books only be LotRish fantasy, or...?
     
  3. Aurora

    Aurora The Defiant

    Joined:
    Sep 12, 2007
    Messages:
    3,732
    Likes received:
    15
    Trophy points:
    38
    From:
    The Netherlands
    Is this for Informatica?
    If it is, just ask for your teacher to make a separate folder for you on the school's server and get you an FTP account with access to your own folder. You can run Filezilla to connect to it from any computer you want. If mysql runs on your school's server, which it should, then you shouldn't have any problem getting it to work. Just upload your code files and voila. I did a similar project a few years ago when I had to build a website and a database for a 50 year reunion of old students from my former school. Pretty cool stuff.

    Edit: Also, you should probably visit www.isbn.nl

    Their database is now public, so you can just enter a publisher, which should give you a pretty huge list of books. :)
     
    Last edited: Nov 15, 2009
  4. ijffdrie

    ijffdrie Lord of Spam

    Joined:
    Aug 23, 2007
    Messages:
    5,725
    Likes received:
    17
    Trophy points:
    38
    yeah its for informatica. Also, what you just said broke my mind, were really just at starting query's.

    Also, finally got ms access.

    and, whats wrong with the syntax of:

    create table boeken
    (
    boeknr smallint not null,
    auteurnr smallint not null,
    auteurnaam char(50) not null,
    pags smallint not null,
    pubdate date,
    serie char(50),
    deel smallint,
    genre char(50),
    primary key (boeknr),
    foreign key (auteurnr) references auteurs (auteurnr)
    )

    complete code is

    CREATE TABLE auteurs
    (
    auteurnr smallint not null,
    voornaam char(25),
    tussenvoegsel char(25),
    achternaam char(25) not null,
    geboortedatum date,
    sterftedatum date,
    genre char(50),
    primary key (auteurnr)
    )

    Create TABLE boeken
    (
    boeknr smallint not null,
    auteurnr smallint not null,
    auteurnaam char(50) not null,
    pags smallint not null,
    pubdate date,
    serie char(50),
    deel smallint,
    genre char(50),
    primary key (boeknr),
    foreign key (auteurnr) references auteurs (auteurnr)
    )

    CREATE TABLE strips
    (
    stripnr smallint not null,
    titel char(50) not null,
    hardcover char(3) not null,
    serie1 char(30) not null,
    ishserie1 smallint not null,
    serie2 char(30),
    ishserie2 smallint,
    serie3 char(30),
    ishserie3 smallint,
    primary key (stripnr)
    )

    CREATE TABLE leningen
    (
    aan char(50) not null,
    boeknr smallint not null,
    wanneer date not null,
    terugverwacht date,
    telefoon smallint,
    mobiel smallint,
    adres text(30),
    primary key (boeknr, wanneer)
    foreign key (boeknr) references boeken (boeknr)
    )

    please tell me if you spot more errors or have awesome suggestions
     
    Last edited: Nov 15, 2009
  5. Aurora

    Aurora The Defiant

    Joined:
    Sep 12, 2007
    Messages:
    3,732
    Likes received:
    15
    Trophy points:
    38
    From:
    The Netherlands
    Use Notepad++ to write all your code and set the language to mySQL. That should spot most errors in your code right away. It's the best I've found so far. And if you're really smart, download it (and Filezilla) from www.portableapps.com and install it to an usb stick. I assume that your school also works with one central server, and that all pc's are basically just terminals where you can log in with a password? If that's the case then it can be pretty hard to install any additional software anyway, so a portable app is something I would highly recommend. Besides, it's probably the most easy way to work on the same files everywhere, since everything is on the stick. :)

    As for that code you posted: it's been about 4 years since I last was really into mySQL. It's a bit gibberish for me at the moment. Sorry.

    Nevermind about the others stuff I said in my previous post. If you're not also making a working website, then you don't really need a server anyway. :/
     
  6. LordKerwyn

    LordKerwyn New Member

    Joined:
    Jul 28, 2007
    Messages:
    2,259
    Likes received:
    9
    Trophy points:
    0
    From:
    Deep Space
    What's informatica? I ask because it sounds like an interesting project to try and spread.
     
  7. Aurora

    Aurora The Defiant

    Joined:
    Sep 12, 2007
    Messages:
    3,732
    Likes received:
    15
    Trophy points:
    38
    From:
    The Netherlands
    I just made an awesome reply with many details and part of a rant I've been wanting to post for a while now, and then the stupid server went inaccessible again.

    So the short version:
    Informatica is just a class you can take at high school, much like you can choose to study French, history etc. You learn about the basic use of programming languages and where they are commonly used for.

    Now here should be a rant about books being outdated within months and people failing exams for giving the right answers and being punished for not quoting bad literature, but this sentence alone should probably make clear where this was going. Just going to say this: I think that the technical side of ICT is being ignored much to often by each and every high school. Teachers set up a network at home with the Windows wizard, and think it's the same as maintaining a huge server park for a company. So they complain with the publishers of these books and say they want more programming stuff to be added, which is of course an idiotic course of action. The technical side is much less likely to get outdated within a year, while the programming they want us to learn is already old by the time you're halfway through the 3 years you get this class. Students try to teach themselves by using the internet and keep up with the recent changes, which works pretty well. Then you get to your exams and provide answers with the latest changes incorporated into them, and you get a 3 or 4 which you Americans would probably call about a D / D minus or whatever. It happens because the exams are all made from 3 to 4 year old material.

    So my advice to ijffdrie:
    If you take this seriously, keep up with changes by yourself, but also learn exactly what stands in those books or whatever you get, or else you'll probably fail.

    <_< Crap. A new rant. xD
     
  8. LordKerwyn

    LordKerwyn New Member

    Joined:
    Jul 28, 2007
    Messages:
    2,259
    Likes received:
    9
    Trophy points:
    0
    From:
    Deep Space
    Is it only SQL you guys learn or is it several different languages?
     
  9. Aurora

    Aurora The Defiant

    Joined:
    Sep 12, 2007
    Messages:
    3,732
    Likes received:
    15
    Trophy points:
    38
    From:
    The Netherlands
    Most schools do html, php, css, mySQL and combine them all in projects in the end. You know, to see if you don't just learned the code, but can also use it properly. Just learning a bunch of tags isn't enough when your exams require you to write, for example, a script for a simple forum. And you have to do that without any reference. We just got notepad and a parser. It sucked so badly, don't even want to think about it anymore. I failed so hard at it because I was mostly focussing on css and html stuff to build websites. Then we only got mySQL and php in the exam. >_<
    I wish they did more practicing with those. Everybody can use html these days. You see it each day when looking at your youtube or photobucket account. But not php and such. That's always at the back end of sites, or in programs you never get to see the source code from anyway.
     
  10. LordKerwyn

    LordKerwyn New Member

    Joined:
    Jul 28, 2007
    Messages:
    2,259
    Likes received:
    9
    Trophy points:
    0
    From:
    Deep Space
    Huh, that sounds interesting if done right it seems like it would be a really fun class. Unfortuneately, most U.S. high schools (that I know of) don't even offer AP Computer Science, it would take a miracle to find a high school that offered something similar. Also, considering I am a college student now it doesn't really effect me it just sound interesting.
     
  11. Aurora

    Aurora The Defiant

    Joined:
    Sep 12, 2007
    Messages:
    3,732
    Likes received:
    15
    Trophy points:
    38
    From:
    The Netherlands
    Well there surely should be some kind of class you can take that covers this? Or maybe some initiative by students themselves who form some programming group. Or are those things only present in stereotype college movies? The media tends to make people believe that what they see is always real. :p

    But I might just as well tease you a bit more then: we even have several schools that only(!) focuss on game design. But to be honest, I don't think it will last for long. It's all caused by Guerila (I believe it's just with 1 l) released Killzone. The Dutch media were all over it, since it was the first big international release in ages, and as usual they only say how much $$$ and €€€ was being made. I wonder how long it will take for people to realize that being a game programmer probably will make you earn less money then most other jobs, which you can even get employed in with much less effort. It's like Blizzard says in interviews, you know. The people working on games just really, really care for their products. There are just certain professions that won't make you a lot of money. Maybe that's why most countries don't really support it. If the majority of people working in the gaming and programming industry don't make lots of money, then schools will be less interested in expanding their education in those areas. No, it's way more economical to teach kids how to use half naked women to trigger the male brain into thinking that using half a can of Axe each day will make those girls want you. Because let's face it: the real money is only to be made in commercials and singing crappy rap songs. Or if you live in America, then you get the diversity of making money by suing random people or developing addicting medicine and saying that it's totally safe. (sleeping pills, anyone?)

    Whew. I'm on fire today.
     
  12. LordKerwyn

    LordKerwyn New Member

    Joined:
    Jul 28, 2007
    Messages:
    2,259
    Likes received:
    9
    Trophy points:
    0
    From:
    Deep Space
    I think you misunderstood me. There isn't very many high schools that offer higher level computer science classes (by higher level I mean AP CS), but there are lots of colleges and universities that offer degrees in the field. Actually one of the big things at the university I go to right now is engineering, and within the College of Engineering the biggest department is EECS or Electrical Engineering and Computer Science.

    In fact because you mentioned it the EECS department at my university is adding a game design option to the CS degree it offers. In the U.S. in general jobs in the CS field have some of the highest projected growth in terms the amount of CS jobs currently out there.
     
  13. cautionmike_190

    cautionmike_190 New Member

    Joined:
    Mar 23, 2009
    Messages:
    380
    Likes received:
    2
    Trophy points:
    0
    From:
    Philippines
    why not use Visual Basic or VB.NET?????????? ...
     
  14. ijffdrie

    ijffdrie Lord of Spam

    Joined:
    Aug 23, 2007
    Messages:
    5,725
    Likes received:
    17
    Trophy points:
    38
    we have learned to work with javalogo, html and now sql, and i still have 1,5 years to go
     
  15. Fenix

    Fenix Moderator

    Joined:
    May 21, 2007
    Messages:
    6,769
    Likes received:
    11
    Trophy points:
    0
    Books.

    His Dark Materials by...Someone.

    Books are way awesomer than the movies.
     
  16. Aurora

    Aurora The Defiant

    Joined:
    Sep 12, 2007
    Messages:
    3,732
    Likes received:
    15
    Trophy points:
    38
    From:
    The Netherlands
    True. Also: don't forget The Silmarillion when adding Tokien books. And maybe some stuff written by that Russian guy. Dostejevski or whatever the spelling is. Makes you look smart, and what I read from him was actually pretty good.
     
  17. Kaaraa

    Kaaraa Space Junkie

    Joined:
    Sep 19, 2007
    Messages:
    1,335
    Likes received:
    3
    Trophy points:
    0
    From:
    United States
    You still haven't answered my question, ijffdrie. I guess I'll start naming books I liked then:

    Jurassic Park
    Anthem (by Ayn Rand)
    The Sword of Truth (series, by Terry Goodkind)
    The Zombie Survival Guide
    World War Z