CIS154 Course Samples

This page contains sample solutions to assignments after they are turned in. Assignment #8 Solutions Instructor's Solution: A single-page solution by the instructor. An extra feature is the capability to use other SQL statements than SELECT. Mostly this amounts to making sure that adding slashes does not make the query incorrect. Eiji Suzuki's Solution: Excellent solution with some nice extra-credit features! The PHP code is here (Hint: view the source, Luke). back to top Assignment #7 Solutions Instructor's Solution: A single-page solution by the instructor. (Hint: view the source, Luke.) Judit Sedillos's Solution: Excellent solution with all the extra-credit features! back to top Assignment #6 Solutions Instructor's Solution: A minimal solution by the instructor. Jean O'Reilly's Solution: Very nicely done. back to top Assignment #5 Solutions Instructor's Solution: A minimal solution by the instructor. back to top Assignment #4 Solutions Instructor's Solution: A list of fixes that occurred to the instructor. See the new Artzy2-create SQL here. back to top Assignment #3 Solutions Instructor's Solution: A minimal solution by the instructor. Iska Rabeendran's Solution: An nice job with a solution to the extra credit query. back to top Assignment #2 Solutions Instructor's Solution: A minimal solution by the instructor. You can view a diagram of the relationships here. Andrea Lee's Solution: An excellent job with a nice diagram the relationships. Don Taylor's Solution: Excellent work with an extra table of the relationships and their types. back to top Assignment #1 Solutions Instructor's Solution: A minimal solution by the instructor. back to top Home | WebCT | Announcements | Schedule | Syllabus Expectations | Help | FAQ's | HowTo's | Samples | Links Last Updated: 7/16/2003 5:37:33 PM