diff options
Diffstat (limited to 'Homework/cs5800/Homeworks/hw-6.org')
| -rw-r--r-- | Homework/cs5800/Homeworks/hw-6.org | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/Homework/cs5800/Homeworks/hw-6.org b/Homework/cs5800/Homeworks/hw-6.org new file mode 100644 index 0000000..0383c3f --- /dev/null +++ b/Homework/cs5800/Homeworks/hw-6.org @@ -0,0 +1,35 @@ +#+TITLE: Homework 6 +#+AUTHOR: Logan Hunt +#+LATEX_HEADER: \usepackage{amsfonts} \usepackage{amssymb} \usepackage{mathtools} \usepackage{ upgreek } \usepackage{ textcomp } +#+OPTIONS: tex:t toc:nil inlineimages fold + +* Question One +\sigma_(name='Peter Smith')(Client) + +* Question Two +\sigma_(frequency > 5)(AirtimePackage) + +* Question Three +\pi_(videoCode)(\sigma_(siteCode='S345')(Broadcasts)) + +* Question Four +\pi_(serialNo)(\sigma_(type='restaurant')(DigitalDisplay \bowtie_(serialNo=serialNo) Locates \bowtie_(siteCode=siteCode) Site)) + +* Question Five +\pi_(empId, name)(\sigma_(modelNo='M456781')(Specializes \bowtie_(empId=empId) TechnicalSupport)) + +* Question Six +\pi_(modelNo)(\sigma_(name='Peter')(Specializes \bowtie_(empId=empId) TechnicalSupport)) + +* Question Seven +\pi_(videoCode, videoLength)(Video \bowtie_(videoCode=videoCode)(\pi_(videoCode)(\sigma_(siteCode=111)(Broadcasts)) \minus \pi_(videoCode)(\sigma_(siteCode=112)(Broadcasts))) + +* Question Eight +\pi_(name)(TechnicalSupport) \cup \pi_(name)(Administrator) \cup \pi_(name)(Salesman) + +* Question Nine +\pi_(empId, name)(\sigma_(modelNo='MO1' AND siteCode=111)TechnicalSupport \bowtie_(empId=empId)(Specializes) \bowtie_(modelNo=modelNo)(DigitalDisplay) \bowtie_(serialNo=serialNo)(Locates)) + +* Question Ten +\pi_(empId, name)(SalesMan \minus \pi_(empId)(SalesMan \bowtie_(empId=empId) (Purchases))) + |