Question: Student Database Management System The purpose is to design a database model to support the setup of an automated student record management system. This system


Student Database Management System The purpose is to design a database model to support the setup of an automated student record management system. This system enables the users of a university, like student and faculty, to access the important information through a user-friendly web application. In a university there are many departments that provide various records regarding students. Thus, a computerized student record management system will enable the university to better maintain and update records and also allow users to access and update their data at any time and any place. The system enables huge storage of data and easy retrieval. The system should keep track of students and faculty members records, such as personal information, grades, etc.. Students can check their transcript, look at course information, check their grades for every course and every semester. Faculty can be assigned to course, they can check student records and grades history. Please use at most 5 tables. You can make assumptions for the attributes and relationships between the tables but you need to clearly state them. - povic DFU TUI wildl exdll purpose) 2. DB Model: (30 points) a) To meet the above requirements, describe the tables needed with attributes. b) To meet the above requirements, describe the relationships between the tables. c) Populate the DB with a few examples in each table Student Database Management System The purpose is to design a database model to support the setup of an automated student record management system. This system enables the users of a university, like student and faculty, to access the important information through a user-friendly web application. In a university there are many departments that provide various records regarding students. Thus, a computerized student record management system will enable the university to better maintain and update records and also allow users to access and update their data at any time and any place. The system enables huge storage of data and easy retrieval. The system should keep track of students and faculty members records, such as personal information, grades, etc.. Students can check their transcript, look at course information, check their grades for every course and every semester. Faculty can be assigned to course, they can check student records and grades history. Please use at most 5 tables. You can make assumptions for the attributes and relationships between the tables but you need to clearly state them. - povic DFU TUI wildl exdll purpose) 2. DB Model: (30 points) a) To meet the above requirements, describe the tables needed with attributes. b) To meet the above requirements, describe the relationships between the tables. c) Populate the DB with a few examples in each table