Thesis Archiving Management System Database Design

Thesis Archiving Management System Admin Module

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. The purpose of this project is to compile the thesis/capstone project in an electronic manner according to course and year submitted. 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:

Thesis Archiving Management System Database Design

Thesis Archiving Management System Database Design

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.

Thesis Archiving Management System Search Module

Thesis Archiving Management System Search Module

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.

Thesis Archiving Management System Admin Module

Thesis Archiving Management System Admin Module

Feel free to post your comments, suggestions and recommendations or you can visit our facebook page for more information.

Comments

comments