MySQL, Java, JSP, Servlet, SSH, Tomcat Web Hosting Blog

Chapter 9 Exercise 1 solution CREATE TABLE INSTRUMENT(INSTRUMENT VARCHAR(32) NULL); CREATE TABLE SKILL(SKILL VARCHAR(32) NULL); CREATE TABLE GENRE(GENRE VARCHAR(32) NULL); CREATE TABLE MUSICIAN ( NAME VARCHAR(32) NULL, PHONE VARCHAR(32) NULL, EMAIL 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, MEMBERS VARCHAR(32) NULL, FOUNDING_DATE DATE NULL ); CREATE TABLE ADVERTISEMENT ( AD_DATE DATE NULL, AD_TEXT VARCHAR(1000) NULL, PHONE VARCHAR(32) NULL, EMAIL VARCHAR(32) NULL, REQUIREMENTS VARCHAR(1000) NULL ); 427 Exercise Answers
In case you need quality webspace to host and run your web applications, try our personal web hosting services.

This entry was posted on Sunday, January 20th, 2008 at 5:25 pm and is filed under Domain. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.