CD_NAME STRING NOT NULL, RELEASE_DATE DATE NULL, PRICE (Web hosting billing)
CD_NAME STRING NOT NULL, RELEASE_DATE DATE NULL, PRICE MONEY NULL ); CREATE TABLE SHOW ( SHOW_ID INTEGER PRIMARY_KEY, VENUE_ID INTEGER FOREIGN KEY REFERENCES VENUE, BAND_ID INTEGER FOREIGN KEY REFERENCES BAND, DATE DATE NULL, TIME STRING NULL ); CREATE TABLE MUSICIAN ( MUSICIAN_ID INTEGER PRIMARY KEY, INSTRUMENT_ID INTEGER FOREIGN KEY REFERENCES INSTRUMENT, BAND_ID INTEGER FOREIGN KEY REFERENCES BAND, MUSICIAN STRING NOT NULL, PHONE STRING NULL, EMAIL STRING NULL, SKILLS STRING NULL ); CREATE TABLE ADVERTISEMENT ( ADVERTISEMENT_ID INTEGER PRIMARY KEY, BAND_ID INTEGER FOREIGN KEY REFERENCES BAND, MUSICIAN_ID INTEGER FOREIGN KEY REFERENCES MUSICIAN, AD_DATE DATE NULL, AD_TEXT BIGSTRING NULL ); Exercise 2 solution CREATE TABLE INSTRUMENT ( INSTRUMENT_ID INTEGER PRIMARY KEY, SECTION_ID INTEGER FOREIGN KEY REFERENCES INSTRUMENT WITH NULL, INSTRUMENT STRING NOT NULL ); CREATE TABLE GENRE ( GENRE_ID INTEGER PRIMARY KEY, PARENT_ID INTEGER FOREIGN KEY REFERENCES GENRE WITH NULL, GENRE STRING NOT NULL ); CREATE TABLE MERCHANDISE ( MERCHANDISE_ID INTEGER PRIMARY KEY, TYPE STRING NOT NULL, 430 Appendix A
Searching for affordable and proven webhost to host and run your servlet applications? Go to Linux Web Hosting services and you will find it.