CREATE TABLE room(
id VARCHAR(50) NOT NULL PRIMARY KEY,
roomNum VARCHAR(50),
numBedsAttribID VARCHAR(50),
smokingOrNoAttribID VARCHAR(50),
onFloorAttribID VARCHAR(50),
sizeOfRoomAttribID VARCHAR(50),
FOREIGN KEY (numBedsAttribID) REFERENCES numBedsAttribute (id),
FOREIGN KEY (smokingOrNoAttribID) REFERENCES smokingAttribute (id),
FOREIGN KEY (onFloorAttribID) REFERENCES onFloorAttribute (id),
FOREIGN KEY (sizeOfRoomAttribID) REFERENCES sizeOfRoomAttribute (id)
);

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

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

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

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