Database excercizes

Email
We practiced making a table. Now look at email as a database-table, find all the necessary fields (and what is missing or not working for a single table?)

Twitter
Look at twitter as database, the same questions. Get to your twitter account, see how the twittering works from the database side. Look here:
In class links are shown for flash showing tweets, and submitting new tweets.

Layar
database, how to do this yourself
now  we understand what we did at hoppala:
http://augmentation.hoppala.eu/
we can find the MYSQL code to make the layar database on our own free server without the hoppala tag:
http://layar.pbworks.com/w/page/30832324/First%20Layar%20Tutorial%20-%20Create%20a%20simple%20layer
make this table on your server!
See this post:
http://crosslabminor-layar.blogspot.com/2010/09/make-layar-layer-hard-way.html

insert
Inserting records in a table from a html page makes life easier:
A link will be shown in class (fearing database injections!) which inserts records in my layar database.
http://www.contrechoc.com/XXX/xxx

Second Life....
Nice 3D world. In fact, it is just a database visualisation. We have put a microphone somewhere, which records what is said in it's neighbourhood. The microphone is illustrating that everything in this world is recorded. The owner didn't want to be reminded of this fact!
http://www.nuggetkidd.byethost11.com/sl/loadToFlash_Nugget_Kidd.php
gives the raw data, which can be shown in a (undesigned) flash movie:
http://www.nuggetkidd.byethost11.com/minorCourse/loadDB_Nugget_Kidd.html

The World
Is our world just a database?

http://rop.gonggri.jp/?p=442

Check this out:
http://www.online-tech-tips.com/google-softwaretips/use-gmail-as-an-online-database-with-super-fast-search/