Time Allocated: 120 minutes
This is an OPEN book examination. Personal copies of textbook, supplementary book, and class notes can be used but
There are questions each with 6 parts. Use a blue book to answer these questions. Start answer to
Describe in your own words the purpose of the two business rules listed on page 102.
The purpose of these two business rules are if the employee has any relation to any
project, then then that employee data cannot be deleted until that project is deleted
Write an SQL CREATE TABLE statement to create the PET_OWNER table, with
OwnerID as a surrogate key. Justify your choices of column properties. Write SQL
Statements to insert the data in Figure 3-15 into the PET_OWNER table.
CREATE TABLE Pet_Owner (
Why is the study of database technology important?
Databases are used everywhere: They are key
components of e-commerce and other Web-based
applications. They lay at the heart of organization-wide
operational and decision support applications.
Which of the following is not true about a relation?
A) A relation is a two-dimensional table.
B) The cells of a relation must hold a single value.
C) A relation may have duplicate column names.
D) A relation may not have duplicate rows.
E) The order of t
Identity, Complicity, and Resistance in The Handmaid's Tale
Author(s): PETER G. STILLMAN and S. ANNE JOHNSON
Source: Utopian Studies, Vol. 5, No. 2 (1994), pp. 70-86
Published by: Penn State University Press
Stable URL: http:/www.jstor.org/stable/20719314
Just a Backlash: Margaret Atwood,
Feminism, and The Handmaids Tale
Margaret Atwood conceived the Republic of Gilead in The Handmaids Tale
as one logical outcome of what she termed the strict theocracy of the
fundamentalist government of the
Your essay should be around 1000 words long (not shorter than 900
and not longer than 1100). Anything longer or shorter means that
you will lose 10% of your 100% for the essay (1% of your overall
Course Number & Title: ENG102 Critical Reading and Writing- Section 3
Prerequisites: ENG 101
Class Location: A-B1-09
Meeting time: MW 8.00- 9.30
Instructor: Dr. Cho
There is a low a low chance to occur cross contamination by students because
they only touch a fruits bar and the bread.
The foods on other bars are offered by the employees of the cafeteria.
Cross contamination: the process by which bacteria or other
Write an SQL statement to display the OwnerLastName, OwnerFirstName, and
OwnerEmail of any owners of cats with the name Teddy. Use a subquery.
SELECT OwnerLastName, OwnerFirstName, OwnerEmail
WHERE PetType IN
Algorithm for base^exp:
Step 1: initialize base,exp,I,result=1
Step 2: input values of base and exp
Step 3: if exp=1 do
Step 4: if exp<0 do
Step 5: for i=1 toi<=exp do
Result = resu
qualities of good decision making
accurate, relevant, timely information
end user data
raw facts, of interest to the end user
description of data characteristics and set of
relationships that link the data in a database