Name_
EECS495 Introduction to Database Systems
Sample Midterm Questions
Fall 2015
Professor P. Scheuermann
Note: I have included 8 questions, which is much more then you will get on the
exam. The purpose is to help you review all the material that we cove

SQL Application Programming
Persistent Stored Modules (PSM)
Peter Scheuermann
1
SQL in Real Programs
We have seen only how SQL is used at the
generic query interface - an environment
where we sit at a terminal and ask queries of
a database.
Reality is alm

EECS 495 Fall 2015
Peter Scheuermann
Project No. 2 - SQL
Due Date November 4 , 2015 (11:59 pm)
The Assignment
Consider the following schema (similar to the one in the previous project, with only one
column added to the MADE_MONEY table):
APPEARED_IN (STAR

# DOCUMENTATION
# =
# Class node attributes:
# -# children - dictionary containing the children where the key is child number
(1,.,k) and the value is the actual node object
# if node has no children, self.children = None
# value - value at the node
#
#
#

Jayalakshmi Jain jjk6400
1)
Alcohol. This is because the histograms of the instances labeled as good and bad wine have the least overlap as compared to the other attributes. So on choosing a value along the x-axis (approx. 11), we can roughly classify the

SQL SUPPLIMENT
VIEWS
Peter Scheuermann
Views
A
2
view is like a virtual table
Defined by a query, which describes how to compute the
view contents on the fly
DBMS stores the view definition query instead of view
contents
Can be used in queries just lik

Transactions
Peter Scheuermann
Transaction Concept
Many enterprises and organizations use databases to store
information about their state
e.g., Balances of all depositors at a bank
When an event occurs in the real world that changes the
state of the e