This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 2 April 2009 CSE-3421 Test #1 (corrected) p. 1 of 10 CSE-3421 Test #1 “Design” Family Name: Given Name: Student#: CS Account: • Instructor: Parke Godfrey • Exam Duration: 75 minutes • Term: winter 2009 Answer the following questions to the best of your knowledge. The exam is closed-book and closed-notes. Questions will not be answered during the test. Should you feel a question needs an assumption to be able to answer it, write the assumptions you need along with your answer. If you need more room to write an answer, clearly indicate where you are continuing the answer. There are four major questions worth 10 points each for 40 points in total. Regrade Policy • Regrading should only be requested in writing. Write what you would like to be reconsidered. Note, however, that an exam accepted for regrading will be reviewed and regraded in entirety (all questions). Grading Box 1. /10 2. /10 3. /10 4. /10 Total /40 2 April 2009 CSE-3421 Test #1 (corrected) p. 2 of 10 1. E-R Design. Er, an E/R E-R, eh? (10 pts) [exercise] You have been recently hired by Duey, Cheatem, & Howe, Inc., (DC&H) as a database de- signer. (Unfortunately, you have been assigned as an assistant to the infamous chief database designer Dr. Datta Bas. So your job will include correcting Dr. Bas’s many logical mistakes.) DC&H is hired to construct a database for patient tracking in the emergency room of the Eiffel Badd Hospital. This has been assigned to your team. Specifications are as follows. An in-patient is someone who has been checked into the E/R (emergency room). The in- patient has associated a list of traumas (for instance, broken ribs, internal bleeding, and concussion). An in-patient may have one trauma or several. (These are the reasons why the in-patient is in the E/R!) The severity of each of the patient’s traumas should be recorded....
View Full Document
- Winter '09
- Relational model, Candidate key, Database normalization, BCNF, CSE-3421 Test