interface Anag (
source relational University
key (First_Name, Last_Name)
foreign_key (First_Name, Last_Name)
references Research_Staff
foreign_key (First_Name, Last_Name)
references School_Member
)
{
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
)
{
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)
)
{
attribute string
First_Name;
attribute string
Last_Name;
attribute string
Faculty;
attribute long Year;
};
|