Tentative Schedule -- Spring 2011
From Courses
Contents |
[edit] News
March 3rd, 2011: First programming assignment is available and due on March 17th, 2011. See Programming Assignment 1 for details.
April 19th, 2011: Second programming assignment is available and due on May 2nd, 2011. See Programming Assignment 2 for details.
[edit] Week 1
[edit] Tu Jan 11 Course overview (First day of classes!)
- What are databases about?
Read textbook: Chapter 1
[edit] Th Jan 13 The Entity Relationship Model
Read textbook: Chapter 4 (4.1,4.2,4.3,4.4)
[edit] Week 2
[edit] Tu Jan 18 Relational Model of Data
Read textbook: Chapter 2
[edit] Th Jan 20 Relational Algebra
Read textbook: 2.4, 5.1
[edit] Week 3
[edit] Tu Jan 25 Introduction to SQL
Read textbook: 5.1, 6.1--6..3
[edit] Th Jan 27 Advanced Relational Algebra and SQL
Read textbook: 5.2, 6.4, 6.5
[edit] Week 4
[edit] Tu Feb 1
- Class canceled
[edit] Th Feb 3 Relational Algebra and SQL: Practice Exercise
[edit] Week 5
[edit] Tu Feb 8 SQL: Practice Exercise (continuation); Updates and Views
Read textbook: Chapter 6.5 (Database Modifications), 8.1, 8.2, 8.5, 8.6
[edit] Th Feb 11 SQL in a Server Environment: Embedded SQL and JDBC
Read textbook: Chapter 9.1-9.4, 9.6
[edit] Week 6
[edit] Tu Feb 15 Constraints, Triggers and Security
Read textbook: Chapter 7 and 10.1
[edit] Tu Feb 17
Continuation from last last.
[edit] Week 7
[edit] Tu Feb 22 Constraints, Triggers and Security
[edit] Th Feb 24 SQL Indexes and Transactions
Read textbook: Chapter 8.3, 8.4 (Indexes), 6.6 (Transactions)
[edit] Week 8
[edit] Tu Mar 1 Exam review
[edit] Tu Mar 3 Functional Dependencies, Decomposition and Normal Forms
Read textbook: 3.1--3.3
[edit] Week 9
[edit] Tu Mar 8 Functional Dependencies, Decomposition and Normal Forms
Read textbook: 3.4--3.7
[edit] Th Mar 10 Functional Dependencies, Decomposition and Normal Forms: Practice Exercises
[edit] Week 10
[edit] Tu Mar 15 Midterm I
[edit] Th Mar 17 The Semi-Structured Data Model and XML
Read textbook: Chapter 11
[edit] Week 11 -- Spring Break
[edit] Week 12
[edit] Tu Mar 29 Elementary Plotting Techniques
Notes: PlottingNotes.pdf
Slides: Plotting1.pdf and Plotting2.pdf
Topics: Simple Plotting Methods: Dot Plots, Connected Symbol Plots, Scatter Plots, Histograms, Others. Advanced Plotting Methods: Multimodal, Higher Dimensional, Correlation, Uncertainty and Variation.
Vistrails: PlottingVistrails.zip - Unzip this file in the examples directory of your VisTrails installation and it will add the vistrails along with their data sets (in the data directory). If you don't have permission to write to this directory (CADE users), then unzip the file where you want. Just be aware that in this case the paths for the data files may not be correct for most vistrails and will need to be fixed before they will execute properly.
Further Reading:
[edit] Th Mar 31 Polaris/Tableau
http://www.tableausoftware.com/
http://graphics.stanford.edu/papers/polaris_extended/
[edit] Week 13
[edit] Tu Apr 5 DEFOG and return of Midterm I
http://www.sci.utah.edu/publications/SCITechReports/UUSCI-2011-003.pdf
[edit] Th Apr 7 InfoVIS
Slides: InfoVis.pdf
References:
Map of the Market: Tree Map of Stock Market
Interactive Tree of Life: Radial Phylogenetic Tree
Disk Inventory X: Tree Map Disk Utility for Mac
Sequoia View: Tree Map Disk Utility for Windows
World of Music: Music Clustering
Graphviz: Graph layout project
Read textbook: Chapter 4 (4.5, 4.6)
[edit] Week 14
[edit] Tu Apr 12 XML Query Languages: XPath and XQuery
Read textbook: Chapter 12
XML Parsing, XMLSchema, XPath, and XQuery
[edit] Th Apr 14 XML Query Languages: Practice Exercise
[edit] Week 15
[edit] Tu Apr 19 Exam Review
[edit] Th Apr 21 NO CLASS
The instructor will be available 1-5pm to discuss any matters related to the class, if you have the need to.
