Chapter 10 Exercise 1 solution CREATE TABLE INSTRUMENT (Web server hosting)
Chapter 10 Exercise 1 solution CREATE TABLE INSTRUMENT ( INSTRUMENT_ID INTEGER PRIMARY KEY, SECTION_ID INTEGER FOREIGN KEY REFERENCES INSTRUMENT WITH NULL, INSTRUMENT STRING NOT NULL ); INSTRUMENT is NOT NULL, because there is no point in storing an instrument without a name. CREATE TABLE GENRE ( GENRE_ID INTEGER PRIMARY KEY, PARENT_ID INTEGER FOREIGN KEY REFERENCES GENRE WITH NULL, GENRE STRING NOT NULL ); CREATE TABLE VENUE ( VENUE_ID INTEGER PRIMARY KEY, VENUE STRING NOT NULL, ADDRESS STRING NULL, DIRECTIONS STRING NULL, PHONE STRING NULL ); The field for the name of the VENUE should be VENUE, not LOCATION. It is thus changed in the preceding script. CREATE TABLE BAND ( BAND_ID INTEGER PRIMARY KEY, GENRE_ID INTEGER FOREIGN KEY REFERENCES GENRE, BAND STRING NOT NULL, FOUNDING_DATE DATE NULL ); CREATE TABLE MERCHANDISE ( MERCHANDISE_ID INTEGER PRIMARY KEY, BAND_ID INTEGER FOREIGN KEY REFERENCES BAND, TYPE STRING NOT NULL, PRICE MONEY NULL ); CREATE TABLE DISCOGRAPHY ( DISCOGRAPHY_ID INTEGER PRIMARY KEY, BAND_ID INTEGER FOREIGN KEY REFERENCES BAND, 429 Exercise Answers
Please visit Domain Name Hosting services for high quality webhost to host and run your jsp applications.