This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
diss_runningexample [2016/09/06 22:43] mgoller |
diss_runningexample [2016/09/06 23:11] (current) mgoller |
||
|---|---|---|---|
| Line 90: | Line 90: | ||
| these relations. | these relations. | ||
| - | \begin{table} | + | ^Relations | **sales**(units, priceperunit, timestamp, //prid//, //shopid//, //cid//) | |
| - | \centering | + | | | **product**(__prid__, name) | |
| - | \begin{tabular}{|lp{95mm}|} | + | | | **productgroup**(__groupid__, groupname) | |
| - | \hline | + | | | **isproductofgroup**(__//prid//__, __//groupid//__) | |
| - | ^Relations & {\tt sales(units, priceperunit, timestamp, \it{prid}, \it{shopid}, \it{cid})} \\ | + | | | **unit**(__shopid__, name, citycode, statecode) | |
| - | & {\tt product(\underline{prid}, name) } \\ | + | |
| - | & {\tt productgroup(\underline{groupid}, groupname), {\it ispartof}} \\ | + | |
| - | & {\tt isproductofgroup(\underline{\it{prid}}, | + | |
| - | \underline{\it{groupid}})} \\ | + | |
| - | & {\tt unit(\underline{shopid}, name, citycode, statecode)} \\ | + | |
| & {\tt customer(\underline{cid}, name, customertype, citycode, statecode)} \\ & \\ | & {\tt customer(\underline{cid}, name, customertype, citycode, statecode)} \\ & \\ | ||
| \hline | \hline | ||