Esempio: traduzione in ODLI3

interface Anag (
  source relational University
  key (First_Name, Last_Name)
  )
  {
    attribute string First_Name;
    attribute string Last_Name;
    attribute string Address;
    attribute string City;
    attribute string e_mail;
  };

interface Course (
  source relational University
  key (Course_Code)
  foreign_key (Room_Code) references Room
  )
  {
    attribute string Course_Name;
    attribute long Course_Code;
    attribute long Length;
    attribute long Room_Code;
  };

interface Department (
  source relational University
  key (Dept_Code)
  )
  {
    attribute string Dept_Name;
    attribute long Dept_Code;
    attribute long Budget;
    attribute string Dept_Area;
  };

interface Research_Staff (
  source relational University
  key (First_Name, Last_Name)
  foreign_key (Course_Code) references Course
  foreign_key (Dept_Code) references Department
  foreign_key (First_Name, Last_Name) references Anag
  )
  {
    attribute string First_Name;
    attribute string Last_Name;
    attribute string Relation;
    attribute long Dept_Code;
    attribute long Course_Code;
  };

interface Room (
  source relational University
  key (Room_Code)
  )
  {
    attribute long Room_Code;
    attribute long Seats_Number;
    attribute string Notes;
  };

interface School_Member (
  source relational University
  key (First_Name, Last_Name)
  foreign_key (First_Name, Last_Name) references Anag
  )
  {
    attribute string First_Name;
    attribute string Last_Name;
    attribute string Faculty;
    attribute long Year;
  };
 


Indice
Descrizione
Tabelle
Popolazione strutture dati