DEPARTMENT OF TECHNOLOGY
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 |
|..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|
All work must be compiled and executed on the university HP3000 computer system.
NO REQUIRED TEXT
HP3000 IMAGE Reference Manual and HP3000 QUERY Reference Manual
Three hours upon successful completion of course.
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.
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.
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 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:
- Time Log
- Application Development Request
- Software Change Request
- Operating (User) Instructions
- Oral Report
- Time Management and planning tools
- Business Letters
|2 Regular Exams (100 pts)||200|
|1 Final Exam||100|
|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