General Course Materials
-
*** A Record of Paper Class Handouts *** (recall a few extra copies are placed in marked bins outside the Computer Science Department Student Services area
-
Coalition Membership - winter quarter - SUPERSEDED (pdf)
-
Coalition Membership - winter quarter - UPDATED after RIT withdrawal period ended (pdf)
-
Supplementary Information for Students - SUPERSEDED (pdf)
-
Supplementary Information for Students - revised 12/26/2011 - sections are highlighted (pdf)
-
Student Survey (pdf) - if you complete this outside of class, either print two-sided or staple the pages together before you turn it in
-
Coalition Background Items (pdf) - please review prior to class on Thursday, December 1, 2011
-
The Relational Model:Basic Concepts and Definitions (pdf)
-
A Brief Note on Qualified Names Using Relational Algebra (pdf)
-
Query By Example (QBE) Resources (pdf)
-
Silberschatz, Korth, and Sudarshan - University example - schema definitions (pdf)
-
Silberschatz, Korth, and Sudarshan - University example - data insert commands (pdf)
-
'Rules' for Mapping an E-R Model to a Relational Model (pdf)
-
First Example Mapping an E-R Model to a Relational Model (Grant) (pdf)
-
First Example Mapping an ER Model to a Relational Model Solution (Grant) (pdf)
-
Second Example Mapping an E-R Model to a Relational Model (Ricardo) (pdf)
-
Working Definitions for terms and normal forms (pdf)
-
Examples to accompany working definitions for terms and normal forms (pdf)
-
An example involving functional dependencies (pdf)
-
What Else Besides Normalization? (here you'll find algorithms 1 and 2) (pdf)
-
Examples that pertain to algorithms 1 and 2 (pdf)
-
An example in support of 'Algorithm 2' (pdf)
-
A Note on Multivalued Dependencies (pdf)
-
Partial Examples that illustrate Fifth Normal Form (5NF) (pdf)
-
Domain-Key Normal Form (DK/NF) (pdf)
-
Observations on Computer Storage, File Structures, Indexing and Hashing (pdf)
-
B-trees: Definition; Insertion; Deletion (pdf)
-
B-tree examples - insertions/deletions; B+-tree example - insertion (pdf)
-
Some Sample Learning Outcomes Associated with the Transactions Topic (pdf)
-
Some Sample Learning Outcomes Associated with the Data Analysis Topic (pdf)
Project
-
Basic Information on your CS Oracle account (REVISED - 12/21/2011) (pdf)
a>
-
SQL, Oracle, and Related Matters - Part 1 (pdf)
-
SQL, Oracle, and Related Matters - Part 2 (pdf)
-
Approaches to DBMS Programming - guest lecture fall, 2011 (pdf)
-
Sample Java program for database manipulation - guest lecture fall, 2011 (pdf)
-
SQL Developer screen - guest lecture fall, 2011 (pdf)
-
Database Project Description (FIRST POSTED 1/12/2012) (pdf)
-
Project Team Membership and Accounts (FIRST POSTED 1/12/2012; CORRECTED 2/1/2012) - SUPERSEDED (pdf)
-
Project Team Membership, Accounts, Data Domain Choices (FIRST POSTED 1/18/2012; CORRECTED 2/1/2012) - SUPERSEDED (pdf)
-
Project Team Membership, Accounts, Data Domain Choices, Work-in-Progress Presentation Schedule (FIRST POSTED 1/26/2012; CORRECTED 2/1/2012) (pdf)
|
|
Homework
| |