Syllabus for CMPS 3420, Database Systems Dr. Huaqing Wang, Fall Semester 2018 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. PostGres: online materials 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 Extended E-R model) Chapter 10 (UML) Chapter 1, 2 (Introduction to databases system) Chapter 3, 6 (Logical Database Design & Query Database :Relational model,its query languages - 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. Postgres : Interactive SQL, Embedded SQL, Postgres PL/SQL, and Stored Procedures and triggers (Reference to chapters 3 and 4) 2. Graphic User Interface, JDBC, Java (students will learn Java, C# and/or HTML related technology and coding lanuages themselves before and during class. Time & Classroom: 1:00 -- 2:15pm M.W ( Sci. III 311) 1:00 -- 3:30pm Thus. ( Sci: III 311) Office Hour: 11:00 -- 1:00pm Mon. & Wed. 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% Attendance: 2 points off your final grades (100 points) for each missing lecture/lab. 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 05: Last day to add courses, to change between audit and letter grading. September 24: Last day to change between credit/non-credit and letter grading. September 25: 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 9: Last day to withdrraw from classes for a serious and complelling reason. November 26: SOCI Week Notice: (1) Send your questions and assignments/Projects (such as CMPS 3420 and CMPS 4900A, 4900B report) hwang@csub.edu. Put the following infor in your email SUBJECT: team#, name(s), assignment #, and zip-file-name (2) Visit http://www.cs.csub.edu/~hwang/ for assignments, information and grade-checking.