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} | ||