nelson-escalona
commented
1 day ago Dummy data was succesfully uploaded to the database. This enables the College Planning team and all developers in the RegiUPR project to test features using real data from the database.
In the students table, a dummy user was inserted with the name of 'Juan del Pueblo', a dummy student number, birthdate, social security number and the RegiUPR gmail address. This was made so that the login team could test out their features.
In the _programfaculty table, all programs and faculties associated with the INSO curriculum were added, as shown bellow.
In the courses table, all courses associated with the INSO curriculum were added, as shown below.
In the sections table, dummy sections were created for all courses from the first, second, and third semesters, as shown below. This was done to simulate a second year student studying in the first semester of his second year since for the _student_courses_ table, the courses from these 3 semesters were added and a status was assigned, with courses from the first year set as "TAKEN" and the courses from the first semester of the second year set as "CURRENTLY TAKING".
In the curriculum table, a curriculum was created for the INSO program and the 'Ciencias en Computacion e Ingenieria' program was linked to it, as shown below.
In the _curriculum_courses_ table, we linked the courses to the INSO curriculum and a semester was added, referring to what semester is the course suggested to be taken, as shown below.
Finally, in the _student_curriculum_ table, the INSO curriculum was linked to the dummy student that was inserted, as shown below.
Objective: Add the INSO curriculum to the database so that the developers in the College Planning team can test while developing.
Description: This task involves adding all the data from the INSO curriculum and adding a dummy student linked to that curriculum so that the developers in the college planning team can test out the functionality of the feature while developing.
Requirements: Add INSO curriculum to database Add dummy student user and link the INSO curriculum to the student.
Time Constraints: Complete by Monday, October 14.
Completion Criteria: INSO curriculum is fully added to the database. Dummy student is added and linked to the database.
Difficulty: 3 The task involves manually adding all data in the INSO curriculum to the database. Its not a difficult task but it is a tedious one.
Priority: 4 This task is important so that developers can test out the functionality but its not that urgent since the developers have not started doing the task.
Assignees: @nelson-escalona