Chapter 6 Exercise (Web server hosting) 1 solution CREATE TABLE BAND2
Chapter 6 Exercise 1 solution CREATE TABLE BAND2 AS SELECT B.BAND_ID, B.NAME, A.ADDRESS, P.PHONE, E.EMAIL FROM BAND B JOIN BAND_ADDRESS A USING(BAND_ID) JOIN BAND_PHONE P USING(BAND_ID) JOIN BAND_EMAIL E USING(BAND_ID); Exercise 2 solution DROP TABLE BAND; ALTER TABLE BAND2 RENAME TO BAND; Chapter 7 Exercise 1 solution CREATE TABLE BAND ( BAND_ID INTEGER PRIMARY KEY NOT NULL, NAME VARCHAR(32) NULL, ADDRESS VARCHAR(256) NULL, PHONE VARCHAR(32) NULL, EMAIL VARCHAR(32) NULL ); CREATE TABLE CD ( CD_ID INTEGER PRIMARY KEY NOT NULL, BAND_ID INTEGER REFERENCES BAND NULL, TITLE VARCHAR(32) NULL, LENGTH INTEGER NULL, TRACKS INTEGER NULL ); CREATE TABLE TRACK ( TRACK_ID INTEGER PRIMARY KEY NOT NULL, CD_ID INTEGER REFERENCES CD NULL, TRACK VARCHAR(32) NULL, LENGTH INTEGER NULL, GENRE INTEGER NULL, CHART VARCHAR(32) NULL, RANK INTEGER NULL ); CREATE TABLE TIME ( TIME_ID INTEGER PRIMARY KEY NOT NULL, HOUR INTEGER NULL, DAY INTEGER NULL, MONTH INTEGER NULL, 424 Appendix A
Please visit Domain Name Hosting services for high quality webhost to host and run your jsp applications.