------------------< SQL Statements >----------------------
-- Schema Name: 
-- Time       : Tue Mar 14 18:00:50 2006


SET ANSI_WARNINGS OFF;

CREATE TABLE ALBUM(
ID_ int NOT NULL, 
Title varchar(30) NOT NULL, 
Release_Date datetime NOT NULL);

ALTER TABLE ALBUM
 ADD
 CONSTRAINT PRM5650 PRIMARY KEY ( ID_ )
;

CREATE UNIQUE INDEX IDX5655 ON ALBUM(Title);

CREATE TABLE PERFORMER(
ID_ int NOT NULL, 
Name varchar(30) NOT NULL);

ALTER TABLE PERFORMER
 ADD
 CONSTRAINT PRM5653 PRIMARY KEY ( ID_ )
;

CREATE UNIQUE INDEX IDX5657 ON PERFORMER(Name);

CREATE TABLE PERFORMER_ALBUM_X(
PERFORMER_ID_FK int NOT NULL, 
ALBUM_ID_FK int NOT NULL);

ALTER TABLE PERFORMER_ALBUM_X
 ADD
 CONSTRAINT PRM5683 PRIMARY KEY ( PERFORMER_ID_FK, ALBUM_ID_FK )
;

CREATE TABLE ALBUM_Label(
ID_ int NOT NULL, 
ALBUM_ID_FK int NOT NULL, 
Label varchar(30) NOT NULL);

ALTER TABLE ALBUM_Label
 ADD
 CONSTRAINT PRM5677 PRIMARY KEY ( ID_ )
;

CREATE TABLE SONG(
ID_ int NOT NULL, 
Title varchar(30) NOT NULL, 
"Key" varchar(30) NOT NULL, 
Length_in_Minutes varchar(30) NOT NULL);

ALTER TABLE SONG
 ADD
 CONSTRAINT PRM5651 PRIMARY KEY ( ID_ )
;

CREATE UNIQUE INDEX IDX5656 ON SONG(Title);

CREATE TABLE SONG_ALBUM_X(
SONG_ID_FK int NOT NULL, 
ALBUM_ID_FK int NOT NULL);

ALTER TABLE SONG_ALBUM_X
 ADD
 CONSTRAINT PRM5681 PRIMARY KEY ( SONG_ID_FK, ALBUM_ID_FK )
;

CREATE TABLE SONG_Composer(
ID_ int NOT NULL, 
SONG_ID_FK int NOT NULL, 
Composer varchar(30) NOT NULL);

ALTER TABLE SONG_Composer
 ADD
 CONSTRAINT PRM5678 PRIMARY KEY ( ID_ )
;

CREATE TABLE SONG_PERFORMER_X(
SONG_ID_FK int NOT NULL, 
PERFORMER_ID_FK int NOT NULL);

ALTER TABLE SONG_PERFORMER_X
 ADD
 CONSTRAINT PRM5679 PRIMARY KEY ( SONG_ID_FK, PERFORMER_ID_FK )
;

CREATE TABLE PERFORMER_Address(
ID_ int NOT NULL, 
Street varchar(30) NULL, 
City varchar(35) NULL, 
State varchar(2) NULL, 
Zip varchar(5) NULL, 
PERFORMER_ID_FK int NOT NULL);

ALTER TABLE PERFORMER_Address
 ADD
 CONSTRAINT PRM5658 PRIMARY KEY ( ID_ )
;

CREATE TABLE PERFORMER_Cell_Phone(
ID_ int NOT NULL, 
Area_Code varchar(3) NULL, 
Phone_Number varchar(8) NULL, 
PERFORMER_ID_FK int NOT NULL);

ALTER TABLE PERFORMER_Cell_Phone
 ADD
 CONSTRAINT PRM5663 PRIMARY KEY ( ID_ )
;

ALTER TABLE PERFORMER_ALBUM_X ADD CONSTRAINT FKY5683
FOREIGN KEY(PERFORMER_ID_FK) REFERENCES PERFORMER(ID_);

ALTER TABLE PERFORMER_ALBUM_X ADD CONSTRAINT FKY5684
FOREIGN KEY(ALBUM_ID_FK) REFERENCES ALBUM(ID_);

ALTER TABLE ALBUM_Label ADD CONSTRAINT FKY05677
FOREIGN KEY(ALBUM_ID_FK) REFERENCES ALBUM(ID_);

ALTER TABLE SONG_ALBUM_X ADD CONSTRAINT FKY5681
FOREIGN KEY(SONG_ID_FK) REFERENCES SONG(ID_);

ALTER TABLE SONG_ALBUM_X ADD CONSTRAINT FKY5682
FOREIGN KEY(ALBUM_ID_FK) REFERENCES ALBUM(ID_);

ALTER TABLE SONG_Composer ADD CONSTRAINT FKY05678
FOREIGN KEY(SONG_ID_FK) REFERENCES SONG(ID_);

ALTER TABLE SONG_PERFORMER_X ADD CONSTRAINT FKY5679
FOREIGN KEY(SONG_ID_FK) REFERENCES SONG(ID_);

ALTER TABLE SONG_PERFORMER_X ADD CONSTRAINT FKY5680
FOREIGN KEY(PERFORMER_ID_FK) REFERENCES PERFORMER(ID_);

ALTER TABLE PERFORMER_Address ADD CONSTRAINT FKY05658
FOREIGN KEY(PERFORMER_ID_FK) REFERENCES PERFORMER(ID_);

ALTER TABLE PERFORMER_Cell_Phone ADD CONSTRAINT FKY05663
FOREIGN KEY(PERFORMER_ID_FK) REFERENCES PERFORMER(ID_);