( VENUE_ID INTEGER PRIMARY KEY NOT NULL, LOCATION (Make my own web site)
( VENUE_ID INTEGER PRIMARY KEY NOT NULL, LOCATION CHAR VARYING(32) UNIQUE NOT NULL, ADDRESS_LINE_1 CHAR VARYING(32) NOT NULL, ADDRESS_LINE_2 CHAR VARYING(32) NULL, TOWN CHAR VARYING(32) NOT NULL, ZIP NUMBER(5) FORMAT 99999 MASK 99999 NULL, POSTAL_CODE CHAR VARYING(32) NULL, COUNTRY CHAR VARYING(32) NULL, DIRECTIONS MEMO NULL, PHONE CHAR VARYING(32) NULL ); CREATE TABLE MERCHANDISE ( MERCHANDISE_ID INTEGER PRIMARY KEY NOT NULL, BAND_ID INTEGER FOREIGN KEY REFERENCES BAND NOT NULL, TYPE CHAR VARYING(32) UNIQUE NOT NULL, PRICE MONEY FORMAT $9,999,990.99 MASK 9999990.00 NOT NULL ); CREATE TABLE DISCOGRAPHY ( DISCOGRAPHY_ID INTEGER PRIMARY KEY NOT NULL, BAND_ID INTEGER FOREIGN REFERENCES BAND NOT NULL, CD_NAME CHAR VARYING(32) NOT NULL, RELEASE_DATE DATE FORMAT DD MON, YEAR MASK MM/DD/YYYY NOT NULL, PRICE MONEY FORMAT $9,999,990.99 MASK 9999990.00 NOT NULL ); CREATE TABLE SHOW ( SHOW_ID INTEGER PRIMARY KEY NOT NULL, BAND_ID INTEGER FOREIGN KEY REFERENCES BAND NOT NULL, VENUE_ID INTEGER FOREIGN KEY REFERENES VENUE NOT NULL, DATE DATE FORMAT DD MON, YEAR MASK MM/DD/YYYY NOT NULL, TIME CHAR VARYING(16) FORMAT 90:90:90 MASK 90:90:90 NOT NULL ); CREATE TABLE BAND ( BAND_ID INTEGER PRIMARY KEY NOT NULL, GENRE_ID INTEGER FOREIGN KEY REFERENCES GENRE NOT NULL, BAND CHAR VARYING(32) UNIQUE NOT NULL, FOUNDING_DATE DATE FORMAT DD MON, YEAR MASK MM/DD/YYYY NOT NULL ); CREATE TABLE MUSICIAN ( MUSICIAN_ID INTEGER PRIMARY KEY NOT NULL, INSTRUMENT_ID INTEGER FOREIGN KEY REFERENCES INSTRUMENT NOT NULL, BAND_ID INTEGER FOREIGN KEY REFERENCES BAND WITH NULL, MUSICIAN CHAR VARYING(32) UNIQUE NOT NULL, PHONE CHAR VARYING(32) NULL, 376 Chapter 12
We recommend cheap and reliable webhost to host and run your web applications: Coldfusion Web Hosting services.