git.iko.soy/project-m36
on disk_format_proposal help sign in
project-m36/scripts/DateExamples.tutd
24 lines 1.3 kB history raw
1s := relation{tuple{s# "S1",sname "Smith",status 20, city "London"},
2 tuple{s# "S2",sname "Jones",status 10,city "Paris"},
3 tuple{s# "S3",sname "Blake",status 30,city "Paris"},
4 tuple{s# "S4",sname "Clark",status 20,city "London"},
5 tuple{s# "S5",sname "Adams",status 30,city "Athens"}};
6p := relation{tuple{p# "P1",pname "Nut",color "Red",weight 12,city "London"},
7 tuple{p# "P2",pname "Bolt",color "Green",weight 17,city "Paris"},
8 tuple{p# "P3",pname "Screw",color "Blue",weight 17,city "Oslo"},
9 tuple{p# "P4",pname "Screw",color "Red",weight 14,city "London"},
10 tuple{p# "P5",pname "Cam",color "Blue",weight 12,city "Paris"},
11 tuple{p# "P6", pname "Cog", color "Red",weight 19,city "London"}};
12sp := relation{tuple{s# "S1",p# "P1",qty 300},
13 tuple{s# "S1",p# "P2",qty 200},
14 tuple{s# "S1",p# "P3",qty 400},
15 tuple{s# "S1",p# "P4",qty 200},
16 tuple{s# "S1",p# "P5",qty 100},
17 tuple{s# "S1",p# "P6",qty 100},
18 tuple{s# "S2",p# "P1",qty 300},
19 tuple{s# "S2",p# "P2",qty 400},
20 tuple{s# "S3",p# "P2",qty 200},
21 tuple{s# "S4",p# "P4",qty 300},
22 tuple{s# "S4",p# "P5",qty 400}};
23foreign key sp2s sp{s#} in s{s#};
24foreign key sp2p sp{p#} in p{p#};