POPULARITY_RATING SMALLINT NULL ); CREATE TABLE LOCATION ( (Web hosting india)
POPULARITY_RATING SMALLINT NULL ); CREATE TABLE LOCATION ( LOCATION_ID INTEGER PRIMARY KEY NOT NULL, REGION CHAR VARYING(32) NOT NULL, COUNTRY CHAR VARYING(32) NOT NULL, STATE CHAR(2) NULL, CITY CHAR VARYING(32) NOT NULL, CURRENCY_TICKER CHAR(3) NOT NULL, CURRENCY CHAR VARYING(32) UNIQUE NOT NULL, EXCHANGE_RATE FLOAT NOT NULL, DECIMALS SMALLINT FORMAT 9 NULL ); The CURRENCY_TICKER field is not UNIQUE in the LOCATION table because locations are duplicated within countries by both states and cities. Next, consider the TIME table: CREATE TABLE TIME ( TIME_ID INTEGER PRIMARY KEY NOT NULL, YEAR INTEGER FORMAT 9999 NOT NULL, QUARTER INTEGER FORMAT 9 NOT NULL, MONTH INTEGER FORMAT 99 NOT NULL ); Years are output formatted to ensure all four digits are always returned. Quarters are formatted to show only 1, 2, 3, or 4. Months are formatted to show 01 for January and 12 for December. Finally, look at the LISTING_BIDS table: CREATE TABLE LISTING_BIDS ( LISTING# CHAR(10) PRIMARY KEY NOT NULL, BID_ID INTEGER FOREIGN KEY REFERENCES BID NOT NULL, BUYER_ID INTEGER FOREIGN KEY REFERENCES BUYER WITH NULL, BIDDER_ID INTEGER FOREIGN KEY REFERENCES BUYER WITH NULL, SELLER_ID INTEGER FOREIGN KEY REFERENCES SELLER WITH NULL, TIME_ID INTEGER FOREIGN KEY REFERENCES TIME WITH NULL, LOCATION_ID INTEGER FOREIGN KEY REFERENCES LOCATION WITH NULL, CATEGORY_ID INTEGER FOREIG KEY REFERENCES CATEGORY WITH NULL, LISTING_STARTING_PRICE MONEY NOT NULL, LISTING_RESERVE_PRICE MONEY NULL, LISTING_BUY_NOW_PRICE MONEY NULL, LISTING_START_DATE DATE FORMAT DD MON, YEAR NOT NULL, LISTING_DAYS SMALLINT NOT NULL, 372 Chapter 12
In case you need quality webspace to host and run your web applications, try our personal web hosting services.