BCIS 4620
Database Processing
Assignment 1: NetExpress (NX) SQL Programs
(10 points); DUE: Feb 5
A.
SQL
Tutorials
Read the following chapters on the NX 5.0 UE HELP Menu: Start Here/Getting Started:
a. Welcome to Net Express (Chapters 1 Welcome; Licensing; 2 Intro to NX; 3 Using NX IDE; and 4 Maintaining and Creating Data Files) NOTE: DO NOT Set up Access to Mainframe Through XDB Link in Ch. 1; DB2 Apps (SQL Opt)
b. Start Here/Programming/Database Access: Part 1. SQL Option Tutorials (
B.
Turn the
following printouts in for grading:
|
Tab |
Query No/Table |
Description |
Result Table/Form |
Portrait/ Landscape |
Page |
Complete |
|
1 |
Pensioner Table |
b. (above) SQL Tutorial; Ch 3 |
Table |
Landscape |
1 |
1. |
|
|
Penslist Query (note: Name shortened from Pensionlist) |
b. (above) SQL Tutorial; Ch 3 Maintaing
a DB2 database |
a. SQL Query view and b. Table view |
Portrait Portrait |
1 1 |
2. |
|
2 |
Query 14 Customer |
SQL Wizard Stored Queries (& all below) |
a. SQL Query view and b. Table view |
Portrait Landscape |
1 1 |
3. |
|
|
Query 15: CA |
|
a. SQL Query view and b. Form view |
Portrait Landscape |
1 3 only |
4. |
|
|
Query 17: Between |
Hint: Remove $, save, run |
a. SQL Query view and b. Table view |
Portrait Portrait |
1 1 |
5. |
|
|
Query 19: Order by |
|
a. SQL Query view and b. Table view |
Portrait Portrait |
1 1 |
6. |
|
|
Query 22: Like |
Change Pop% to P% |
a. SQL Query view and b. Table view |
Portrait Portrait |
1 1 |
7. |
|
|
Query 25: Exists |
|
a. SQL Query view and b. Table view |
Portrait Portrait |
1 1 |
8. |
|
3 |
Query 27/26/27: Update table |
Before (Q27); Update (Q26); After (Q27) |
a. Form View b. SQL Update view; c. Form view |
Portrait Portrait Portrait |
1 1 1 |
9. |
|
|
Query 56: SQL Create View Query 57: Select |
|
a. SQL Query view and b. Table view |
Portrait Portrait |
1 1 |
10. |