CIS 4301 - Revision history

Jka: /* Applications */

2007-12-17T18:05:37Z

Applications

Jka: /* Project */

2007-12-17T17:59:35Z

Project

Jka: /* Systems */

2007-10-23T16:25:46Z

Systems

Jka: /* Handouts / Slides */

2007-10-23T16:23:59Z

Handouts / Slides

Jka: /* Case Sensitivity */

2007-10-03T18:29:05Z

Case Sensitivity

Jka: /* Oracle 10g Express */

2007-10-03T15:34:10Z

Oracle 10g Express

Jka at 14:08, 3 October 2007

2007-10-03T14:08:54Z

Jka at 14:08, 3 October 2007

2007-10-03T14:08:36Z

Jka at 14:07, 3 October 2007

2007-10-03T14:07:33Z

Jka: /* Textbook */

2007-10-03T13:31:00Z

Textbook

@@ Line 28: / Line 28: @@
 * [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]
 ===Other Items===

@@ Line 34: / Line 34: @@
 ==Project==
 * [http://www.inthewings.net/class/cis4301/project.pdf Project Description]
 ==Homework==
 # [http://www.inthewings.net/class/cis4301/hw1.pdf Homework 1]

@@ Line 24: / Line 24: @@
 * [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/Ch7-InternetApp.pdf Chapter 7: Internet Applications]
+* [http://www.inthewings.net/class/cis4301/Ch18_Recovery-95.pdf Recovery]
 ===Other Items===

@@ Line 12: / Line 12: @@
 ==Handouts / Slides==
 ===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===
-* [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/Ch7-InternetApp.pdf Chapter 7: Internet Applications]
 ===Other Items===
 * [http://www.inthewings.net/class/cis4301/ER-exercise.pdf ER Modeling Exercise]
 ==Project==
 * [http://www.inthewings.net/class/cis4301/project.pdf Project Description]

@@ Line 7: / Line 7: @@
 ====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.
 ==Handouts / Slides==

@@ Line 5: / Line 5: @@
 ===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.
 ==Handouts / Slides==
 ===Foundations===

@@ Line 1: / Line 1: @@
-{|align=left
+{|align=right
    |__TOC__
    |}

← Older revision		Revision as of 14:08, 3 October 2007
Line 1:		Line 1:
		+	{\|align=left
		+	\|__TOC__
		+	\|}
	==Discussion==		==Discussion==
	===Oracle 10g Express===		===Oracle 10g Express===

← Older revision		Revision as of 14:07, 3 October 2007
Line 1:		Line 1:
		+	==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.
	==Handouts / Slides==		==Handouts / Slides==
	===Foundations===		===Foundations===

@@ Line 19: / Line 19: @@
 # Solve problem 5.4 from the text. Due on 10/04 in class
 ==Textbook==
-# Database Management Systems, Third Edition
+ Database Management Systems, Third Edition
   Raghu Ramakrishnan, Johannes Gehrke
   ISBN: 0-07-246563-8
   Publisher: McGraw-Hill Higher Education
   Pub. Date: 2003