relaX-relations

-- this is an example
group: test 

Products = {
prod_sl:number, pname:string,cat:number
1,'Pro 1',1
2,'Pro 2',1
3,'Pro 3',3
4,'Pro 4',2
}

Categories = {
cid:number, cname:string
1,'stationary'
2,'cat 2'
3,'dumb'
4,'whatever'
}


Sale = {
id:number,prod_sl:number, cid:number,sdate:date,qty:number,price:number
1,1,1,2020-12-01,1,4.33
2,2,1,2020-12-01,1,4.33
3,3,3,2020-11-01,1,4.33
4,2,1,2020-12-08,1,4.33
5,1,1,2020-11-03,1,4.33
6,2,1,2020-12-09,1,4.33

}