data

来自「OTP是开放电信平台的简称」· 代码 · 共 101 行

%S0
{tables,
 [{employee, [{attributes, [emp_no,name,salary,sex, phone,room_no]}]},
  {dept, [{attributes, [id, name]}]},
  {project, [{attributes, [name, number]}]},
  {manager, [{attributes, [emp, dept]},
             {type, bag}]},
  {at_dep, [{attributes, [emp, dept_id]}]},
  {in_proj, [{attributes, [emp, proj_name]}, 
             {type, bag}]}
  ]
}.

%E0


%S1
{employee, 104465, "Johnson Torbjorn",   1, male,    99184, {242,038}}.
{employee, 107912, "Carlsson Tuula",     2, female,  94556, {242,056}}.
{employee, 114872, "Dacker Bjarne",      3, male,    99415, {221,035}}.
{employee, 114849, "Armstrong Josef",    3, male,    99452, {221,023}}.
{employee, 114952, "Froberg Magnus",     5, male,    99469, {222,018}}.
{employee, 104531, "Nilsson Hans",       3, male,    99495, {222,026}}.
{employee, 104659, "Tornkvist Torbjorn", 2, male,    99514, {222,022}}.
{employee, 104732, "Wikstrom Claes",     2, male,    99586, {221,015}}.
{employee, 117716, "Fedoriw Anna",       1, female,  99143, {221,031}}.
{employee, 115020, "Hansson Catrin",     6, female,  99129, {222,072}}.
{employee, 115018, "Mattsson Hakan",     3, male,    99251, {203,348}}.
{employee, 113069, "Eriksson Morgan",    6, male,    99186, {241,543}}.
%E1

%S2
%% departments
{dept, 'B/SF',  "Open Telecom Platform"}.
{dept, 'B/SFP', "OTP - Product Development"}.
{dept, 'B/SFR', "Computer Science Laboratory"}.
%E2


%% projects
%S3
{project, erlang, 1}.
{project, otp, 2}.
{project, beam, 3}.
{project, mnesia, 5}.
{project, wolf, 6}.
{project, documentation, 7}.
{project, www, 8}.

%E3



%% manager
%S4
{manager, 104465, 'B/SF'}.
{manager, 104465, 'B/SFP'}.
{manager, 114872, 'B/SFR'}.

%E4
%S5
{at_dep, 104465, 'B/SF'}.
{at_dep, 107912, 'B/SF'}.
{at_dep, 114872, 'B/SFR'}.
{at_dep, 114849, 'B/SFR'}.
{at_dep, 114952, 'B/SFR'}.
{at_dep, 104531, 'B/SFR'}.
{at_dep, 104659, 'B/SFR'}.
{at_dep, 104732, 'B/SFR'}.
{at_dep, 117716, 'B/SFP'}.
{at_dep, 115020, 'B/SFP'}.
{at_dep, 115018, 'B/SFP'}.
{at_dep, 113069, 'B/SFP'}.


%E5
%S6
{in_proj, 104465, otp}.
{in_proj, 107912, otp}.
{in_proj, 114872, otp}.
{in_proj, 114849, otp}.
{in_proj, 114849, erlang}.
{in_proj, 114952, otp}.
{in_proj, 104531, otp}.
{in_proj, 104531, mnesia}.
{in_proj, 104545, wolf}.
{in_proj, 104659, otp}.
{in_proj, 104659, wolf}.
{in_proj, 104732, otp}.
{in_proj, 104732, mnesia}.
{in_proj, 104732, erlang}.
{in_proj, 117716, otp}.
{in_proj, 117716, documentation}.
{in_proj, 115020, otp}.
{in_proj, 115018, otp}.
{in_proj, 115018, mnesia}.
{in_proj, 113069, otp}.

%E6