PRICE MONEY NULL ); CREATE TABLE ARTISTS ( (Yahoo free web hosting)
PRICE MONEY NULL ); CREATE TABLE ARTISTS ( ARTIST_ID INTEGER PRIMARY KEY, MERCHANDISE_ID INTEGER FOREIGN KEY REFERENCES MERCHANDISE WITH NULL, GENRE_ID INTEGER FOREIGN KEY REFERENCES GENRE WITH NULL, INSTRUMENT_ID INTEGER FOREIGN KEY REFERENCES INSTRUMENT WITH NULL, MUSICIAN_NAME STRING NULL, MUSICIAN_PHONE STRING NULL, MUSICIAN_EMAIL STRING NULL, BAND_NAME STRING NULL, BAND_FOUNDING_DATE DATE NULL, DISCOGRAPHY_CD_NAME STRING NULL, DISCOGRAPHY_RELEASE_DATE DATE NULL, DISCOGRAPHY_PRICE MONEY NULL, SHOW_DATE DATE NULL, SHOW_TIME STRING NULL, VENUE_NAME STRING NULL, VENUE_ADDRESS STRING NULL, VENUE_DIRECTIONS BIGSTRING NULL, VENUE_PHONE STRING NULL, ADVERTISEMENT_DATE DATE NULL, ADVERTISEMENT_TEXT BIGSTRING NULL ); Chapter 11 Exercise 1 solution CREATE TABLE INSTRUMENT ( INSTRUMENT_ID INTEGER PRIMARY KEY NOT NULL, SECTION_ID INTEGER FOREIGN KEY REFERENCES INSTRUMENT WITH NULL, INSTRUMENT CHAR VARYING(32) NOT NULL ); CREATE TABLE GENRE ( GENRE_ID INTEGER PRIMARY KEY NOT NULL, PARENT_ID INTEGER FOREIGN KEY REFERENCES GENRE WITH NULL, GENRE CHAR VARYING(32) NOT NULL ); CREATE TABLE VENUE ( VENUE_ID INTEGER PRIMARY KEY NOT NULL, LOCATION CHAR VARYING(32) 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) NULL, 431 Exercise Answers
In case you need quality webspace to host and run your web applications, try our personal web hosting services.