COMPSCI 186 Study Guide - Midterm Guide: Query Optimization, Functional Dependency, Good Luck!!

41 views14 pages
8 Jan 2019
School
Professor

Document Summary

Discussion section day & time:____________ ta name: ___________ This is a closed book examination but you are allowed one 8. 5 x 11 sheet of notes (double sided). You should answer as many questions as possible. You should read all of the questions before starting the exam, as some of the questions are substantially more time-consuming than others. Write all of your answers directly on this paper. Be sure to clearly indicate your final answer for each question. Also, be sure to state any assumptions that you are making in your answers. Score: sql, join cost calculations, query optimization, er diagrams, functional dependencies. Question 1 sql [6 parts, 27 points total] For parts a-d, consider the following schema (primary keys are underlined): Takes (sid, cno : [7 points] write a sql query that returns the names (i. e. , snames) of students who have taken more courses outside their department than inside their department.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers

Related Documents

Related Questions