Hi I am a newbie on the sql statement, i was given a small exercise through the book regarding sql statement, it was told something like :

The PUBLISHERS table will have the attributes ID (3 characters), name (maximum of 30 characters, and city (maximum of 10 characters). The BOOKS table will have the attributes ID (4 characters), title (maximum of 50 characters), author (maximum of 30 characters), publisher ID, and date published. Make reasonable assumptions for the data types of publisher ID and date published.

CREATE TABLE PUBLISHERS(
Publisher_ID int NOT NULL,
Name varchar(50) NOT NULL,
City varchar(50) NOT NULL,
CONSTRAINT PUBLISHERS_PK PRIMARY KEY(Publisher_ID));

CREATE TABLE BOOKS
(
Title varchar(50) NOT NULL,
Author varchar(30) NOT NULL,
DatePublish date NOT NULL,
Publisher_ID int NOT NULL,
CONSTRAINT Title_PK PRIMARY KEY(Title),
CONSTRAINT Publisher_ID FOREIGN KEY(Publisher_ID)
REFERENCES PUBLISHERS(Publisher_ID));

Can any expert(s) advice me on the exercise against my answer, I am so exciting to wait for some one to correct me.

Looks pretty good to me, except for

CONSTRAINT Publisher_ID FOREIGN KEY(Publisher_ID)

The syntax changes depending of the DB you are using, but with postgresql, for example, this would be written:

...
Publisher_ID  int  NOT NULL references publishers(Publisher_ID),
...

For me, you say that you want an FK on that field, ok, but you don't say in which table the key is placed...

Does that mean my sql statement had met the requirement of exercise.
So what do u mean by postgresql.

I mean postgresql is different from oracle which is different from ms sql server which is different from access and so on. Each db has a syntax that belongs to itself, on details like those. But yes, otherwise I think your answer is correct.

OO..get u get u..:
) thank alot for ur help

In the exercise i was told to : List all the publishers, and the titles and date published of each publisher arranged by publisher name.

I did try to : SELECT NAME,TITLE,DATEPUBLISH FROM BOOKS,PUBLISHERS
GROUP BY NAME;


it turn out abit funny. is my statement correct, if not why.