Mini Project: Managing Student Absences 1. Problem presentation: In order to facilitate student absence management, you will write in Java an application allowing to: - List the users of the application. - Fill out attendance lists for each class at each course. - Consult recorded absences for a given class or student. - Cancel a recorded absence if justified by the student. - Send email alerts to truant students. - Generate graphs, statistics of the absenteeism rate by class, by field or by level of study. 2. Setting up the database: We suggest designing a database with seven tables: Student (student id, name, first_name, login, pwd, class_id\#) Teacher (teacher id, name, first_name, login, pwd) Manager (manager id, name, first_name, login, pwd) Class (class id, name, level, field) Absence (student id , teacher id\#, subject id\#, session number, id, date) Subject (subject id, title) Correspondence (teacher id\#, subject id\#, class id\#) Our program will interact with a database in which will be stored information such as - Users' identifiers Required work A report containing the description of your conceptual model, the completeness of your code and screenshots of the work must be returned.- - The different tables involved in the management of the application The main users of our application will be - Teachers - Administrative manager(s) - Students We have the following use cases and users: Note that the "Manage absences" user case overlaps the following user cases: - Consult absences - Cancel absences - Print lists of absences - Generate graphs - Send email alerts to students