CS-336: Principles of Information and Data Management
Prerequisites: Knowledge of first-order logics and data structures. Familiarity with Java and HTML.
Classes: TTh 6:00pm - 9:50pm, Hill-254, Busch Campus
Instructor:
Thang
Le
Email: thang@cs
Office hours: Tuesday 4pm - 5pm and by appointment, Hill-482
TA: Zhiyuan Zhang
Email: zzy@cs
Office hours: Thursday 5pm - 6pm and by appointment, Hill-488
Textbook: Ramakrishnan and Gehrke, Database Management Systems, 3rd edition (available in LSM reading room). Considerable additional material is covered during the course.
Exams: Midterm and (cumulative) final exams are closed-book and contain questions referring to any topics addressed in classes, assignments and project.
Individual Project: Design and develop a web-based application to help customers of a hotel/restaurant make reservations for dinners. By using JSP/Servlet, you will create frontend web-based interfaces connecting to a backend database. MySQL and Tomcat will be used as the database and web servers, respectively. In order to learn JSP/Servlet and develop web-based interfaces, you should be familiar with Java, HTML and JavaScript. For creating professional-looking web pages, you might need to additionally know CSS and JavaScript libraries such as Ext JS, jQuery, YUI, etc.
Assignments: Submit each
assignment in only ONE PDF file on Sakai: Do NOT submit multiple files or a
zip/doc/... file. Note that if you re-submit a file on Sakai, you have to remove
the previously submitted file, otherwise your submission contains multiple
files and we don't know which one is the latest.
Assignments can be submitted up to 2 days after the deadline: For each
hour late, 1% of the maximum point is deducted from the grade.
After a grade is released, there is a 10 day limit to bring grading
discrepancies to the attention of TA and/or instructor.
Grading Policy: Your final grade is based on the maximum of the followings:
· 30% final + 30% midterm + 30% project + 10% homework and quizzes
· 40% final + 20% midterm + 30% project + 10% homework and quizzes
Extra credit: Up to 3% for class and recitation participation.
Academic Integrity: All work must be done by your own. It's a violation of academic integrity to copy someone else's work or to let someone copy your work. See our academic integrity policy at http://academicintegrity.rutgers.edu/integrity.shtml.
Syllabus:
Introduction to DBMS
Relational Model: SQL DDL
Conceptual Design: Entity-relationship Model
Relational Model: Translating ER Diagram to DB Diagram
Relational Algebra and Calculus
SQL DML
Integrity Constraints, Views, Stored Functions and Procedures, Triggers
Web-based Database Application Development, JSP/Servlet
Schema Refinement, Functional Dependency, DB Normalization
Semi-structured Data: XML (DTD, XML Schema, XPath, XQuery)
Overview of Storage and Indexing
Overview of Transaction Management
Information Retrieval
Logon to Sakai for slides, project, homework, solutions, grades, etc.