costco-capstone's Introduction

Xpanxion/Costco Apprenticeship Capstone Project

The Step IT Up program is a an approved Department of Labor Apprentice Program aimed at bring veterans, women and underserved population to the IT work force. For more details, click here.

For our training, we're focused on learning the technologies surrounding the IBM iSeries, also commonly known as A/S 400, alongside IBM's proprietary language called RPG, and its modern version RPGLE. Our ultimate goal is to showcase technical proficiency to become consultant software engineers for Costco Wholesale Corporation.

STUDENT INFORMATION SYSTEM

The Objective of this project is to create a student information system that will allow the users to create subjects, add courses and students, and view the students' marks(grades).

Technology Used

A/S 400 is not a commonly hosted environment. However, there's a free host called PUB400 that are available for educational purposes.

Server: PUB400
Environment: IBM i 7.4
Languages: RPGLE & SQLRPGLE
IDE: Rational Developer for IBM i
Emulator: IBM i Access - Client Solutions 5250 emulator

Getting Started

The entry point to the program is SIS_MAIN.RPGLE. All other RPGLE and SQLRPGLE files are supposed to be compiled as modules, and create service programs for each module.

The copybook for this program is called PROTOTYPE.RPGLE inside the source file QCOPYBOOK. It contains all sub procedure's prototypes, file imports, data structure for display file indicators, and a few subfile related variables

The display file is inside QDDSSRC, named SISDISPLAY.DSPF.

All data related physical files and logical files are the PF and LF in QDDSSRC

These include:

Users.PF - User credentials for logging in
StuMaster.PF - Student related information
StuDetails.PF - Student/subject/marks
SubMaster.PF - Subject related information
SemMaster.PF - Semester related information
CorMaster.PF - Course related information
SubCourse.PF - Details pertaining each course and what subjects it contains for a specific semester
ViewStudJF.LF - Logical file joining multiple PFs for the view student detail screen

Entity-Relationship Diagram for the Physical files

Screenshots

Login

Main Menu

Add Subject

Add Course

Add Student

View Students

Acknoledgements

This project was developed by Steven Wang and Max Ma in November & December 2021
Our instructor was Vicky Scrubar - LinkedIn
Our coach was Myra D. Ford - LinkedIn
Abundance of knowledge and tutorials from Yusuf4Code on YouTube
Veterans of the United States for their service

costco-capstone's People

Contributors

Stargazers

Watchers

Recommend Projects

shipitsteven / costco-capstone Goto Github PK