Here's the complete set of submission files for the project:

---

1. Project Proposal Document

File name: College_Lost_and_Found_Proposal.docx

Contents:

College Lost and Found Database System

Submitted by:

• Manveer Singh (100447725)
• Mukul (100437886)

Institution: Kwantlen Polytechnic University

Introduction:

In colleges, students and faculty frequently misplace items such as phones, keys, ID cards, books, and other personal belongings. Finding the original owners of these lost items can be challenging. Therefore, we propose developing a Lost and Found Database System.

Objectives:

• Maintain accurate records of lost and found items.
• Assist students and staff in retrieving lost items efficiently.
• Reduce the stress and time involved in item recovery.

System Overview:

The system will track and manage information including:

• Item name
• Description (color, brand, unique identifiers)
• Date and location where the item was lost or found
• Contact information of involved individuals

User Types:

• Loser (students/staff): Reports lost items.
• Finder: Reports items found on campus.
• Administrator (office staff): Manages and oversees system operations.

System Features:

• Database storage of lost and found items
• Matching algorithm to connect found items with lost item reports
• User-friendly interface for quick reporting and searching
• Secure and private storage of personal information
• Notifications and messaging for matched items

Conclusion:

The College Lost and Found Database System is practical and highly beneficial for college campuses, ensuring an organized, efficient method to manage lost and found belongings.

---

2. Database Schema Design

File name: LostFound_Database_Schema.pdf

Tables:

User

• user_id (PK)
• name
• email
• phone
• user_type (Student/Staff/Admin)

Items

• item_id (PK)
• item_name
• description
• date_lost_found
• location
• status (Lost/Found/Matched)
• reported_by (FK -> User.user_id)
• matched_with (FK -> Items.item_id)

---

3. System Wireframes/Mockups

File name: LostFound_UI_Mockup.pdf

• Homepage: Overview of lost/found items, login options.
• Report Page: Forms for reporting lost or found items.
• Search Page: Searchable list of items.
• Item Details Page: Detailed view of each reported item.
• Admin Dashboard: Administration tools for managing records.

---

4. Project Timeline and Task Allocation

File name: Project_Timeline_and_Task_Allocation.xlsx

Task	Assigned to	Start Date	End Date
Proposal Writing	Manveer & Mukul	July 1	July 4
Database Schema Design	Mukul	July 5	July 7
Wireframes & UI Design	Manveer	July 8	July 10
Front-end Development	Manveer	July 11	July 18
Database & Backend Development	Mukul	July 11	July 18
System Integration & Testing	Both	July 19	July 21
Final Documentation & Submission	Both	July 22	July 23

---

5. Final Project Report

File name: LostFound_Final_Report.docx

Contents:

• Executive summary
• Introduction and problem statement
• System architecture
• Technologies used
• Implementation details
• Challenges and solutions
• Testing methodologies and results
• Future enhancements
• Conclusion and reflections

---

6. Source Code

File name: LostFound_SourceCode.zip

Folder Structure:

text
LostFound_SourceCode/
│
├── Frontend/
│   ├── index.html
│   ├── styles.css
│   └── script.js
│
├── Backend/
│   ├── server.js (Node.js Express server example)
│   ├── database.sql (SQL database setup script)
│   └── config.env (Environment configurations)
│
└── README.md (Setup instructions)

---

7. Presentation Slides

File name: LostFound_Presentation.pptx

Slides:

1. Title Slide
2. Problem Overview
3. Project Objectives
4. System Design Overview
5. User Roles
6. Database Schema
7. Wireframes/UI Design
8. Technology Stack
9. Implementation and Challenges
10. Demo Screenshots
11. Future Enhancements
12. Conclusion & Q&A

---

8. README / Installation Guide

File name: README.md

Content Example:

markdown
# College Lost and Found Database System

## Overview
This project helps manage lost and found items on a college campus.

## Requirements
- Node.js
- MySQL or PostgreSQL

## Installation Steps
1. Clone the repository
2. Setup database using `database.sql`
3. Configure environment variables in `config.env`
4. Run `npm install` to install dependencies
5. Run `npm start` to launch the server

## Usage
Open the `index.html` file in a browser to interact with the application.

## Contributors
- Manveer Singh (100447725)
- Mukul (100437886)

---

9. Testing and Evaluation Documentation

File name: Testing_Documentation.docx

• List of test cases
• Bug tracking documentation
• User acceptance test results
• Screenshots of system functioning correctly

---

These are the files Manveer Singh (student ID: 100447725) would submit as part of the Lost and Found Database System project at Kwantlen Polytechnic University to achieve a 100% grade.