Untitled Document
CMPE 226 Advanced Database Systems Fall 2003
Syllabus / Green Sheet
Important Due Dates
Submission Guidelines
Book Description
Login for Lecture Slides
User ID:
Password:
Practice Problems
Entity-Relationship Diagrams
Class Diagrams
Sample Projects
Individual Assignments
Assignment 1 - Due date: October 7, 2003
Assignment 2- Due date: October 21, 2003
Assignment 2 Sample: Smile Sad
Assignment 2 Sample: Face
Assignment 2 Sample: Face Circle
Assignment 2 Sample: Happy Face
Assignment 2 Sample: Sad Face
Assignment 3
Assignment 4
Related DB Links
Using Rose
UML Links
UML Notation Guide
Rational Rose 2000 Object Modeling
Microsoft Visio 2002 - UML Model Diagram
Diagramming Techniques
Diagramming Techniques
Database Terminology
Constraints
E-R Diagrams - Links to Samples
ERD Example 1
ERD Example 2
ERD Example 3
ERD Example 4
ERD Example 5
ERD Example 6
SQL Examples
Team Projects
Project 1
Sample Project file
Project 2
Sample Problem Statement: Andy
Sample Problem Statement: Gold Rush
Sample Problem Statement: Green Apple
Sample Problem Statement: Sunnyvale
Sample Db: Andy Elections
Sample Db: Andy State Elec Votes
Sample Db: State Turn-out
Sample Db: State Parties
Sample Db: Gold Rush
Sample Db: Green Apple
Sample Db:Sunnyvale
MLPQ-PReSTO 2.0
The MLPQ/GIS Constraint Database System user’s manual
The MLPQ/PReSTO executable file and sample databases
Translation program from ARC/GIS to MLPQ/PReSTO executable file
