Web site builder - A Exercise Answers This appendix contains all the
A Exercise Answers This appendix contains all the answers to the exercises appearing at the ends of chapters. Chapter 3 Exercise 1 solution Two CREATE TABLE commands: CREATE TABLE Band ( band_id INTEGER NOT NULL, band_name VARCHAR(32) NULL, CONSTRAINT XPK_Band PRIMARY KEY (band_id), CONSTRAINT XUK_B_Name UNIQUE (band_name) ); CREATE TABLE Track ( track_id INTEGER NOT NULL, band_id INTEGER NOT NULL, track_name VARCHAR(32) NULL, description VARCHAR(256) NULL, CONSTRAINT XPK_Track PRIMARY KEY (track_id), CONSTRAINT FK_T_Band FOREIGN KEY (band_id) REFERENCES Band, CONSTRAINT XUK_T_Name UNIQUE (track_name) ); Exercise 2 solution One CREATE INDEX command: CREATE INDEX XFK_T_Band ON Track(band_id);
From our experience, we are can tell you that you can find a reliable and cheap webhost service at Java Web Hosting services.