Home About Cameron Puzzles Videos Movies Contact Cameron Contact Cameron's Beard Login Signup
"Are you Jew or Muslim?" - Wog From Work
YEEEAAAH 18th May 2009 06:07:52 PM
I just completed a databases assignment intend for 4 people in under 24 hours!

Holy crap what do I win?!

Actually to be fair it's not entirely finished, I still have to write boring documentation stuff, but that won't take more than an hour or so.

The most important thing is that I get to play ITG tonight!!

The assignment was actually pretty demanding... we had to design a database from scratch using MySQL and write an application layer for it (I did mine in PHP, hot damn I knew I was being smart when I decided to learn PHP+MySQL in year 10). My final application layer is about 1400 lines of code.

Check out the assignment here if you're interested (click the 'Project Specification' links).

Probably my favourite part of the assignment was writing the code that could turn something like this:

+----------+----------+---------+
| catalogn | place | country |
+----------+----------+---------+
| 1 | New York | USA |
| 2 | New York | USA |
| 6 | New York | USA |
| 7 | New York | USA |
+----------+----------+---------+

Edit: Damn, I forgot that would happen. Here's a link to one of the actual files I used in the assignment.

Into a 2D array in which you can use the position of the table elements in the table to reference them. For example: table[0][0]=1, table[0][1]='New York'

I don't actually know how we were expected to do that bit... or if we can even be marked on it, given that it has very little to do with maintaining a database. Still cool though.

All you Java programming people should be thinking about how you can solve this problem too!!

Now I just have a probability test on Thursday, and a Data Structures and Algorithms assignment due on Monday. YEAH LET'S DO IT! C'MON!.

Oh and there's some in-lab test thing for Data Structures... that'll be fun, using Macs.

Hope everyone is getting psyched for exams.


Got something to say?

Name:
Response/comments:
Please enter this code below:
Cool Stuff
Elastic Band Ball
Mother Bottles
Cubics
DDR/ITG
My Banjo
Tesseracts
Potato Cam
MATH1020 Notes
Ridiculous Proof
Footy Cards
Quotes List

More Of My Stuff
My YouTube Channel
This is my YouTube channel. Most of the videos on this site come from here.

Me On FaceBook
Here I am on the book of faces.

Me On deviantART
I don't use this at all anymore. There's some really old stuff of mine here. In the future, if I want to showcase stuff I've made I'll almost certainly make a page on this blog.

Stuff By Friends
Jakki's Portfolio
This is Jakki's personal portfolio and blog. She puts pretty pictures and writes about all manner of things here. Have a look!

Jenny's Blog
My friend Jenny's (tripple new and improved!) blog. She's pretty cool, go and have a read.

Jayce's Blog/Site
Jayce is a cool guy who plays ITG with me sometimes (quite often actually). He does web design and junk for money or something. Go look at his blog/site.

He also makes ITG stepfiles.

Scott Campbell
My friend Scott's personal site. He does web design and has some pretty neat stuff up there. Check it out.

Larrikin Photography
My UNI friend Brandon's photo site. He takes many a cool photo. Be sure to have a look and buy some if you like them! You can also hire him!

Stuff I Read
XKCD
Fun little comic with stick people. Sometimes has maths jokes.

Ctrl+Alt+Del
I don't know why I still read this but I do. And it is for that reason you should check it out.

Cyanide And Happiness
Hey it makes me laugh. It's fun.

Rumblo
KC Green shoves all his comics here. It rules.

Slashdot
Slashdot. It's full of interesting stories and articles and stuff. Read it.

Turbo Update
TRICKY DISCO QUAD STAR - IT'S GONNA HAPPEN.

Pictures!
I thought it would be fun to have a space to draw silly pictures.