Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: P:\public\http\db\blue2.jpg

DATABASE MANAGEMENT SYSTEMS

 

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 hereand 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)

Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: P:\public\http\db\ProjRec.jpg