Exercise 2 solution CREATE TABLE MUSICIAN ( NAME

Exercise 2 solution CREATE TABLE MUSICIAN ( NAME VARCHAR(32) NULL, PHONE VARCHAR(32) NULL, EMAIL VARCHAR(32) NULL, INSTRUMENTS VARCHAR(32) NULL, SKILLS VARCHAR(32) NULL ); CREATE TABLE SHOWS ( LOCATION VARCHAR(32) NULL, ADDRESS VARCHAR(32) NULL, DIRECTIONS VARCHAR(32) NULL, PHONE VARCHAR(32) NULL, SHOW_DATE DATE NULL, SHOW_TIMES VARCHAR(32) NULL ); CREATE TABLE MERCHANDISE ( TYPE VARCHAR(32) NULL, PRICE FLOAT NULL ); CREATE TABLE DISCOGRAPHY ( CD_NAME VARCHAR(32) NULL, RELEASE_DATE DATE NULL, PRICE FLOAT NULL ); CREATE TABLE BAND ( NAME VARCHAR(32) NULL, FOUNDING_DATE DATE NULL, GENRES VARACHAR(32) NULL ); CREATE TABLE ADVERTISEMENT ( AD_DATE DATE NULL, AD_TEXT VARCHAR(1000) NULL, AD_PHONE VARCHAR(32) NULL, AD_EMAIL VARCHAR(32) NULL, AD_REQUIREMENTS VARCHAR(1000) NULL ); 428 Appendix A
You want to have a cheap webhost for your apache application, then check apache web hosting services.

Leave a Reply