CURRICULUM PROPOSAL FORM #3
UNIVERSITY OF WISCONSIN-WHITEWATER

NEW COURSE


 
Effective: Fall, 2001 If adding a Graduate component to an existing course, check here ___
Course Number: * 765-482   Cross Listed Number:  
Course Title: Web Database Development  

(limited to 65 characters)
 
15 Character Abbreviation: Web Database
25 Character Abbreviation: Web Database Development

 
 
Sponsor: Bennette Harris   E-mail Address: harrisb@mail.uww.edu
Department: Mathematical and   College: Letters and Sciences
  Computer Sciences      
Co-sponsor:     E-mail Address:  
Department:     College:  
  * You MUST verify course numbers with Registrar's Office prior to submitting (x1211)

 
 
Other Programs Affected: None

 
 
Check if course is to meet any of the following requirements:
__ None __ Writing __ Computer __ Diversity __ General Ed and Area  

 
 
Credit/Contact Hours: (per semester)
Total lab hours: 0   Total lecture hours: 48
Number of credits: 3   Total contact hours: 48

 
 
Check if course is repeatable: X No _ Yes (if yes, answer the following questions)
  • No of times in major 
     No of credits in major  
  • No of times in degree 
     No of credits in degree  

 
 
Enter the appropriate titles if the course is required in any of the following:
Major Title(s)          
Minor Title(s) Web Site Design and Administration        
Emphasis Title(s) Cert. in Web Site Design and Admin.        

Course justification:
Web site design and administration is perhaps one of the fastest growing areas in the modern information and technology-driven world. Typical programs of study tend to focus on either document design or web server technologies and systems. The minor and certificate programs offered by the Department of Mathematical and Computer Sciences is designed to bridge the gap smoothly between these two extremes by combining skills in the latest document design systems and paradigms with a deep understanding of the background technologies that drive document delivery and processing.

The object of most web sites is to deliver or exchange information. In the more sophisticated scenarios, this information must flow from or to an underlying database. The ability to combine web design skills together with the knowledge necessary to communicate with a database through an appropriate interface is one of the capstone skills of the professional web designer.
 

Relationship to program assessment objectives:
The proposed course extends the Department’s ability to expose students to cutting-edge technologies, and to allow them to compete in the current job market. This course is a key component in the Department’s overall strategy for offering programs that offer the very latest in skills needed by our graduates.

The course provides a wide range of problem-solving opportunities designed to enhance students’ critical thinking skills.
 

Budgetary impact:
The Mathematical and Computer Sciences Department currently has faculty able to teach the proposed course. The Department also has been allocated an additional position by the College of Letters and Sciences and is conducting a search for a person to augment the skills already present within the Department. With the additional staff, and with the computer facilities already available, no additional resources should be required initially.
 

Course description:
This course will introduce students to MySQL databases and PHP3 scripting on a UNIX platform. Students will create and interact with databases via the web. Topics will include SQL; creating, accessing and updating server-side databases; a variety of database-to-web interface tools; and the PHP embedded scripting language. Transactions with other database products via PHP will also be considered.
 

Course requisites:
Prerequisites 765-381 JavaScript and DHTML and 765-382 Perl and CGI Scripting, or equivalent preparation and consent of instructor.
 

If dual listed, list graduate level requirements for the following:

1. Content (e.g., What are additional presentation/project requirements?) N/A

2. Intensity (e.g., How are the processes and standards of evaluation different for graduates and undergraduates? ) N/A

3. Self-Directed (e.g., How are research expectations differ for graduates and undergraduates?) N/A


Course objectives and tentative course syllabus:
Course Objectives:
Upon successful completion of this course, learners will be familiar with


Tentative Syllabus:
Purpose of the Course:
This course will introduce students to MySQL databases and PHP3 scripting on a UNIX platform. Students will create and interact with databases via the web. Topics will include SQL; creating, accessing and updating server-side databases; a variety of database-to-web interface tools; and the PHP embedded scripting language. Transactions with other database products via PHP will also be considered.

Grading:
Hour Exams: 3 @ 150 pts each: 450
Projects: 450
In-class work: 100
Final Exam: 500
Total: 1500

The final course grade will be assigned as follows: A: 90% or better; B: 80 - 89%; C: 70 - 79%; D: 60 - 69%; F: below 60%. Passing course grades will be awarded only to those students who turn in all programming assignments and take all scheduled examinations.
 

Tentative Course Outline:
Weeks 1-2:

Weeks 3-4: Weeks 5-6: Weeks 7-8: Week 9: Weeks 10-11: Week 12: Week 13: Week 14: Weeks 15-16:

Bibliography: (Key or essential references only. Normally the bibliography should be no more than one or two pages in length. Indicate current library holdings by placing an asterisk [*])

Anonymous (1999). Maximum Linux Security. Sams.

Bakken, Stig Sæther, Egon Schmid, et al. (2000). PHP Manual (www.phpbuilder.com/manual/). PHP Documentation Group.

Barkakati, Naba (1996). UNIX Webmaster Bible. IDG Books.

Frisch, ?leen (1995). Essential System Administration, 2nd Edition. O’Reilly.

Garfinkel, Simson & Gene Spafford (1996). Practical UNIX & Internet Security, 2nd Edition. O’Reilly.

Ju, Patricia (1997). Databases on the Web. M&T Books.

Killelea, Patrick (1998). Web Performance Tuning: Speeding Up the Web. O’Reilly.

Laurie, Ben & Peter Laurie (1999). Apache: The Definitive Guide, 2nd Edition: Vital Information for Apache Programmers and Administrators. O’Reilly.

Loosley, Chris & Frank Douglas (1998). High-Performance Client/Server. Wiley.

Loukides, Mike (1990). System Performance Tuning. O’Reilly.

Petersen, Richard (1998). Linux Programmer’s Reference. Osborne/McGraw-Hill.

Purcell, John & Amanda Robinson (1996). The Linux Bible. Yggdrasil Computing.

Purcell, John (1997). Linux Man: The essential Man pages for Linux. RedHat Software.

Robbins, Arnold (1999). Unix in a Nutshell, 3rd Edition. O’Reilly

Spainhour, Stephen & Robert Eckstein (1999). Webmaster in a Nutshell, 2nd Edition. O’Reilly.