QUARTER INTEGER NULL, YEAR INTEGER NULL ); CREATE (Free web hosts)
QUARTER INTEGER NULL, YEAR INTEGER NULL ); CREATE TABLE LOCATION ( LOCATION_ID INTEGER PRIMARY KEY NOT NULL, CITY VARCHAR(32) NULL, COUNTY VARCHAR(32) NULL, STATE VARCHAR(32) NULL, COUNTRY VARCHAR(32) NULL ); CREATE TABLE RADIO ( STATION_ID INTEGER PRIMARY KEY NOT NULL, STATION VARCHAR(32) NULL ); CREATE TABLE PERFORMER ( PERFORMER_ID INTEGER PRIMARY KEY NOT NULL, PERFORMER VARCHAR(32) NULL ); CREATE TABLE RECORDINGARTIST ( RECORDING_ARTIST_ID INTEGER PRIMARY KEY NOT NULL, RECORDING_ARTIST VARCHAR(32) NULL ); CREATE TABLE ROYALTY ( ROYALTY_ID INTEGER PRIMARY KEY NOT NULL, TRACK_ID INTEGER REFERENCES TRACK NULL, RECORDING_ARTIST_ID INTEGER REFERENCES RECORDINGARTIST NULL, PERFORMER_ID INTEGER REFERENCES PERFORMER NULL, STATION_ID INTEGER REFERENCES RADIO NULL, LOCATION_ID INTEGER REFERENCES LOCATION NULL, TIME_ID INTEGER REFERENCES TIME NULL, AMOUNT FLOAT NOT NULL ); Exercise 2 solution CREATE TABLE TEMP AS SELECT B.NAME AS BAND_NAME, B.ADDRESS AS BAND.ADDRESS, B.PHONE AS BAND_PHONE, B.EMAIL AS BAND_EMAIL, CD.TITLE AS CD_TITLE, CD.LENGTH AS CD_LENGTH, CD.TRACKS AS CD_TRACKS,T.TRACK, T.LENGTH AS TRACK_LENGTH, T.GENRE AS TRACK_GENRE, T.CHART AS TRACK_CHART, T.RANK AS TRACK_RANK FROM BAND B JOIN CD CD JOIN TRACK T; — 425 Exercise Answers
We recommend cheap and reliable webhost to host and run your web applications: Coldfusion Web Hosting services.