Miscellany

CREATE DATABASE MusicDB;
CREATE TABLE Artists (
	Artist 		VARCHAR(64),
	ArtistID	INT NOT NULL PRIMARY KEY AUTO_INCREMENT
);

CREATE TABLE Songs (
	SName		VARCHAR(64),
	SLength		INT, # Seconds
	SGenreID	INT,
	SArtistID	INT, # ID from the Artists Table
	SAlbumID	INT, # Comma-seperated list of Albums a song appears on.
	SongID		INT NOT NULL PRIMARY KEY AUTO_INCREMENT
);

CREATE TABLE Albums (
	AName		VARCHAR(128),
	ANumSongs	INT, # Number of songs on the album. Duh.
	AArtistID	INT, # ID from the Artists Table.
	AlbumID		INT NOT NULL PRIMARY KEY AUTO_INCREMENT
);

CREATE TABLE Genre (
	Genre	VARCHAR(32),
	GenreID INT NOT NULL PRIMARY KEY AUTO_INCREMENT
);

INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Alternative', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Ambient', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Blues', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Children\'s Music', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Christian & Gospel', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Classical', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Comedy', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Country & Western', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Electronica & Dance', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Folk & Acoustic', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Jazz', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Rock', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Heavy Metal', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('New Age', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Pop', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Rap & Hip-Hop', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Roots & World', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Soul/R&B', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Soundtracks', NULL);
INSERT INTO MusicDB.Genre (Genre, GenreID) VALUES ('Vocal', NULL);