DEPARTMENT OF TECHNOLOGY

SYLLABUS
COMPUTER INFORMATION SYSTEMS 3083

CATALOG LISTING:  3083 Database, 3 hours credit
Emphasis on design and use of database systems and a comparison to sequential file structures. 
Lecture 3 hours.  Prerequisite CIS 2063.

EXPANDED COURSE DESCRIPTION:

Required course for data processing and CIS majors.

Upon completion of the course students should:PROGRAM
OBJECTIVE:
..be familiar with logical database concepts and basic data structures I3
...be able to design, create, and access database structures I3
...be able to access database structure through the COBOL language I1
..understand basic data structures to include flat files, linked lists, inverted lists, and trees  I3

LAB EQUIPMENT

All work must be compiled and executed on the university HP3000 computer system.

TEXT

NO REQUIRED TEXT

ADDITIONAL REFERENCES

HP3000 IMAGE Reference Manual and HP3000 QUERY Reference Manual

CREDIT

Three hours upon successful completion of course.

SOFTWARE

IMAGE, QUERY, EDITOR, COBOL 

DATABASE DESIGN PROJECT

Each student is required to design and implement a mainframe database structure.  The design must allow for multiple user access for updating data and requesting reports.  Special report requests must be written using Query software.
Three or four COBOL programs must be written to access the database.  One program will allow for additions, changes, and deletions throughout the database and other programs will prepare reports after selecting data from multiple data sets. 
The overall projects must be well documented and presented in a professional manner.

EXAMINATIONS

Two regular examinations and one final examination will be given.  The first exam will stress the logical concepts learned from the text material.  The second exam will stress the actual knowledge being learned from the physical design and implementation of a database.  The final exam will be comprehensive.

ATTENDANCE POLICY

All students are expected to attend class and to arrive on time.  Make-up for an exam to be missed must be approved before the scheduled time of the exam.  Make-up exams will be given at the convenience of the instructor and may be more difficult than the regular exam. All assignments are to be turned in at the BEGINNING OF THE CLASS period on the date due.  Late assignments are worth zero points
but must be turned in or an "F" will be given in the course.

WRITING ASSIGNMENTS:

Writing assignments for this class will not be explained as separate pieces as is done in other  CIS/DATAP courses.  All types of writing learned in other classes will be of value here. Examples of writing that may be used in this class include:

  •   Memorandum
  •   Time Log
  •   Application Development Request
  •   Software Change Request
  •   Operating (User) Instructions
  •   Oral Report
  •   Time Management and planning tools
  •   Business Letters
GRADE COMPOSITION:POINTS
   2 Regular Exams (100 pts) 200
  1 Final Exam 100
  System Notebook 50
  Projects  30
   Image Projects 130
   Quizzes 20
TOTAL 530

GRADE SCALE:

A: 477 - 530 (90%)
B: 424 - 476 (80%)
C: 371 - 423 (70%)
D: 318 - 370 (60%)
F:    0 - 317
I: Incomplete (Emergencies only)
W: Withdrawal--Note that the instructor does not have the authority to withdraw the student from the class.  this procedure must be initiated by the student.

STUDENT HONESTY AND INTEGRITY