This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
diss_runningexample [2016/09/04 22:51] mgoller created |
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//__) | |
| - | % after \\: \hline or \cline{col1-col2} \cline{col3-col4} ... | + | | | **unit**(__shopid__, name, citycode, statecode) | |
| - | Relations & {\tt sales(units, priceperunit, timestamp, \it{prid}, \it{shopid}, \it{cid})} \\ | + | |
| - | & {\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 | ||
| Line 134: | Line 128: | ||
| \label{sampleProduct} | \label{sampleProduct} | ||
| \end{table} | \end{table} | ||
| - | \begin{table} | + | |
| - | \centering | + | |
| \begin{tabular}{|c|c|c|} | \begin{tabular}{|c|c|c|} | ||
| - | \hline | + | |
| - | \emph{groupid}&\emph{groupname}&\emph{ispartof}\\ | + | ^groupid^groupname^ispartof^ |
| - | \hline | + | ^1|book|NULL| |
| - | 1&book&NULL\\ | + | ^2|belletristic|1| |
| - | 2&belletristic&1\\ | + | ^3|scientificmonography|1| |
| - | 3&scientificmonography&1\\ | + | ^4|article|NULL| |
| - | 4&article&NULL\\ | + | ^5|webarticle|4| |
| - | 5&webarticle&4\\ | + | ^6|online journal|NULL| |
| - | 6&online journal&NULL\\ | + | Sample Entries of Table //productgroup// |
| - | \hline | + | |
| - | \end{tabular} | + | |
| - | \caption{Sample Entries of Table \emph{productgroup}} | + | |
| - | \label{sampleProductGroup} | + | |
| \end{table} | \end{table} | ||