Dr. Huaqing Wang
Dr. H. Wang, Professor
Computer Science Department
California State University, Bakersfield
Bakersfield, CA 93311-1022
Tel: (661) 654-2357, Fax: (661) 654-6960
Check Your Grades
Course:
Password:

Group Study
CSUB | Directory | My CSUB | CSUB Email | CSUB Books
CS Department | E Mail To: Huaqing Wang at csub.edu

Announcement
CMPS 342 textbook (from Fall 2007): Fundamentals of Database Systems (ISBB:0-13-608620-9/987-0-688620-8), 6th Edidtion, by Elmasri & Navathe, published by Addison Wesley.
Paul Schoberg, a composer, musician, and computer scientist graduated from CSUB. To listen and/or buy his beautiful recordings visit his website at Go there and search for "SCHOBERG"

To be able to use Oracle thin JDBC driver and to use java email related classes and interfaces, add the following directories into CLASSPATH environment variable: /usr/java1.2/lib1.2/classes12.zip:/usr/opt/java121:/usr/opt/java121/javamail-1.1.3/mail.jar:/usr/opt/java121/jaf-1.0.1/activation.jar: On sumatra, the mail.jar (JavaMail 1.3) and activation.jar files are in /usr/j2se/lib/mail.jar and /usr/dt/appconfig/sdtpdasync/classes/activation.jar repectively.
Notice that the lastest mail.jar and activation.jar files may be at different locations from what are listed here. Try to find paths of these two files first and add the paths in the CLASSPATH environment variable.

If you try to use PUTTY to telnet/connect to sleipnir at home or any machine at CSUB without heilios being saved in the "Saved Sessions", you can add sleipnir to the saved sesssion in 4 steps; (1) Put "sleipnir.cs.csubak.edu" or "136.168.201.112" in "Host Name (or IP address)" box, (2), select SSH as connection type. (3) type a "sleipnir" or any other string under the "Saved Sessions", (4) Click "Save" button.

Syllabi & Assignmnets
Class/HW# 1 2 3 4 5 6 7 8 9 10
Get Ready for CMPS 3390 class
For those who will take CMPS 3390 next semester.
CMPS 3390 Syllabus Java vs. C++
Java Syntax (partial)

Assig. 1: Java OOP
Due ...
Assign. 2: List Structures
Due: Announced in class
Assign. 3: Hashtable
Due: Announced in class
Assign. 4: Heap and Heap-sort
Due: Annonced in class
Assign. 5: Multi-Treaded & Multi-Level 2-Way Merge Sort
Due: Annonced in class
CMPS 3420
Syll. &
Description
phase I: Info. Gethering
and ER-Modelling

Due ...
Lab 1: Get ready
Date ...

Form 2-person team and work as team for the quarter.
Send your project to hwang@csub.edu
Use last 4 digits of ID to read your grades and comments.
Verify your email address registered with CUSB.
Lab 2: Use E-R model to design a conceptual database.
Midterm Date: 10/25
Phase II: Relation
vs. E-R Model

Due 10/16

Lab 3: Study the reasons and methods of converting ER to Relational Database. Lab on Relational Algebra
Lab 4: Answer the Hotel related queries in Relational Algebra.
Lab 5: Answer the Hotel related queries in Relational Calculus.
Phase III: Implementation of
Relational Database

Due ..

SQL/Plus Commands


Oracle Create Table


Oracle Table Creation 1 2 3 4 5

Oracle 8.0 Data Types


Comparisons of ANSI and Oracle Data Types
Phase IV: Stored Procedures
Due ...

PL SQL Files
(pl_sql_ch0x.htm)
Final Phase: User Interface Design and Implementation
Important: Make sure you answer each of the 4 questions in your final report.

3/13/2016 Sunday (2:00pm ... ) Room 311 Final presentations

3/14/2016 Monday (Midnight) The final written report document.
Put your major and track by your name on the front page of the project document.
Phases received:
CMPS 342 Database Systems
Updated May 20 2016: Summer Study Guide for Database Courses to be offered next term.

How to hand in your assignment:
1. Name your source file that contains main/entry code as XYyyydd.cpp or XYyyydd.java, where X is the your first initial, Yyyy are the first 4 letters of your last name, and dd are the 2-digit number indicating the assignment number. If the assigment number is less than 10, pad it with zero.
2. Put all source files for that homework in a subdirectory.
3. Zip all your source files (no binary/executable files) into a zip file with the command of the format: $ zip XYyyydd.zip *.cpp *.h. where X, Y and d have the the meanings defined above. Please notice that '$' is OS command prompt; don't type '$' before the command 'zip'.
4. (1) Use 'pine' to send your zip file (named XYyyydd.zip) to hwang@cs.csubak.edu, (2) Type the zip file name and course number as the Attachment Comment.

Java/Android: Android Developers | Android All Classes | NetBeans | Java Lang. Spec | Java Tutorials | Java 7 | More on Java | C# Grammar | PHP 5: Tutoriall and Reference | PHP | Examples of Servlets, JSP, Web Socket | H. Wang's Examples of Servlets, RMI (Ex.) | Applets (Ex.) | Group Study
JavaScrpt: XHMLT Test | Sorting | JavaSript Guide
Chinese Website: 中国音乐 | 1-Ting YingYue | 乐视 TV | 优酷 | 枫林网 | 360个人图书馆 | UUSee | 悉尼中文电视 影视频道 | P2P Sports | My P2p Sports | 华夏文摘 | Xin Lang | Wan Wei | So Hu
文学城 | 书画艺廊 | 东西南北论坛 | Typing Chinese | Type Chinese On-line | Cooking Classroom
Chinese Calligraphy: 书法空间 | US Hua Shu Fa Wang | Zhong Hua Shu Fa Wang | Zhong Guo Shu Fa Wang | Document for GNU Image Manipulation Program | CuiZhiJingMi | Huaqing's Calligraphic Practices
Others: Oracle 9i | Bakersfield Table Tennis Club | Airline Tickets | Chinese New Year