IPT home IPT A Virtual Approach by Peter Whitehouse
Quick Links:
PHP home
Information and Intelligent Systems Social and Ethical Implications Human Computer Interaction Software and Systems Engineering eXercise Files Course Outline and Assessment A-Z of Geeky Acronyms Terrace Work Program 2004 Sillybus FAQ = Frequently Asked Questions Help

wOnKo's Music Database

Primitive PHP Query Engine

Type your query here:

The MUSIC DATABASE is a simple 3-table relational database:
Albums table - design view The ALBUMS table contains general information about the recordings (one row per album)
Tracks table - design view The TRACKS table contains the song listings found on these recordings. Disk number (for multi-disk sets) and the song titles found on those disks.
Performers table - design view The PERFORMERS table contains information on what artist played what instrument on the album.

Enter your Query in the text box above and submit it for processing - your answer table will be delivered back to you if your query was error free.

See the PHP Script



©Copyright t 1992..2018+. Edition 26.150117
Creative Commons License
This work is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 2.1 Australia License