Application Development - The CIO's Guide to Oracle Products and Solutions - page 224

Name: Pothole

Aliases: None

Where used/How used: Pothole information is the main input

(Pothole Submission) and output (Fixed
Pothole Data) of the whole system (see
level 0 of the ERD).

Content Description:
Pothole ID = Ten digit number
Address = Sixty Characters
City = Thirty Characters
State = Two Characters
Zip = Nine Characters
Location = Ten Characters
District = One digit number
Repair Priority = Two digit number
Repair Crew ID = Two digit number
Repair Time = Hours or Days
Status = Five Characters
Material Cost = Dollar amount
Total Cost = Dollar amount
Description = Two Hundred and Fifty Characters
Supplementary Description:
Location possible values: “curb,” “middle,” “left side,” “right side”
District possible values: North = 1, South = 2, East = 3, West = 4
Repair Priority possible values = 1 to 10
Status possible values: “Open” or “Closed”

FIGURE 7.6
Data dictionary.

Process specification: : The PSPEC describes the what, when, where, and
how of the program in technical terms. It describes just how the
process works and serves to connect the DFD to the data diction-
ary. It uses pseudocode (sometimes called structured English or
program definition language [PDL]) to explain the requirements for
programming the process to the programmer. The following is an
example:

Process #1

Name Logon

Number: 1

Name: Logon

Description: Registered test takers will logon to their
account with their username and password through this