Changes between Version 2 and Version 3 of BuildInstructions
- Timestamp:
- 06/15/26 14:38:36 (38 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
BuildInstructions
v2 v3 4 4 5 5 - Programming Language: Java 17 6 7 6 - IDE: IntelliJ IDEA / Eclipse / VS Code (Java support) 8 9 7 - Database: PostgreSQL 15 (or compatible version) 10 11 8 - JDBC Driver: PostgreSQL JDBC Driver 42.6.0 (postgresql-42.6.0.jar) 12 13 9 - Download from: https://jdbc.postgresql.org/download.html 14 15 10 - Add to project classpath or IDE libraries 16 17 11 - Operating System: Windows / Linux / macOS 18 19 12 - Build Tool: None required (plain Java compilation via IDE or javac) 20 13 … … 22 15 23 16 - Java JDK 17 installed and configured (java -version to check). 24 25 17 - PostgreSQL installed and running. 26 27 18 - PostgreSQL JDBC driver included in the project classpath. 28 29 19 - IDE (IntelliJ/Eclipse/VS Code) or command line compiler to build Java project. 30 20 … … 43 33 44 34 5. Ensure database schema is created in PostgreSQL: 45 46 - Run create_tables.sql to generate all tables. 47 48 - Optionally, run insert_sample_data.sql for test data. 35 - Run create_tables.sql to generate all tables. 36 - Run data_load.sql for initial test data and constraints setup. 49 37 50 38 == Launch Instructions … … 53 41 54 42 2. Update JDBC connection settings in JDBC.getConnection() method with: 55 56 - Host 57 58 - Port 59 60 - Database name 61 62 - Username 63 64 - Password 43 - Host 44 - Port 45 - Database name 46 - Username 47 - Password 65 48 66 49 3. Run the main class: … … 68 51 java University 69 52 }}} 70 71 53 or via IDE Run Configuration. 72 54 73 55 4. The CLI menu will appear: 74 75 - Administrator: manage universities, add professors/students 76 77 - Professor: assign grades to students 78 79 - Student: enroll in subjects 56 - Administrator: manage universities, add professors/students, create subjects 57 - Professor: assign grades to students 58 - Student: enroll in subjects by choosing a professor instance 80 59 81 60 == Testing Instructions … … 83 62 === Administrator Use-case Test 84 63 85 1. Launch program, select Administrator (1). 86 64 1. Launch program, select Admin Menu (1). 87 65 2. Add a university. 88 89 66 3. Verify in the database that table University contains the new entry: 90 67 {{{ … … 94 71 === Professor Use-case Test 95 72 96 1. Launch program, select Professor (2). 97 98 2. Assign a grade to a student for a subject. 99 73 1. Launch program, select Professor Menu (2) → Assign Grade to Student. 74 2. Select a professor, a subject they instruct, an enrolled student, and assign a grade (6-10). 100 75 3. Verify that table Student_Subject has updated Final_Grade and Status = 'PASSED': 101 76 {{{ 102 SELECT * FROM Student_Subject WHERE Student_Id = <id> AND Subject_Id = <id> ;77 SELECT * FROM Student_Subject WHERE Student_Id = <id> AND Subject_Id = <id> AND Professor_Id = <id>; 103 78 }}} 104 79 105 80 === Student Use-case Test 106 81 107 1. Launch program, select Student (3). 108 109 2. Enroll in a subject. 110 111 3. Verify that table Student_Subject has a new row with Status = 'ENROLLED': 82 1. Launch program, select Student Menu (3) → Enroll in Subject. 83 2. Select a student, available subject, and a professor instance. 84 3. Verify that table Student_Subject has a new row successfully created with Status = 'PASSED': 112 85 {{{ 113 86 SELECT * FROM Student_Subject WHERE Student_Id = <id> AND Subject_Id = <id>; … … 117 90 118 91 - Database: Use your local PostgreSQL credentials. 119 120 - Application CLI: No usernames/passwords required for the prototype (IDs are selected from lists). 92 - Application CLI: No credentials required for the prototype (IDs are selected dynamically from terminal lists). 121 93 122 94 == Step-by-Step Mini Guide 123 95 124 96 1. Launch application. 125 126 2. Choose actor from main menu: Administrator / Professor / Student. 127 97 2. Choose actor from main menu: Admin Menu / Professor Menu / Student Menu. 128 98 3. Follow on-screen menus: 129 130 - Admin: Add University → Add Professor → Add Student 131 132 - Professor: Assign Grade → select professor → subject → student → grade 133 134 - Student: Enroll in Subject → select student → select subject 135 136 4. Verify actions in the database using SELECT queries. 99 - Admin: Add University → Add Professor → Add Student → Create Subject 100 - Professor: Assign Grade → select professor → select subject → select student → enter grade 101 - Student: Enroll in Subject → select student → select subject → select professor 102 4. Verify actions in the database using standard SELECT queries.
