CS361 EF1
Data Management with SQL

Syllabus

Homework

• Due 2/8/00: Zoo information retrieval
• Due 2/15/00: Creating a Database
• Sample Start File
• Due 2/22/00: Queries for the Book Database
• Sample Date Formats
• Due 2/29/00: Reports for the Book Database
• Due 3/7/00: Access as a Front End Tool
• Due 3/9/00: Extra Credit Queries

Answers to Homework

• Zoo information retrieval
• Book Queries information retrieval

Power Point Presentations

• 2/1/00: Introduction to databases
• 2/8/00: SQL Modes and Table Creation

Oracle Help

Sample Report
Sample Date Formats

Report commands
PL/SQL Commands