-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsql-ecol-handout.tex
103 lines (97 loc) · 2.19 KB
/
sql-ecol-handout.tex
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
\documentclass[12pt]{article}
\usepackage{numprint}
\usepackage{placeins}
\usepackage{graphicx}
\graphicspath{ {img/} }
\usepackage{mathtools}
\usepackage{amsthm}
\usepackage{amssymb}
\usepackage{amsmath}
\usepackage{gensymb}
\usepackage{hyperref}
\usepackage{changepage}
\usepackage{multirow}
% Lesson Number - Lesson Title
\title{SQL Database}
\author{Phillip Doehle}
\usepackage{fancyhdr}
\pagestyle{fancy}
% Lesson Number
\lhead{my-data.sqlite}
% Lesson Title
\rhead{Rodent Survey Database}
\begin{document}
\newtheorem{theorem}{Theorem}[section]
\newtheorem{lemma}{Lemma}[section]
\newtheorem{proposition}{Proposition}[section]
\newtheorem{corollary}{Corollary}[section]
\newtheorem{defn}{Definition}[section]
\newtheorem{ex}{Example}[section]
% First Page (Database with Table Inside)
\begin{figure}
\begin{adjustwidth}{-0.5cm}{}
{\large
\begin{tabular}{| c c |}
\hline
\multicolumn{2}{| c |}{{\huge \textbf{my-data.db}}} \\
\hline
% Person and Site Tables
& \\
\begin{tabular}{| c | c |}
\hline
\multicolumn{2}{| c |}{plots} \\
\hline
\textit{plot_id} & \textit{plot_type} \\
1 & Spectab exclosure \\
2 & Control \\
$\vdots$ & $\vdots$ \\
23 & Rodent Exclosure \\
24 & Rodent Exclosure \\
\hline
\end{tabular} & \begin{tabular}{| c | c | c |}
\hline
\multicolumn{3}{| c |}{Site} \\
\hline
name & lat & long \\
DR-1 & -49.85 & -128.57 \\
DR-3 & -47.15 & -126.72 \\
MSK-4 & -48.87 & -123.4 \\
\hline
\end{tabular} \\
% Visited and Survey Tables
& \\
\begin{tabular}{| c | c | c |}
\hline
\multicolumn{3}{| c |}{Visited} \\
\hline
id & site & dated \\
619 & DR-1 & 1927-02-08 \\
622 & DR-1 & 1927-02-10 \\
734 & DR-3 & 1930-01-07 \\
735 & DR-3 & 1930-01-12 \\
751 & DR-3 & 1930-02-26 \\
752 & DR-3 & -null- \\
837 & MSK-4 & 1932-01-14 \\
844 & DR-1 & 1932-03-22 \\
\hline
\end{tabular} & \begin{tabular}{| c | c | c | c |}
\hline
\multicolumn{4}{| c |}{Survey} \\
\hline
taken & person & quant & reading \\
619 & dyer & rad & 9.82 \\
619 & dyer & sal & 0.13 \\
$\vdots$ & $\vdots$ & $\vdots$ & $\vdots$ \\
837 & lake & sal & 0.21 \\
37 & roe & sal & 22.5 \\
844 & roe & rad & 11.25 \\
\hline
\end{tabular} \\
& \\
\hline
\end{tabular}
}
\end{adjustwidth}
\end{figure}
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
\end{document}