diff options
Diffstat (limited to 'Homework/cs5800/Homeworks/hw-6.tex')
| -rw-r--r-- | Homework/cs5800/Homeworks/hw-6.tex | 69 |
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 |
