Title: Thesis Archiving Management System Database Design
Description:
The project entitled thesis archiving management system is a web based project design and developed using PHP, MySQL and Bootstrap.. This will serve as a repository and at the same time the students can access the records online. Searching of titles and uploading of documents such as pdf, word and powerpoint files are the main feature of the said project. Bootstrap is used to design the interface of the project, it simply means that the template is responsive and it can be also access through mobile devices such as smartphones and tablets.
Database Schema with description of table:
tblauthors (id, thesisid, fname, lname) – this table will store information on the different authors of the thesis or capstone project, it includes information such as firstname and lastname. The tblauthors table is connected to the tblproject which indicates the thesisid as the foreign key.
tblchart (id, year, qty) – chart table will store information as to the number of thesis or capstone project published every year.
tblcourse (id, name) – tblcourse is the table that will store information on the different courses, colleges and departments.
tblfile (id, project_id, path_1, path_2) – tblfile table is the table that will store the information on the uploaded files. For this project, the user can only upload the abstract, chapter 1 and chapter 2.
tblmembers (id, fname, lname, username, password, email, level, status, code) – the project is online, so therefore to monitor usage of the visitors and students as well, the tblmembers will store the information of the students and visitors who wants to access the list of thesis projects.
tblproject (id, title, description, category, course, year, datesubmitted, format, path) – tblproject is the table that will hold the information of the thesis and capstone projects, it includes the title, brief description, category, course and year.
tblview (id, project_id, user_id, date_view) – this table will hold the record on the date the project was viewed by the visitor and students.
ERD/Table Relationship:
System Flow:
Search Module – the search module will allow the visitors and students to search for the thesis title they want to view. This module will also allow the user to view and download the abstract and other documents of the thesis project.
Administrative Module – the admin module will allow the authorized users to access the different functions of the project such as encoding and uploading of thesis and capstone projects.
Feel free to post your comments, suggestions and recommendations or you can visit our facebook page for more information.
