ExamBase

Overview

University entrance exams management system simulation initially written in PL/SQL for Oracle Database course (Free university of Tbilisi) assignment. In this system students can choose which subjects to pass, faculties with priorities and exam centers.
Note that entrants are referred as students.

Usage

Prerequisites

Oracle Database 11g Express Edition 
PL/SQL developer

Run programm

After opening files from SOURCE_CODE folder in PL/SQL developer:

1. Execute/Compile MAIN_TABLES_1.sql
2. Execute/Compile VALIDATIONS_2.pck
3. Execute/Compile STUDENT_REGISTRATION_3.pck
4. Execute/Compile INITIAL_VALUES_4.sql
5. Execute/Compile SEQUENCES_VIEWS_5.sql
6. Execute/Compile GENERATE_SMTH_6.pck
7. Execute/Compile SIMULATION_PROCESS_7.sql

Instructions

• Student can make changes in personal information X¹ days before exams.
• Personal information before changes is available for viewing.
• Student can choose maximum Y² faculties.
• Registred students are automatically distributed in examination rooms.
• In each room maximum amount of students is Z³.
• In each room only one subject is being examined at a time.

<a maxDays ="f1">1</a>: by default X=10

<a maxFac ="f2">2</a>: by default Y=20

<a maxStud ="f3">3</a>: by default Z=30

License

MIT