title: Creating multiple foreign keys in SQL oracle
body: <pre><code>/* DROP TABLE STATEMENTS*/
  DROP TABLE BUILDING CASCADE CONSTRAINTS PURGE;
  DROP TABLE ROOM CASCADE CONSTRAINTS PURGE;
  DROP TABLE SPEAKER CASCADE CONSTRAINTS PURGE;
  DROP TABLE CONFERENCESESSION CASCADE CONSTRAINTS PURGE;
  
  /* CREATE TABLE STATEMENTS*/
  CREATE TABLE BUILDING(
  BUILDINGNO CHAR(2),
  BUILDINGWING VARCHAR2(15),
  BUILDINGLANE VARCHAR2(15),
  CONSTRAINT BUILDING_PK PRIMARY KEY(BUILDINGNO));
  
  CREATE TABLE ROOM(
  BUILDINGNO CHAR(2) ,
  ROOMNO CHAR(2),
  ROOMCAPACITY NUMBER(3), 
  CONSTRAINT ROOM_PK PRIMARY KEY(BUILDINGNO, ROOMNO));
  
  CREATE TABLE SPEAKER(
  SPEAKERID CHAR(2),
  SPEAKERNAME VARCHAR2(20),
  SPEAKERADDRESS VARCHAR2(50),
  SPEAKERPHONE CHAR(12),
  CONSTRAINT SPEAKER_PK PRIMARY KEY(SPEAKERID));
  
  CREATE TABLE CONFERENCESESSION(
  SESSIONID CHAR(4) PRIMARY KEY,
  BUILDINGNO CHAR(2) REFERENCES BUILDING(BUILDINGNO),
  ROOMNO CHAR(2) REFERENCES ROOM(ROOMNO),
  SPEAKERID CHAR(2) REFERENCES SPEAKER(SPEAKERID),
  SESSIONDATE DATE,
  SESSIONPRICE NUMBER(4, 2));
  </code></pre>
  
  <p>In the last table, I am supposed to have one PK (SessionID) and 3 Foreign Keys(BuildingNo, RoomNo, SpeakerID), When i try to do this i get no matching primary keys??
  Any help please? Thanks!!</p>