summaryrefslogtreecommitdiff
path: root/Homework/cs5800/Homeworks/hw-6.tex
diff options
context:
space:
mode:
Diffstat (limited to 'Homework/cs5800/Homeworks/hw-6.tex')
-rw-r--r--Homework/cs5800/Homeworks/hw-6.tex69
1 files changed, 69 insertions, 0 deletions
diff --git a/Homework/cs5800/Homeworks/hw-6.tex b/Homework/cs5800/Homeworks/hw-6.tex
new file mode 100644
index 0000000..eec3bfe
--- /dev/null
+++ b/Homework/cs5800/Homeworks/hw-6.tex
@@ -0,0 +1,69 @@
+% Created 2022-11-26 Sat 14:04
+% Intended LaTeX compiler: pdflatex
+\documentclass[11pt]{article}
+\usepackage[utf8]{inputenc}
+\usepackage[T1]{fontenc}
+\usepackage{graphicx}
+\usepackage{longtable}
+\usepackage{wrapfig}
+\usepackage{rotating}
+\usepackage[normalem]{ulem}
+\usepackage{amsmath}
+\usepackage{amssymb}
+\usepackage{capt-of}
+\usepackage{hyperref}
+\usepackage{amsfonts} \usepackage{amssymb} \usepackage{mathtools} \usepackage{ upgreek } \usepackage{ textcomp }
+\author{Logan Hunt}
+\date{\today}
+\title{Homework 6}
+\hypersetup{
+ pdfauthor={Logan Hunt},
+ pdftitle={Homework 6},
+ pdfkeywords={},
+ pdfsubject={},
+ pdfcreator={Emacs 28.2 (Org mode 9.5.5)},
+ pdflang={English}}
+\begin{document}
+
+\maketitle
+
+\section{Question One}
+\label{sec:orgd978739}
+\(\sigma\)\textsubscript{(name='Peter Smith')}(Client)
+
+\section{Question Two}
+\label{sec:org8b645e7}
+\(\sigma\)\textsubscript{(frequency > 5)}(AirtimePackage)
+
+\section{Question Three}
+\label{sec:orgcc5745b}
+\(\pi\)\textsubscript{(videoCode)}(\(\sigma\)\textsubscript{(siteCode='S345')}(Broadcasts))
+
+\section{Question Four}
+\label{sec:org6ac4047}
+\(\pi\)\textsubscript{(serialNo)}(\(\sigma\)\textsubscript{(type='restaurant')}(DigitalDisplay \bowtie\textsubscript{(serialNo=serialNo)} Locates \bowtie\textsubscript{(siteCode=siteCode)} Site))
+
+\section{Question Five}
+\label{sec:orged1f22e}
+\(\pi\)\textsubscript{(empId, name)}(\(\sigma\)\textsubscript{(modelNo='M456781')}(Specializes \bowtie\textsubscript{(empId=empId)} TechnicalSupport))
+
+\section{Question Six}
+\label{sec:org779aa40}
+\(\pi\)\textsubscript{(modelNo)}(\(\sigma\)\textsubscript{(name='Peter')}(Specializes \bowtie\textsubscript{(empId=empId)} TechnicalSupport))
+
+\section{Question Seven}
+\label{sec:org1283914}
+\(\pi\)\textsubscript{(videoCode, videoLength)}(Video \bowtie\textsubscript{(videoCode=videoCode)}(\(\pi\)\textsubscript{(videoCode)}(\(\sigma\)\textsubscript{(siteCode=111)}(Broadcasts)) \(-\) \(\pi\)\textsubscript{(videoCode)}(\(\sigma\)\textsubscript{(siteCode=112)}(Broadcasts)))
+
+\section{Question Eight}
+\label{sec:org98cb969}
+\(\pi\)\textsubscript{(name)}(TechnicalSupport) \(\cup\) \(\pi\)\textsubscript{(name)}(Administrator) \(\cup\) \(\pi\)\textsubscript{(name)}(Salesman)
+
+\section{Question Nine}
+\label{sec:org1b1a92e}
+\(\pi\)\textsubscript{(empId, name)}(\(\sigma\)\textsubscript{(modelNo='MO1' AND siteCode=111)}TechnicalSupport \bowtie\textsubscript{(empId=empId)}(Specializes) \bowtie\textsubscript{(modelNo=modelNo)}(DigitalDisplay) \bowtie\textsubscript{(serialNo=serialNo)}(Locates))
+
+\section{Question Ten}
+\label{sec:orgd665945}
+\(\pi\)\textsubscript{(empId, name)}(SalesMan \(-\) \(\pi\)\textsubscript{(empId)}(SalesMan \bowtie\textsubscript{(empId=empId)} (Purchases)))
+\end{document} \ No newline at end of file