CSCE 520 Spring 2004 Midterm Examination, Exams of Computer Science

The csce 520 spring 2004 midterm examination for a database systems course. The examination consists of three questions worth a total of 50 points. The first question asks for definitions of specific terms used in the course. The second question requires constructing a class diagram and normalized relations based on a given form. The third question involves writing sql queries for various requests based on a provided database schema. Useful for university students taking a database systems course and is most likely associated with the typology of 'exams'.

Typology: Exams

Pre 2010

Uploaded on 09/02/2009

koofers-user-ob7
koofers-user-ob7 🇺🇸

10 documents

1 / 3

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
CSCE 520 – Spring 2004
Midterm Examination
March 26, 2004
Name:___________________________________________________
There are a total of 3 questions and 50 points on this examination. Points for each question are shown
beside the question. If you think a question is ambiguous, make and state a reasonable assumption.
The exam is closed book and closed notes. The use of calculators and similar-looking electronic
devices is not allowed. Show your work for possible partial credit. Answer all questions on this exam
paper. There is an extra sheet of paper at the end if you need more space for answers or for scratch
paper.
1. (10) Briefly define each of the following terms in the context of this course.
a. Cascading delete
b. Combo box
c. Report footer
d. Reflexive join
e. Switchboard form
pf3

Partial preview of the text

Download CSCE 520 Spring 2004 Midterm Examination and more Exams Computer Science in PDF only on Docsity!

CSCE 520 – Spring 2004

Midterm Examination

March 26, 2004

Name:___________________________________________________

There are a total of 3 questions and 50 points on this examination. Points for each question are shown beside the question. If you think a question is ambiguous, make and state a reasonable assumption. The exam is closed book and closed notes. The use of calculators and similar-looking electronic devices is not allowed. Show your work for possible partial credit. Answer all questions on this exam paper. There is an extra sheet of paper at the end if you need more space for answers or for scratch paper.

  1. (10) Briefly define each of the following terms in the context of this course.

a. Cascading delete

b. Combo box

c. Report footer

d. Reflexive join

e. Switchboard form

  1. (10) Consider the following form that might be used by a shipping company to keep track of employee records. Assume that an employee may have multiple pieces of equipment checked out. Also assume that the cell phone and office belong to the employee, not his/her manager. Construct a class diagram and a set of appropriately normalized relations to represent the information in this form. Specify what normal form your relations are in.