Difference between revisions of "CIS 4301"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
===Oracle 10g Express=== | ===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. | 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. | ||
| + | |||
==Handouts / Slides== | ==Handouts / Slides== | ||
===Foundations=== | ===Foundations=== | ||
Revision as of 11:34, 3 October 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.
Handouts / Slides
Foundations
- Chapter 1: Introduction
- Chapter 2: ER Model and Conceptual Design
- Chapter 3: The Relational Model and SQL DDL
- Chapter 4: Relational Algebra and Relational Calculus
- Chapter 5: SQL
Applications
Other Items
Project
Homework
- Homework 1
- Homework 2
- 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
