Syllabus for CMPS 3420, Database Systems
                          Dr. Huaqing Wang, Fall Semester 2016

       Office :           Science Building III, Room 323
       Phone :            654-2357
       Email Addresses :  hwang@csub.edu, hwang@cs.csubak.edu
       Home page:         http://www.cs.csubak.edu/~hwang/
                          (looking for information on homework,
                          handout, announcements, grades and sending your homework)

       Course Title:       Database Systems
 
       Course Description: Conceptual and logical database design
                           and implementation, relational database
                           theory, database management systems,
                           front-end, back-end application
                           software development tools/languages.
              For detail visit http://www.cs.csubak.edu/newsite/CS/CourseDescription/342_Description_v1.htm

       Prerequisites:      CMPS 2020 (or 213)and 2120 (or 295)
                           Learn C# or Java, and web-based/GUI techniques by yourself during the quarter.
                           See "Summer Study Guide for Database Course" under the CMPS 3420 course materials
                           on my website.
                            
       Textbook:     1. Fundamentals of Database Systems, 6th Ed.
                        by Elmasri & Navathe, published by Addison Wesley 
                            
                     2. Oracle 8/9/10, The complete reference (reference)

       Materials to be Covered: From the textbook
                      Introduction to methods, models, languages, tools, DBMS to be used
                      in designing and Implementing database-based appliction software.
 
                      Chapter 7, 8 (Conceptual database Design : Entity-Relationship
                          model and Exteneded E-R model)
                      Chapter 10   (UML)
                      Chapter 1, 2 (Introduction to databases system)
                      Chapter 3, 6 (Logical Database Design & Query Datavase :Relational
                                   model,its queryn languagesn - relational algebra and 
                                   tuple and domain relational calculus )
                      Chapter 9    (Translate ER/EER Database to Relational Database )
                      Chapter 10, 11 (Normalizations of relations)

                      Materials Added :  Case Studies
                              1. Oracle: Interactive SQL, Embedded SQL, Oracle PL/SQL, and 
                                 Stored Procedures and triggers (Reference to chapters 3 and 4)
                              2. Graphic User Interface, JDBC, C# (students will
                                 learn C# or Java before and during class by themselves).

       Time & Classroom:    1:00  --  2:15pm   M.W ( Sci. III 311)
                            1:00  --  3:30pm   Tues. ( Sci: III 311)

       Office Hour:         2:30 -- 3:30       Mon. &  Wed.
                            3:30 -- 4:30       Tue.
                               or by appointment


       Midterm:        Around week 8. The exact date will be announced one week
                       before exam date.
       Final Exam:     Final presentation will be decided toward the end of the quarter.

       Grading Policy: First 4 Phases of Project:     40%
                       Midterm (1):                   30%
                       Final Phase of Project:        30%

       Lateness Penalty:    For late homework, 10% off each weekday, and no deduction
                            on weekends or holidays.

       Plagiarism Penalty:  You will get 0 if copying each other is found, using other's
                                        assignment.
       Exams:            All the exams (midterm, final) must be taken on time, except
                         some unusual cases such as unexpected accident or sickness 
                         with proper proof.

       September 02:      Last day to add courses, to change between audit and letter grading.
       September 19:      Last day to change between credit/non-credit and letter grading.
       September 19:      Last day to withdraw from classes without a 'W' being recorded;
                          withdrawals from classes after this date and continuing through
                          the next four-week period will be permitted only for serious and
                          compelling reasons and require written approval by the Dean or
                          Department Chair.
       November 4:        Last day to withdrraw from classes for a serious and complelling
                          reason.
       November 28        SOCI Week
       Notice: 
               (1)  Send your questions and non-programming assignments (such as CMPS 3420 and
                    CMPS 4900A, 4900B report) hwang@csub.edu.
               (2)  Send your programming assignments in zip file as attachment to
                    hwang@cs.csubak.edu with your name, class#, and assignment #
                    as attachment comment. Sending email to incorrect account will result a
                    delay of reply or grading.
               (3) Visit http://www.cs.csubak.edu/~hwang/ for assignments, information and
                    grade-checking.