|
Course Description:
CS 470(G) -- Database Management Systems
This course focuses on Relational Database Management System Design. Students
learn the standard DBMS architecture, how to design a database, and how to
query it. Currently, the theoretical foundation of the course is reinforced
through examples in ORACLE.
General
Class Information:
- View
the Review PowerPoint Slides.
- View the PuTTy
login screen shot
- View the SQL Coding Style Guidelines
Document
- View the Relational Query Document
installation instructions for Word 2003.
- Download the Relational Query Font file.
- Download the Relational Query Document
Template.
- For Word 2007 and
later users:
- Download the
Template File above.
- Download the starter
file here and follow the directions therein.
- Click here to go to
the Instant SQL Formatter.
Homework Assignments
and Solutions:
Class Examples:
·
Click here for
the Primary and Secondary B-Tree illustration example.
·
Click here for the Relational Algebra/Calculus
Visual Example
Project Documents
· NOTE: The project is due on the last day of class
(see your syllabus for the exact date).
The written part must be turned in at the beginning of class and the
implementation files must be submitted by 11:59PM on that date.
·
Click
here for the official assignment, grading specification and some general do’s and don’ts.
·
Requirements (click on the Word Art below)
|
