Database structure and potential queries

[shane]

If you want to data on a particular ShowType then it's just a matter of JOINing the relevant tables.

The query below returns some basic data for every Show that is of ShowType XXX, where XXX represents the ShowTypeID of the required ShowType . The ShowTypeID has been used but the Show.TypeName could be used but would require a further JOIN using the ShowType table.

SELECT	S.ShowName,
		S.ShowDate,
		S.ShowTime,
		S.ShowDesc
FROM	Show AS S INNER JOIN
		(Artist AS A INNER JOIN ArtistShow AS [AS] ON A.ArtistID = [AS].ArtistID)
		ON S.ShowID = AS.ShowID
WHERE	S.ShowTypeID = XXX;

An ID field is typically used in a link (which display the actual name) or in a search form listing the different ShowTypes.

Attached is the db diagram.

As for DB courses, I think if you can find a decent one it'd be worth it (here's the one I took). Having said that many of the people I work with haven't any formal DB design training but are very knowledgable and skilled. Experience counts for a lot.