Capital Sprint Report PDF
Capital Sprint Report PDF
Capital Sprint Report PDF
Project Report on
Karankumar Tamgale
2023-2024
Date: / / Seat No
CERTIFICATE
This is to certify that Roll No.
from has satisfactory completed the project on” “
During the year 2023 -2024 as per the requirements of the Savitribai Phule Pune
University.
I would like to acknowledge the Audyogik Tantra Shikshan Sanstha ATSS College of Business
Studies and Computer Application college for providing us with the necessary resources and
facilities to carry out this project.
I would like to express my profound gratitude to our Principal Dr. Vishwas Swami Sir for
granting me this wonderful opportunity to be part of this project and to our HOD Mrs. Vinaya
Keskar Ma’am for their unwavering support and guidance throughout the duration of this
project.
I would like to express my special thanks to our mentor Mrs. Shubhangi Patil Ma’am for her
time and efforts she provided throughout the year. Your useful advice and suggestions were
really helpful to me during the project’s completion. In this aspect, I am eternally grateful to
you.
Thank you,
Karankumar Tamgale.
4
Table Of Content
5
7.1 Test Plan, Black Box Testing or Data Validation Test
Cases, White Box
7.2 Testing or Functional Validation Test cases and results
8 Conclusion 55-56
9 Future Scope 57-58
10 Bibliography 59-60
6
LIST OF FIGURES
LIST OF TABLES
2. Employee 32
3. Enquiry 33
4. Setting 33
5. Orders 34-35
1
CHAPTER 1
INTODUCTION
1
CHAPTER 1 INTRODUCTION
Capital Sprint ERP is a web-based system which is used for Property Valuation purpose to
manage the customer details and properties details. This software is specially developed for
real-estate company those who are in property valuation business. The software consists of a
website. The website provides functionality to manage the coordinator and employees those
who are working for this company and main functionality of this application is to create
automatic documentation of property and send it to coordinator. This website helps to
manage lots of data and has functionality to take backup into excel files.
Admin is able to modify property details added by employee. This System has
multiple users with special access. Admin has same functionality which is available in
website, admin can create various users and limit their access.
This Website has functionality to upload image in various different size and website will
convert images into specific size for presentation. This application can access location of the
device while adding property so admin can get exact location of the property.
• This Application has limitation for employee. They cannot modify property
once added.
• Admin can manage all back-up of data in system. System has functionality to
export data in various formation like csv, excel, etc.
2
1.1 Motivation
The motivation behind developing Capital Sprint ERP is to streamline property
valuation processes by automating tasks related to managing customer details, property
information, and valuation data. By providing a centralized platform for these operations, the
software reduces manual efforts and improves overall efficiency.Manual record-keeping and
data management in property valuation businesses can lead to errors and inconsistencies.
Capital Sprint ERP aims to minimize such inaccuracies by maintaining a digital repository of
customer and property details, ensuring data integrity and accuracy. In today's competitive
real estate market, efficiency and accuracy are crucial for staying ahead of the competition.
Overall, the motivation behind Capital Sprint ERP is to empower real estate companies with
a comprehensive and efficient solution for managing customer details, property information,
and valuation processes. By addressing the challenges faced by the industry and leveraging
the benefits of technology, Capital Sprint ERP aims to drive growth, improve efficiency, and
enhance the overall competitiveness of real estate businesses.
3
1.3 Objective
• To streamline the process of property valuation by providing a centralized system
for managing customer details, property information, and documentation.
• To facilitate effective coordination among employees and coordinators involved
in property valuation tasks, ensuring smooth workflow and communication.
• To enabling the automatic generation of documentation for properties, reducing
manual effort and potential errors while ensuring consistency and accuracy.
• To provide tools and functionality to manage large volumes of data associated
with property valuation, ensuring data integrity, security, and accessibility.
• To Offer features for data backup into Excel files, ensuring data preservation and
facilitating recovery in case of unforeseen events or system failures.
• To improve customer service by ensuring timely and accurate property valuation
services through efficient management of data and tasks.
This System is developed for the real-estate company those who are in property valuation
business. Where employee can visit at property location and take all property details like
location, dimension, rental details, owner details and image of the property from various
directions and submit their details with property location. So, coordinator can filter property
and do further process with them. Coordinator and admin can use web admin panel to access
4
property data. System has ability to create power point presentation automatically. Ppt has
property details submitted and images with their name and at last page contains location
details of the property.
By this system admin can generate reports of their employee performance. Each property is
assigned to employee and coordinator both are responsible for the property details and status
of the property. This all data will be managed by admin on system for long period. In case of
huge dataset application speed will remain constant. No need to delete previous records. All
the reports can be exported in various format like Excel, pdf, whatever is suitable. It has
power full encryption functionality which provides the security to application
Limitations
Power Point Presentation has standard Format. Admin cannot change format. Employee can
upload only 13 images at time. System Has Limited Time Period Of Inactive login system.
This software is only compatible with windows and operating system. Reports Has some
limited functions free of cost. Search option is limited functions provided by this system.
Admin can send limited group of emails
5
CHAPTER 2
SYSTEM ANALYSIS
6
CHAPTER 2 SYSTEM ANALYSIS
2.1 Comparative study of Existing systems
The existing manual system used by property valuation companies involves a
combination of paper-based processes, spreadsheets, and standalone software solutions to
manage customer details, property information, and valuation reports. Typically, valuation
agents manually collect and record customer data, property details, and relevant documents
such as floor plans, photographs, and legal documents. These details are often stored in
physical files or digital spreadsheets.
Once the necessary information is collected, valuation agents manually input data into
valuation reports, calculating property values based on established methodologies and market
trends. The entire process, from data collection to report generation, relies heavily on manual
effort and is prone to errors, inconsistencies, and delays.
Recording customer information including name, contact details, and preferences. Tracking
communication history and interactions with customers. Managing customer appointments,
inquiries, and feedback manually.Collecting and storing property details such as location,
size, amenities, and features. Maintaining records of property ownership, deeds, and legal
documents. Managing property-related documents and files manually.Conducting property
inspections and assessments manually. Inputting data collected during inspections into
spreadsheets or paper forms. Performing calculations for property valuation using manual
methods or predefined formulas. Generating valuation reports manually based on calculated
property values and market analysis.
1. Human Error: Manual data entry and calculations increase the risk of errors in
property valuation reports, leading to inaccuracies and potential discrepancies.
7
3. Lack of Centralized Data Management: With data scattered across various documents
and spreadsheets, there is a lack of centralized data management, making it
challenging to access and update information quickly and effectively.
4. Limited Scalability: The manual system lacks scalability to handle increasing volumes
of customer data and property information as the business grows. This can lead to
bottlenecks and inefficiencies in managing large portfolios and client bases.
5. Reduced Visibility and Reporting: Manual systems offer limited visibility into key
performance metrics and trends, making it difficult for management to track and
analyze business performance. Reporting capabilities are often rudimentary, hindering
strategic decision-making.
• User roles and permissions to control access and functionality within the system.
Property Submission:
• Notification system to inform coordinators and employees about updates and actions
related to property valuations.
Property Management:
8
• Ability for coordinators and administrators to view, modify, and update property
details as needed.
Integration:
• Integration with external data sources, such as property databases, market data
providers, or GIS platforms, to access relevant property information.
2.4 Stakeholders
Admin –
Admin can access this system from web application. This complete System is
designed for admin. He/She can manage all details of the system. Admin can create multiple
users with limited access functionality. Admin has same functionality like users. Admin has
rights to change website contact email and address details and policy of company. Admin can
export all data from system into various formats. He can access reports of each employee and
able to change employee password.
Coordinator –
9
Employee –
This user can access system by android application. Admin will create user ID and
password for employee. Employee cannot register themself. Employee can add n number of
property in application. For each property automatic presentation will create and that will
mail to coordinator of the employee. Employee can check the status of property submitted.
Application has 4 different status i.e. Pending, Submitted, Rejected and Approved.
10
CHAPTER 3
REQUIREMENT ANALYSIS
11
CHAPTER 3 REQUIREMENT ANALYSIS
1. Functional Requirements:
Capture details such as customer contact information, property preferences, and valuation
history. Define functionalities to store property details, including location, size, features, and
valuation data. Specify requirements for automatically generating property valuation reports,
including formats, templates, and customization options. Determine features needed to assign
tasks, track progress, and communicate among employees and coordinators. Define
requirements for scheduling and executing backups, selecting backup locations, and ensuring
data integrity.
2. Non-Functional Requirements:
Define response time expectations for accessing and updating data, especially during peak
usage periods. Specify authentication mechanisms, data encryption standards, and access
control measures to ensure data confidentiality and integrity. Define uptime requirements and
mechanisms for system monitoring, fault detection, and recovery. Specify user interface
design principles, accessibility features, and training requirements to ensure user acceptance
and productivity. Define requirements for accommodating growth in data volume, user base,
and system complexity over time. Specify compatibility requirements with web browsers,
operating systems, and devices for both the web application.
12
CHAPTER 4
SYSTEM DESIGN
13
CHAPTER 4 SYSTEM DESIGN
4.1 Design constraints
The ERP system must comply with industry regulations and standards related to property
valuation, data privacy, and financial reporting. The system should be designed to handle
increasing volumes of customer data, property information, and valuation reports as the
business grows. Capital Sprint ERP must integrate seamlessly with existing systems and
software used by real estate companies, such as accounting software, customer relationship
management (CRM) systems, and property management platforms. The user interface of
Capital Sprint ERP should be intuitive and user-friendly, catering to the needs of valuation
agents, administrative staff, and other end users who interact with the system on a daily basis.
The system should be designed to deliver high performance and reliability, ensuring fast
response times and minimal downtime during peak usage periods. Capital Sprint ERP should
offer flexibility and customization options to meet the specific requirements and workflows
of different real estate companies and property valuation processes. The cost of implementing
and maintaining Capital Sprint ERP should be reasonable and within budget constraints for
real estate companies, taking into account licensing fees, implementation costs, and ongoing
support expenses.
14
4.2 System Model: UML diagrams
ER Diagram
Use Case diagram for Admin/Coordinator
Fig 1
15
Fig 2
16
Use-case diagram for Employee
Fig 3
17
Class Diagram
Fig 4
18
Object Diagram
Fig 5
19
Sequence diagram for Admin
Fig 6
20
Sequence diagram for Employee
Fig 7
21
Activity diagram for Admin
Fig 8 22
Activity diagram for Employee
Fig 9
23
Collaboration diagram for Admin
Fig 10
Fig 10
24
State chart diagram for Admin
Fig 11
25
State chart diagram for Employee
Fig 12
26
Fig 13 -Component diagram for Admin
28
4.3 Data Model
1.User
Attribute Name Data type and size Constraints Description
Uid int(11) Primary key Store User id
(Auto Increment)
uname Varchar(50) Store User Name
email Varchar(50) Store Email Id
pass Varchar(10) Store Password
contact Varchar(10) Store Contact
ac_add Varchar(10) Add access
ac_edit Varchar(10) Edit access
ac_delete Varchar(10) Delete access
type Varchar(20) Add User type
Access data Text Access Menu
Save_date Date Store Date
2.Employee
29
3.Enquiry
4.Setting
Attribute Name Data type and size Constraints Description
Sid int(11) Primary key Store Setting id
(Auto Increment)
Header Text Varchar(200) Store Header
Text
Footer Text Varchar(100) Store Footer
Policy Text Text Store Policy Text
Logo Varchar(100) Store Company
Logo
Email Varchar(100) Store Email Id
Pass Varchar(100) Store Password
Port_no Varchar(100) Store SMTP port
Host_name Varchar(100) Store Host Name
Root_folder Varchar(100) Store Link
5.Orders
30
(Auto Increment)
Eid Varchar(200) Foreign Key Store Employee
ID
Uid Varchar(100) Foreign Key Store User ID
img Text Store Image List
Loc_name Varchar(100) Store Location
Name
Site_add Varchar(100) Store Site
Address
O_name Varchar(100) Store owner
name
O_email Varchar(100) Store owner
email
Mob_no Varchar(100) Store owner
contact
landmark Varchar(100) Store landmark
Com_add Varchar(1000) Store
Communication
Address
Near_by brand Varchar(100) Store brand
Floor Varchar(100) Store Floor
Details
Car_are Varchar(100) Store Carpet
Area
Mez_floor Varchar(100) Store Floor
Details
Dimension Varchar(100) Store Space
Dimension
Ele_load Varchar(100) Store Electricity
Load Details
Water_con Varchar(100) Store Water
Connection
Details
Toilet Varchar(100) Store Toilet
Details
Rental Varchar(100) Store Rental
amount
Deposit Varchar(100) Store Deposit
amount
Escalation Varchar(100) Store Escalation
year
Percentage Varchar(100) Store Rent
31
Percentage
Remark Varchar(1000) Store Remark
Sts Varchar(100) Store Property
Status
Latitude Varchar(100) Store Latitude
coordinate
Longitude Varchar(100) Store Longitude
coordinate
Ppt Varchar(100) Store PPT Name
Save_date Date Store Date
32
2) Website
Login
33
Dashboard
Sidebar
34
App Data
All Property
35
Property Details
36
All Employee
37
Add Employee
All User
38
Add User
All Query
39
Profile
Profile
Report
40
Setting
41
CHAPTER 5
IMPLEMENTATION DETAILS
42
CHAPTER 5 IMPLEMENTATION DETAILS
5.1 Software/hardware specifications, etc.
Hardware requirement-
• CPU: Intel I3 or Above
• RAM: 8Gb
• Hard Disk: 3 GB
Software requirement:
Front End- Ionic, Android, HTML, CSS, Bootstrap, Angular, Ajax, TypeScript
Back End- PHP
Database -MySQL
Server -Apache Server 2.0
Design Tool - Figma
Documentation Tools -MS Office
Web requirement:
Bandwidth- 1mbps(minimum)
Internet-512 kbps(minimum)
Web Browser- Microsoft Internet Explorer, Mozilla, Google Chrome or later
43
CHAPTER 6
OUTPUTS AND REPORTS
44
CHAPTER 6 OUTPUTS AND REPORTS
45
CHAPTER 7
TESTING
46
CHAPTER 7 TESTING
7.1 Test Plan
The purpose of the test plan was communicated to the testing team, providing an overview of
the testing objectives and scope. Test cases were executed according to the test plan, covering
various aspects of Capital Sprint ERP related to property valuation. Functional testing
focused on customer management, property management, valuation processes, and
integration with external systems. Performance testing involved measuring system response
times and scalability under different scenarios. Assigned testers executed test cases according
to their designated responsibilities, following the established test procedures. Testers
documented their findings, including test results, defects, and issues identified during testing.
Test reports were generated periodically, summarizing test results, including pass/fail status,
defect metrics, and recommendations for improvement. The test plan concluded with an
assessment of the system's readiness for deployment, highlighting any outstanding issues or
risks that needed to be addressed before production release.
47
7.2 Testing
7.2.1 Black Box Testing or Data Validation Test Cases
Test Case Expected
ID Test Description Test Steps Result Actual Result Pass/Fail
1. Open the
Capital Sprint
ERP login Login page is
TC001 Login functionality page. displayed. As expected Pass
User is logged
2. Enter valid in successfully
username and to the
password. dashboard.
1. Navigate to
the Customers
"Customers" module is
TC002 Customer creation module. accessible. As expected Pass
2. Click on the
"Add Customer
Customer" creation form is
button. displayed.
3. Enter valid Customer is
customer successfully
details. created.
1. Navigate to
the Properties
Property details "Properties" module is
TC003 entry module. accessible. As expected Pass
2. Click on the
"Add Property entry
Property" form is
button. displayed.
3. Enter valid Property details
property are successfully
details. saved.
1. Navigate to
the Valuation
"Valuation" module is
TC004 Valuation process module. accessible. As expected Pass
2. Select a Property details
property for are loaded for
valuation. valuation.
3. Verify Valuation report
valuation is generated
report with accurate
48
Test Case Expected
ID Test Description Test Steps Result Actual Result Pass/Fail
generation. data.
1. Access the
CRM system
Integration with and navigate to CRM system is
TC005 CRM system customer data. accessible. As expected Pass
2. Verify
synchronizatio Customer data is
n with Capital synchronized
Sprint ERP. without errors.
1. Simulate System is able
100 concurrent to handle the
Performance under users accessing load without
TC006 load the system. crashing. As expected Pass
1. Log in as a
new user and
navigate Navigation is
through the intuitive and
TC007 Usability testing system. user-friendly. As expected Pass
1. Generate a
valuation Report is
report for a generated with
TC008 Report generation property. accurate data. As expected Pass
1. Verify that
sensitive data Data encryption
is encrypted in is applied to
TC010 Data encryption the database. sensitive fields. As expected Pass
1. Perform a
search for a Customer record
Search customer by is displayed in
TC011 functionality name. search results. As expected Pass
1. Enter Error message is
invalid data displayed
format in a indicating
TC012 Data validation form field. invalid data. As expected Pass
Error message is
1. Intentionally displayed with
trigger an error clear
TC013 Error handling condition. instructions. As expected Pass
User is logged
out and
Logout 1. Click on the redirected to the
TC014 functionality logout button. login page. As expected Pass
Accessibility 1. Use a screen System interface
TC015 compliance reader to is accessible to As expected Pass
49
Test Case Expected
ID Test Description Test Steps Result Actual Result Pass/Fail
navigate the screen readers.
system.
1. Perform a Data backup is
Data backup and data backup completed
TC016 recovery operation. without errors. As expected Pass
1. Access
Capital Sprint System interface
ERP from renders
Cross-browser different web consistently
TC017 compatibility browsers. across browsers. As expected Pass
1. Leave the User session is
system idle for terminated and
the session user is
TC018 Session timeout timeout period. redirected. As expected Pass
1. Log in with
multiple user System allows
accounts concurrent user
Concurrent session simultaneously sessions without
TC019 management . issues. As expected Pass
1. Import Property data is
property data successfully
from a CSV imported
TC020 Data import/export file. without errors. Pass
50
7.2.2 White Box Testing or Functional Validation Test cases and
results
Test
Case ID Test Description Expected Result Actual Result Pass/Fail
User should be
Verify login functionality logged in
WBTC01 with valid credentials successfully As expected pass
51
securely
52
CHAPTER 8
CONCLUSION
53
CHAPTER 8 CONCLUSION
Conclusion
The Project “Capital Sprint ERP (Property Valuation Website and App)” is
designed in order to reduce the burden of property valuation for multiple property details.
Inserting, retrieving, editing and updating the Customer details is easy when it is compared to
the manual storing. Maintaining the project is easy which is also easily understandable.
Maintaining the details in the database is manageable. Within very less time we can create
ppt and send email.
We have automated and digitised the data collection and data processing of
customer which is cost effective and it is time saving. Also, the data is centralised and can be
viewed at any point of time, which makes the system self-sustained.
54
CHAPTER 9
FUTURE SCOPE
55
CHAPTER 9 FUTURE SCOPE
Enhance the reporting and analytics capabilities of the system by incorporating advanced data
analysis techniques, predictive modeling, and machine learning algorithms. This can provide
deeper insights into property trends, market dynamics, and valuation accuracy. Integrate AI
technologies, such as computer vision and natural language processing, to automate data
extraction from property images and documents.
This can streamline the data collection process and improve efficiency. Increase the
integration with external market data sources to access a broader range of property and
market information. This can include historical sales data, rental trends, market forecasts, and
demographic data.
Improve the collaboration features within the web portal to facilitate seamless
communication between coordinators, employees, and clients. This can include real-time
messaging, document sharing, and task management capabilities.
56
CHAPTER 10
BIBLIOGRAPHY
57
CHAPTER 10 BIBLIOGRAPHY
1. Freeman, Adam. Angular: Up and Running. O'Reilly Media, 2021.
2. Suleiman, Simon. Learning Ionic: Build Hybrid Mobile Applications with HTML5,
CSS3, and JavaScript. Packt Publishing, 2020.
3. Sklar, David. PHP Cookbook: Solutions & Examples for PHP Programmers. O'Reilly
Media, 2014.
5. Griffith, Adam. Mastering Ionic 5: Build Cross-Platform Apps with Ionic 5 and
Angular. Packt Publishing, 2021.
6. Lengstorf, Jason, & Doherty, Brian. Full-Stack React, TypeScript, and Node: Build
Cloud-Ready Web Applications. O'Reilly Media, 2023.
7. Williams, Robin. Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5.
O'Reilly Media, 2018.
Websites
• https://www.w3schools.com/
• https://getbootstrap.com
• https://ionicframework.com/docs
• https://angular.io/start
• www.youtube.com
• www.stackoverflow.com
58