[Dogz]

Ok I'd apprecriate some help.

If I was to create the following tables, would my code be appropriate?

Hotel(hotelNo, hotelName, city)
Room(roomNo, hotelNo, type, price)

CREATE TABLE Hotel (
hotelNo INTEGER,
hotelName VARCHAR(20),
City CHAR(20),

CREATE TABLE Room (
roomlNo INTEGER,
hotelNo VARCHAR(20),
type CHAR(20),
price CHAR (3)

I haven't much of a clue about SQL code. Intergers etc. See if you can make it better.