CISC437/637 Spring 2013, Homework 5
Due Wednesday, 4/24, at 11:55pm on Sakai.
1. 5 pts. Answer the following questions about data on external storage in a DBMS:
Why are disk I/O costs important in a DBMS?
Use the simplied cost model presented
CISC437/637 Spring 2013, Homework 1
Due Sunday, 2/17, at 11:55pm on Sakai and on orioles1
For this homework you will need to be able to access your MySQL database on orioles1. If you
cannot access it, please let me know ASAP.
The following diagram represe
CISC437/637 Spring 2012, Homework 6
Due Wednesday May 8 at 11:55pm on Sakai.
This assignment uses the University database schema; see page 4 for the diagram.
1. [30 pts] The tables below show the (abridged) output of MySQL EXPLAIN for three die
CISC637, Lecture #27
Copyright Ben CartereAe
Given a SQL query, construct an evalua&on plan
Evalua/on plan consists of:
Rela/onal algebra expression
CISC437 Spring 2016, Homework 1
Due date Friday, Feb 19, at 11:55pm on Sakai. You will need to install MySQL on your own
computer. You can download it from http:/dev.mysql.com/downloads/ (choose the MySQL
Community Server), and there are installation inst
CISC437 Spring 2016, Homework 2
Due Monday March 7th in class and on Sakai.
This homework asks you to draw E-R diagrams. Turn in the E-R diagrams in class, and the rest
of the assignment on Sakai by midnight on the 7th.
1. [15 pts] West Central
CISC437 Spring 2016 Course Project
Due Thursday May 26 at 11:55pm on Sakai.
For this project, you will design a database for stackoverflow.com, a large question-and-answer website for
programming. Real data from the site will be provided to populate your
Triggers, Func:ons, and
CISC437, Lecture #18
Copyright Ben CartereDe
Database Design and
Database design is about how to dene
CISC437, Lecture #11
Copyright Ben Cartere?e
Every airplane has a registra+on number, and each airplane is of a specic model.
The airport acco
CISC437/637 Database Systems Final Exam
You have from 3:30pm to 5:30pm to complete the following questions. No notes, no book, no wireless (or
wired) devices are allowed. Use the back of the page if you need more space.
Please read the following:
CISC437 Database Systems Midterm Exam
You have from 2:00 to 3:15pm to complete the following questions. No notes, no book, no wireless (or wired)
devices are allowed. Use the back of the page if you need more space. Good luck!
Multiple Choice (2 points ea
Rela*onal Database Design
CISC437, Lecture #10
Copyright Ben Cartere@e
Database Design Process
Start with enterprise requirements
Translate to a conceptual model
Translate to a logica
Model Answers to Assignment 1
For these exercises, I recommend that you write a sequence of assignment statements of the form R := . . . with Answer as the last variable assigned a value. Just be sure that it is unambiguous what the attributes of each com
CISC437 Spring 2016, Homework 3
Due Monday, March 21, at 11:55pm on Sakai.
Assignment - each question is worth 11 points for a total of 99. Show your work to ensure the
best chance of getting a high grade.
1. Suppose we have a rela
Model Answers to Assignment 2
Each exercise is worth 10 points. In your personal database, write and execute MySQL commands for the following actions. 1. Create a table called 'actor' with the following fields: guild_id, an integer last_name, a variable-l
Model Answers for Assignment 3
Each exercise is worth 10 points (40 points total). 1. Exercise 3.2.1.
The attributes are ABCD. We are given the FDs AB C, C D, and D A. (a) Consider all the possible left sides of a FD, namely, the non-empty subset
Model Answers to Assignment 4
Since this assignment involves making a lot of diagrams, handwritten submissions while be allowed, though diagrams made with the built-in drawing facilities of Word or other software is preferred. Each exercise is worth 10 po
CISC437/637 Spring 2013, Homework 4
Due Monday, 4/8, at 11:55pm on Sakai.
Recall the university database you implemented for HW1. For this assignment you will write a
very simple application to update and query that database. We covered the JDB
CISC437/637 Spring 2012, Homework 2
Due Sunday March 3rd at 11:55pm on Sakai.
This homework asks you to draw an E-R diagram. I recommend that you use PowerPoint, OpenOfce, or a similar tool to make a diagram suitable for electronic submission.
CISC437/637 Spring 2012, Homework 3
Due Sunday, 3/17, at 11:55pm on Sakai.
1. [5 pts.] Consider a relation R with ve attributes a, b, c, d, e. You are given the following
cfw_b, c e
cfw_e, d a
Find all candidate keys
1) Consider a relation R with ve attributes a, b, c, d, e. You are given the following functional
BCNF and 3NF
CISC437 Lecture #13
Copyright Ben Cartere9e
You have a set of FDs and one or more relaJons
You want to know if each relaJon is in BCNF