CSC 122
Web Database Applications

Syllabus

Schedule

Project

Assignments+grading

Course Description
Introduces students to database management systems, their structure and usage, with lecture and lab components. Particular emphasis on database access via Web interfaces. Topics will include connectivity between Web pages and databases. Covers an introduction to SQL, the standard relational DBMS query language, as well as selected topics on Web application implementation. Prerequisite: HTML and Problem Solving with Programming (CSc 80,  CSc10 or CSc 22). 3 units.

CSC 122     TR     5:30- 6:45pm  RVR 5029 

Office Hours: MW 4pm - 5:30pm or by appointment.

Texts

Required

Luke Welling, Laura Thomson, "PHP and MySQL Web Development", 3rd/4th edition, Sams publishing, 2007/2008.

References

Online PHP and MySQL resource, book chapters from  Safari Books Online
(How to access Safari from home)

1. Raghu Ramakrishnan, and Johannes Gehrke, " Database Management Systems", Third Edition, Mc Graw Hill, 2003

2. Paul DuBois, "MySQL: The definitive guide to using, programming, and administering MySQL 4.1 and 5.0", Third Edition, Sam's Publishing, 2005

3. Paul DuBois, "MySQL Cookbook", O'Reilly, 2002.

4. Hugh E. Willams, David Lane, "Web Database Applications with PHP and MySQL", O'Reilly, 2nd edition, 2004.

Class Web Page

Students are expected to have basic knowledge in web site development using HTML. This  resources page is for those who need catch up with web page development and course work. 

Notes

1.  Any adjustment to this syllabus will be announced in class and posted on the web page. Class attendance is very important. Each student is responsible for any additional material to be discussed or distributed in class.

2.  No make-up test will be arranged unless there is a serious and compelling reason. Instructor must be notified prior to a test.  

3.  The term project is an important and integral part of the course. Thus, you should start the project as early as possible. You are strongly encouraged to communicate with the instructor during the entire project development process.

4.  Be aware of Department and University's policies on drop, incomplete and academic honesty.

Mailing List: There is a class mailing list (csc122lu) to be used for class-related discussion and posting. You should subscribe to the list during the first week of the semester. Refer to the command list for the frequently used majordomo mailing list commands. Every student in the class is expected to subscribe to the csc122lu mailing list.  This list is sort of like a bulletin board.  Any mail sent to the list is automatically re-directed to every e-mail account that is subscribed to the list.  Therefore, the list can be used (by instructor) to send information to all students in the class (for example, when I recognize an error in an assignment or something like that).  The list can also be used as a discussion group for CSc 122-related material.  While there are obviously some limits on what you should be discussing (answers to assignments would be going beyond the limits), you are welcome to use the list to send requests for clarification of issues in the text, lab, lecture, or assignments.  Another student might answer directly to you, or someone might post an answer back to the entire list group, or I might answer directly to you or to the entire group.  Please reserve this list for CSc 122-related information only.  

To subscribe to the csc122lu mailing list, send an e-mail message from your campus email account (some off-campus email service has restrictions and may miss our emails to the class list). Address it to:

majordomo@ecs.csus.edu

 Do not put anything in the subject line.  In the body of the mail message, put only:

subscribe csc122lu

                end

 Notice that you do not include your mailing address that is taken automatically from the return address, and it is that return address account that gets subscribed to the list.  Also notice that there is no space in the name of the list, csc122lu.

 Be sure your email program is not sending mail in html format.  Set it to send only plain text.

 If you are successful in getting on the list, you will receive a message that specifically welcomes

General Interests

CSUS Web Templates Download  |  WWWebster Dictionary  |  Grammar Help