Created a schema to visualize the attributes and relationships between different entities. Still not in its final stage as I will be editing it. @MaramRadhi if you could please add the tables you've created in order for me to double check if my schema has all the entities we need.

An in-text file that explains to the user how the application works, like how the buttons work, and what happens when the buttons are clicked.

Design relational database relations.
Determine relationships between attributes in each relation.

-add button
0button works
-no need

• coding when

Creating notifications to notify the user that the changes has been made

Uses react to save the content of the csv file into one array

Design landing page

After the first client meeting, Huda and Maram had finalize the general summary requirements of the system before sharing with the group.

1st User: Professors/Faculty they can only see the data of the students/course they are teaching.
1.1 Summary of each course
course name, course ID, average fail/pass rate, course outcomes
1.2 Summary of each student at each course
Student name, Student ID, grade in letter, grade (100%) and GPA. if they need detailed information there should be a “show details” section that breaks down the student’s grades (for example grade of each quiz, assignment, test, etc..) and then the overall weight for quizzes, assignments…

2nd User: Engineering Program Lead (must be able to access professors view 1.1 and 1.2)
2.1 Summary based on college of Engineering, and Summary based on (computer science, computer engineering….)
Average pass/fail rate, average GPA for each year batch (year one, year two..), any specific course that all students don’t do well in.
2.2 Summary of all engineering college students
Student name, Student ID, college, year started university, courses taken (course ID), and grade of each class, overall GPA, and GPA per semester.

We meet with Dr.Fatima to discuss about the general requirements of the grading system and the approach we would follow. The first option is that we create a system similar to Canvas that would allow professors to input students grades and the automatically calculate the total weight for assignment, tests and participation. We decided to create a system that would allow that users to import a file to the system and then the system will automatically read the file and create different tables in the database.

Bellow you can Find everything in detail:
First meeting with stakeholder (Dr. Fatima Akbar) on Monday 27/02/2023 at 12:30
Main Points Discussed:
First Approach
We create a database that teachers can input the grades (in percentage) and then the system can automatically calculate the grade depending on the weight of the assignment, final grade and GPA.
In this option we will have multiple tables including student information(first name, last name, date of birth, age, major) student courses(all the past and present coerces with overall GPA) current classes and their progress and teachers can also input the grades of students. But each stakeholder will have different level of authority/access.
Second Approach (Import excel sheet/ read file/ analyse data/ provide a summary)
Teachers will put all the grades/data on the excel sheet from canvas. They excel sheet will then be uploaded to the system and the system will read the document, analyse it and then generate a summary report.
The system will give different users different access to the generated report depending on their authority level. For example, the program lead can see the summary of all the students. Teachers can only see summary of student’s performance in their course(ID and grade or course/course outcome and pass/fail rate). In general, the summary should generate a summary of average GPA based on college (engineering and each engineering college), and batch year.

Discuss and create UI draft for user sign-in, viewing and submitting grades.
Discuss what the UI should look like and how the user will interact with the program.
Review with stakeholders:

• Professors: Dr. Fatima, Dr. Hasan
• Registrar

Using the minutes we made set up the three tables we need to save data in so that the back end has something to connect to

Create a figma design for all 4 of our web pages. Should be fully customized and detailed with a simple but consistent color scheme.

Implement the program into connect to the MySQL database server using NodeJS

A hyperlink that allows the user to click on that will lead to the AUBH main page.

Allow user to view data about students grades on users' home page.

https://youtu.be/5IanQIwhA4E

Maram and Huda had an interview with stakeholders (Dr. Fatima, Dr. Haitham), brainstormed ideas, discussed the requirements of the application and scheduled another meeting to finalize the requirements after presenting the options with the scrum masters.

-basic landing page
-nothing needed on it
-just loads up
-directory set up-
-uploaded on to github

Utilize Node.js to create and connect a database using MySQL.

• Install Node.JS and how to use it
• Study SQL and how to use it to query from database
• Study how to used NodeJS to connect the program to the SQL database

Interview Dr Fatima and Dr. Hasan about about Grade App requirements, UI, and features

Use axion to send the information you got back to the server in JSON format. Make sure it connected to the right http

Create server to store the MySQL database.

Allow program to access data from the database.
This data should be displayed in the student grades table from the user interface.

In the second meeting, we decided on the final table attributes and finalized the summary types and details.

The System will read the excel spread and automatically create tables. The row will increase as new sheets are uploaded.
1st table: Summary of the overall courses
Course name, average lab assignment. average knowledge checks. average tests, average participation, average final grade of all students

2nd table: update students grade table and add the course name with final grade
Student_ID, Course Name, final grade percentage, final grade alphabetical, final course, GPA. Notes

3rd table: Summary of the course detailed (copy of excel sheet)
Student_ID, Course name, average lab assignment. average knowledge checks. average tests, average participation, average final grade of all students .

NOTE: table 2 are connected.

Establish an SQL connection between the frontend and backend.

based on list of discussed features, we will create a design for what each page will look like

Create database tables using the database schema.