Difference between revisions of "CIS 4301"

From In The Wings
Jump to navigation Jump to search
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
{|align=right
 +
  |__TOC__
 +
  |}
 +
==Discussion==
 +
===Oracle 10g Express===
 +
Installing this software is not all that hard in linux or Windows, as they both have packages that simply install without too much trouble. One place that I am now finding trouble is with the interface to the linux installation from a linux machine, as there appears to be some sort of java interface that is not quite working right in firefox or mozilla, at least when it comes to editing script inputs.
 +
====Case Sensitivity====
 +
By default, when creating new tables, the names of the tables in the GUI are set to automatically default to all upper-case. There is a check box to turn on case-sensitivity, but by default it appears that this box is not checked.
 +
====Tutorial====
 +
* Found a bug in the tutorial for the query builder and how to sort a query. When you are using query builder and want to sort a query, you need to let the query builder know that you want to sort by a certain field, and in which order those fields should be sorted as you can sort by more than one field. The tutorial does not mention this, and in fact shows the broken output.
 +
 
==Handouts / Slides==
 
==Handouts / Slides==
 
===Foundations===
 
===Foundations===
−
* [http://www.inthewings.net/class/cis4301/Ch1_Intro.pdf Chapter 1: Introduction]
+
* [http://www.inthewings.net/class/cis4301/Ch1_Intro.pdf Introduction]
−
* [http://www.inthewings.net/class/cis4301/Ch2_ER.pdf Chapter 2: ER Model and Conceptual Design]
+
* [http://www.inthewings.net/class/cis4301/Ch2_ER.pdf ER Model and Conceptual Design]
−
* [http://www.inthewings.net/class/cis4301/Ch3_Rel_Model.pdf Chapter 3: The Relational Model and SQL DDL]
+
* [http://www.inthewings.net/class/cis4301/Ch3_Rel_Model.pdf The Relational Model and SQL DDL]
−
* [http://www.inthewings.net/class/cis4301/Ch4_Algebra.pdf Chapter 4: Relational Algebra] and [http://www.inthewings.net/class/cis4301/Ch4_Domain_Calculus.pdf Relational Calculus]
+
* [http://www.inthewings.net/class/cis4301/Ch4_Algebra.pdf Relational Algebra] and [http://www.inthewings.net/class/cis4301/Ch4_Domain_Calculus.pdf Relational Calculus]
−
* [http://www.inthewings.net/class/cis4301/Ch5_SQL.pdf Chapter 5: SQL]
+
* [http://www.inthewings.net/class/cis4301/Ch5_SQL.pdf SQL]
 
===Applications===
 
===Applications===
−
* [http://www.inthewings.net/class/cis4301/Ch6_DBApp.pdf Chapter 6: Database Applications]
+
* [http://www.inthewings.net/class/cis4301/Ch6_DBApp.pdf Database Applications]
 
* [http://www.inthewings.net/class/cis4301/PL-SQL1.ppt PL/SQL]
 
* [http://www.inthewings.net/class/cis4301/PL-SQL1.ppt PL/SQL]
−
* [http://www.inthewings.net/class/cis4301/Ch7-InternetApp.pdf Chapter 7: Internet Applications]
+
* [http://www.inthewings.net/class/cis4301/Ch7-InternetApp.pdf Internet Applications]
 +
===Systems===
 +
* [http://www.inthewings.net/class/cis4301/Ch16_Overview_Xacts.pdf Overview of Transaction Management]
 +
* [http://www.inthewings.net/class/cis4301/Ch17_CC-95.pdf Concurrency Control]
 +
* [http://www.inthewings.net/class/cis4301/Ch18_Recovery-95.pdf Recovery]
 +
===Applications===
 +
* [http://www.inthewings.net/class/cis4301/Ch19_FDs-95.pdf Schema Refinement, Functional Dependencies, Normalization]
 +
* [http://www.inthewings.net/class/cis4301/Ch21_Security-95.pdf Security and Authorization]
 +
* [http://www.inthewings.net/class/cis4301/Ch26-DataMining-95.pdf Data Mining]
 +
* [http://www.inthewings.net/class/cis4301/Ch27d_xml-95.pdf Semistructured Data and XML]
 +
* [http://www.inthewings.net/class/cis4301/Ch27e_xquery-95.pdf X-Query]
 +
 
 
===Other Items===
 
===Other Items===
 
* [http://www.inthewings.net/class/cis4301/ER-exercise.pdf ER Modeling Exercise]
 
* [http://www.inthewings.net/class/cis4301/ER-exercise.pdf ER Modeling Exercise]
 +
 
==Project==
 
==Project==
 
* [http://www.inthewings.net/class/cis4301/project.pdf Project Description]
 
* [http://www.inthewings.net/class/cis4301/project.pdf Project Description]
 +
* [http://www.inthewings.net/class/cis4301/project.tar.gz Finalized Project] - This was the final project that was turned in. It received full credit for the course.
 +
 
==Homework==
 
==Homework==
 
# [http://www.inthewings.net/class/cis4301/hw1.pdf Homework 1]
 
# [http://www.inthewings.net/class/cis4301/hw1.pdf Homework 1]

Latest revision as of 13:05, 17 December 2007

Discussion

Oracle 10g Express

Installing this software is not all that hard in linux or Windows, as they both have packages that simply install without too much trouble. One place that I am now finding trouble is with the interface to the linux installation from a linux machine, as there appears to be some sort of java interface that is not quite working right in firefox or mozilla, at least when it comes to editing script inputs.

Case Sensitivity

By default, when creating new tables, the names of the tables in the GUI are set to automatically default to all upper-case. There is a check box to turn on case-sensitivity, but by default it appears that this box is not checked.

Tutorial

  • Found a bug in the tutorial for the query builder and how to sort a query. When you are using query builder and want to sort a query, you need to let the query builder know that you want to sort by a certain field, and in which order those fields should be sorted as you can sort by more than one field. The tutorial does not mention this, and in fact shows the broken output.

Handouts / Slides

Foundations

Applications

Systems

Applications

Other Items

Project

Homework

  1. Homework 1
  2. Homework 2
  3. Solve problem 5.4 from the text. Due on 10/04 in class

Textbook

Database Management Systems, Third Edition
Raghu Ramakrishnan, Johannes Gehrke
ISBN: 0-07-246563-8
Publisher: McGraw-Hill Higher Education
Pub. Date: 2003
Retrieved from "https://wiki.inthewings.net/index.php?title=CIS_4301&oldid=2311"