CREATE TABLE oneRoom(
id VARCHAR(50) NOT NULL PRIMARY KEY,
roomNum VARCHAR(50),
hasNumBedsAttribID VARCHAR(50),
hasOnFloorAttribID VARCHAR(50),
hasSmokingPreferenceAttribID VARCHAR(50),
FOREIGN KEY (hasNumBedsAttribID) REFERENCES numBeds (id),
FOREIGN KEY (hasOnFloorAttribID) REFERENCES onFloor (id),
FOREIGN KEY (hasSmokingPreferenceAttribID) REFERENCES smokingPreference (id)
);

CREATE TABLE suite(
id VARCHAR(50) NOT NULL PRIMARY KEY,
roomNum VARCHAR(50),
hasNumBedsAttribID VARCHAR(50),
hasOnFloorAttribID VARCHAR(50),
hasSmokingPreferenceAttribID VARCHAR(50),
FOREIGN KEY (hasNumBedsAttribID) REFERENCES numBeds (id),
FOREIGN KEY (hasOnFloorAttribID) REFERENCES onFloor (id),
FOREIGN KEY (hasSmokingPreferenceAttribID) REFERENCES smokingPreference (id)
);

CREATE TABLE townHouse(
id VARCHAR(50) NOT NULL PRIMARY KEY,
roomNum VARCHAR(50),
hasNumBedsAttribID VARCHAR(50),
hasOnFloorAttribID VARCHAR(50),
hasSmokingPreferenceAttribID VARCHAR(50),
FOREIGN KEY (hasNumBedsAttribID) REFERENCES numBeds (id),
FOREIGN KEY (hasOnFloorAttribID) REFERENCES onFloor (id),
FOREIGN KEY (hasSmokingPreferenceAttribID) REFERENCES smokingPreference (id)
);

CREATE TABLE numBeds(
id VARCHAR(50) NOT NULL PRIMARY KEY,
attrib VARCHAR(50)
);

CREATE TABLE onFloor(
id VARCHAR(50) NOT NULL PRIMARY KEY,
attrib VARCHAR(50)
);

CREATE TABLE smokingPreference(
id VARCHAR(50) NOT NULL PRIMARY KEY,
attrib VARCHAR(50)
);
