This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: . . Fall 2007 CSC/CPE 365: Database Systems Alexander Dekhtyar . . Lab 5: Lather, Rinse, Repeat Due date: There is no due date. The lab is to be completed during the October 25, 2007 lab period. This lab does not involve an outright submission. It is designed to give you the opportunity to practice and the opportunity to fix previously existing errors in your datasets. Lab Assignment Fixing things up This part of the assignemnt is to be done by each student individually, although I allow for consultations with me, or with your classmates, in case questions arise. Your first task for this lab is to ensure that your work for Labs 2 and 3 (and Lab 4 if necessary) is complete. In particular, completness means the following: • You have a working collection of SQL scripts that creates and popu- lates each of the five databases: BAKERY, CARS, CSU, MARATHON and STUDENTS. Here ”working” means that when the scripts are run in a proper sequence (setup, populate, test), no errors ocur and expected behavior (tables are created, all insertions are made, all con-...
View Full Document
- Spring '08
- Databases, CSU campus, CSU campuses