SQL> CREATE TABLE Employee (
  2          BSB#            CHAR(6),                  /* Bank BSB number            */
  3          E#              CHAR(5)         NOT NULL, /* Employee number            */
  4          Name            VARCHAR2(30)    NOT NULL, /* Employee name              */
  5          DOB             Date,                     /* Date of birth              */
  6          Address         VARCHAR2(50),             /* Home address               */
  7          Sex             CHAR,                     /* M-Male, F-Female           */
  8          Salary          NUMBER(7,2),              /* Salary                     */
  9          Supervisor#     CHAR(5),                  /* Supervisor number          */
 10          CONSTRAINT Employee_PK PRIMARY KEY(BSB#, E#),
 11          CONSTRAINT Employee_FK1 FOREIGN KEY (BSB#, Supervisor#) REFERENCES Employee(BSB#, E#),
 12          CONSTRAINT Employee_FK2 FOREIGN KEY (BSB#) REFERENCES Bank (BSB#)
 13  );


CREATE TABLE Bank (
  2          BSB#            CHAR(6)         NOT NULL, /* Bank BSB number            */
  3          Name            VARCHAR2(40)    NOT NULL, /* Bank name                  */
  4          Address         VARCHAR2(50)    NOT NULL, /* Bank location              */
  5          Manager#        CHAR(5)         NOT NULL, /* Department manager number  */
  6          MSDate          DATE,                     /* Manager start date         */
  7          Phone#          VARCHAR2(15)    NOT NULL, /* Contact phone number       */
  8          CONSTRAINT Bank_PK PRIMARY KEY(BSB#),
  9          CONSTRAINT Bank_CK1 UNIQUE(Name)
 10  );

ALTER TABLE bank
ADD CONSTRAINT bank_manager_fk
FOREIGN KEY (manager#) REFERENCES employee(e#)

ALTER TABLE bank
ADD CONSTRAINT bank_manager_fk
FOREIGN KEY (manager#, bsb#) REFERENCES employee(e#, bsb#)