Which attributes would be in the placement table?

How would you write the create table statement if it is one to one relationship? Would this be correct

CodePudding user response：

There is no need to have x and y in the Placement Table and the sid. I would do it like this:

CREATE TABLE Placement (
  pid int NOT NULL,
  is_critical bool,
  PRIMARY KEY (pid),
  FOREIGN KEY (hid) REFERENCES Hold(hid),
  FOREIGN KEY (rid) REFERENCES Route(rid),
  FOREIGN KEY (sid) REFERENCES Slot(sid));