| Routing/Approval: (chair’s initials/date) |
Department |
Division |
APC |
Senate |
Date of proposal: 4/10/06
Title: Database Applications
Department and Course Number: CSCI 321
Crosslisted? Yes No X If yes, crosslisting department and number:
Credit: 1/2 Hours/week: 6 in one module
One-time: or Permanent Offering: X
Instructor: Steven Huss-Lederman
How will this course be taught, given present staffing, without creating a course overload?
This course proposal is part of a comprehensive change to the computer science curriculum. The course load under this proposal will not create an overload.
Are there any course fees? If so, specify what the course fees are intended to cover.
None
Prerequisite(s):
Computer Science 131. Students are encouraged to take Computer Science 251 to have a background in PHP and script programming or have experience in creating programs.
Catalog description (50-150 words, please):
If applicable, include the following language at the end: “May be repeated for credit if topic is different.”
The design of modern database systems and their practical use is covered. The first part of the course introduces databases, the relational model and entity-relationship (ER) diagrams. Next, SQL is covered for implementation of ER diagrams and queries on the data. This is followed by ways to access databases through PHP and Java as well as web interfaces. If time permits and there is student interest, the setup and security of database systems are covered. An important aspect of this course is a team project to design and implement a solution to (a) common database application(s). The application(s) is(are) chosen based on student interests. This course offers students practical experience with databases and software implementations; it can be useful to students in disciplines outside computer science who wish to gain a practical understanding of databases.
Additional course content description (aims, purposes, etc.) beyond the catalog description:
An important objective of this course is that it be accessible and useful to students wishing to use databases in areas outside CS while still being useful to CS students. Thus, the course focuses on the ideas of database management systems (DBMS) that relate to their effective use and practical application. To firmly ground these ideas, a major, team project is accomplished that implements the ideas presented. To accommodate the potentially diverse backgrounds, the scope and focus of the project(s) will be decided each semester. This course is designed to serve as a self contained introduction to DBMS for non-CS students. It also servers as an introduction for further study of more CS oriented issue in DBMS for CS students.
The lettered/numbered lines below come from CC2001. Underlined
items are considered essential to a basic curriculum in computer science.
Numbers in () indicate minimum number of hours to cover in a lecture style
according to CC2001.
Items with
a * indicate we plan to cover them in multiple courses.
Other lines include additional topics we plan to cover or clarification of
topics
we will cover within a CC2001 topic.
Course goals/objectives/outcomes:
At the end of this course students should be able to:
Course structure. Check all that apply:
Lecture/Discussion X Studio Lab/Workshop X Other (Specify)
If current library or equipment holdings are inadequate, estimate the cost of additional holdings required.
adequate.
Please attach names of a proposed text and/or core readings.
Database Management Systems, 3rd Ed. by Raghu Ramakrishnan and Johannes Gehrke, 2003. ISBN 0-07-246563-8.
Form revised 11/04