SUPERTECH BUILDERS E-SERVICES
MANAGEMENT SYSTEM
Under Supervision of : ……………………………
Submitted By:
Name : …………………………….
Enrollment No : …………………………….
Study centre Code :
Study Centre Name :
SUPERTECH BUILDERS E-SERVICES
MANAGEMENT SYSTEM
Contents of the Synopsis
S. No | TOPIC | P. No |
1. | Introduction | 4 |
2. | Objective & Purpose of the System | 5 |
3. | Project Category | 6 |
4. | Inputs and Outputs of the project | 7 |
5. | Project Planning & Scheduling | 8 |
6. | Operating Environment | 10 |
7. | Existing System & Need for System | 12 |
8. | ER-Diagram | 14 |
9. | Data Flow Diagram | 15 |
10. | Modules and Table Design
i) Modules & their description ii) Database Design |
23
|
11. | Security | 29 |
12. | Future scope & proposed enhancement of the project | 30 |
13. | Conclusion | 31 |
14. | Bibliography | 32 |
- INTRODUCTION
Supertech Builders E-Service Management System is a web based project which act as a bridge between users and Supertech Builders.
Supertech Builders E-Service Management System provides complete listing of building projects available in different areas. Users can get their booking information, payment plans and payment details along with e-service request using a single login ID. This project is designed to provide comprehensive mechanism of booking for general users. Supertech Group has already converted more than 33 million sq. ft. area of residential and commercial entity into architectural landmarks and more than 36 projects that accommodates nearly 30000 families. Its various projects viz. Residential & Commercial Townships, Shopping Malls, Hotels and IT Parks have either completed or about to complete. This web project is designed to help users as well as Supertech Group to full fill the needs.
General users can get information about the new building projects, ongoing projects, projects completed and future plans.
Administrator is an authorized user he can:
- Add projects details.
- Add Users Details.
- Updating Booking Status.
- Adding Member Details.
- Using Mailbox.
- Report generation.
- Adding Payment Plans.
- Adding Payment Details.
- Adding Floor Plans
- OBJECTIVES OF THE SYSTEM
The objective of this development effort is:-
- To provide the information regarding Projects available in residential, commercial, township, hospitality etc.
- To provide the information about the Booking of users choice.
- To provide the functionality of online Booking and Cancellation.
- To provide the information of status of the ongoing building projects and projects completed.
- To provide the facility to maintain the records of users.
- Information can be easily accessed.
- This system will save the time of the Users and Administrator.
PURPOSE
Supertech Builders E-Service Management System is aimed at automation of booking flats, commercial places etc. to Supertech Group and thus to develop customize software package for Supertech Group.
- PROJECT CATEGORY
This Project is coupled with material on how to use the various tool, sub sets available in PHP AND My SQL. The need of today’s software development is competence in a GUI based front-end tool, which can connect to Relational Database engines. This gives the programmer the opportunity to develop client server based commercial applications. These applications give users the power and ease of a GUI with the multi user capabilities of Novell, UNIX or WinNT based RDBMS engines such as My SQL. All the important coding techniques used by programmers, in OOPS based coding is brought out in full and in great detail.
- INPUTS AND OUTPUTS OF THE PROJECT
Input to the Project:
- Adding Project Details by Admin
- Adding Price Details by Admin
- Adding Floor Plans by Admin
- Adding Payment Plans by Admin
- Category projects as Residential, Commercial, Townships and IT Plans.
- Feedback Details given by the users
- New User details
- Booking Details given by the users
Output of the Project:
User can get information about
- Properties Available
- Ongoing Projects
- Completed Projects
- Payment Plans
Admin can get
- Feedbacks from users
- Users Details
- Booking Details
- PROJECT PLANNING & SCHEDULING
GANTT CHART
Activity | 0-5 days
|
6-25 days | 26-50 | 50-80 | 81-85 | 86-90 | |||||||
PROBLEM FORMULATION
PRELIMNIARY INVESTIGATION
SYSTEM ANALYSIS
SYSTEM DESIGN
CODING
TESTING
IMPLEMENTATION
|
|
|
PERT CHART
- OPERATING ENVIRONMENT
HARDWARE & SOFTWARE
HARDWARE:
Processor : Pentium 2.4 GHz or above
Memory : 256 MB RAM or above
Cache Memory : 128 KB or above
Printer : Laser Printer
Pen Drive : 5 GB
SOFTWARE:
Operating System : Windows XP (Professional), WAMP Server.
Font-End Tool : PHP, Java Script
Back-End : My SQL (phpmyadmin)
PHP
PHP is a widely-used general-purpose scripting language that is especially suited for Web development and can be embedded into HTML. PHP, or PHP: Hypertext Preprocessor, is a widely used, general-purpose scripting language that was originally designed for web development, to produce dynamic web pages. It can be embedded into HTML and generally runs on a web server, which needs to be configured to process PHP code and create web page content from it. It can be deployed on most web servers and on almost every operating system and platform free of charge. PHP is installed on over 20 million websites and 1 million web servers. PHP has evolved to include a command line interface capability and can also be used in standalone graphical applications.
PHPMY ADMIN (My Sql)
PhpMyAdmin is a free software tool written in PHP intended to handle the administration of My SQL over the World Wide Web. PhpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.
- EXISTING SYSTEM AND NEED FOR SYSTEM
The existing system is manual /machine systems where the users must have to perform their manually. It will take more time and this whole procedure is very tedious and takes a lot of time.
Problems of the existing system
- It is limited to a single system.
- It has lot of manual work (Manual work does not mean working with pen or paper, rather includes working on spread sheets and other simple software.)
- The present system is very less secure.
- It unable to generate different kinds of reports.
- It is difficult to maintain phone bookings and cancellations.
- Does not provide global support. User cannot do the reservation from remote place.
- Retrieval of information is difficult and time consuming.
- A lot of time and manual effort is required
SCOPE OF WORK
The scope of the system is defined on the basis of various functionalities provided by the system. The scope can be explained as:-
- Build a web based system.
- Information handling of all users who travel between the difference routes i.e. new booking list will be created, data retrieval, updates in the information.
- Information handling of the booking of the flats or shops i.e. new records can be created, data retrieval, update and cancellation of the booking functionality.
- The scope of the project is to develop customize software package for reducing the manual problems.
- It should deals with the online booking as well as cancellation.
- This system never decreases the manpower but helps the development of available manpower and optimizes the manpower by which Supertech Group’s standards and capabilities can be scaled to higher dimension.
- ER-DIAGRAM
- DATA FLOW DIAGRAM
CONTEXT LEVEL DFD FOR SUPERTECH BUILDERS
E-SERVICE MANAGEMENT SYSTEM
4.
Projects
|
2.
Cancellation
|
1.
Booking |
6.
Payment Details |
5.
Payment Plans |
3.
Availability & Facilities |
SUPERTECH BUILDERS E-SERVICE MANAGEMENT SYSTEM |
DFD for Login Module
USER |
Accept the user Name & Password |
Authenticate
The Password |
SUPERTECH BUILDERS E-SERVICE MANAGEMENT SYSTEM
|
Screen
Home |
Login Module
DFD for Booking Module
Customer |
1.1
Accept the Customer booking request |
1.4
Generate Response or Booking Id |
1.2
Authenticate The Password |
Invoice |
1.3
Book the Property |
Accounts |
Property |
Booking |
Customer |
SUPERTECH BUILDERS E-SERVICE MANAGEMENT SYSTEM
|
DFD for Cancellation Module
Invoice |
Customer |
2.1
Accept the Customer request from user |
SUPERTECH BUILDERS E-SERVICE MANAGEMENT SYSTEM
|
2.2
Check the Validate from Booking Table |
2.3
Cancel the booking |
Cancellation |
Booking |
Accounts |
DFD for Entering the Building Project
ADMIN |
3.1
Enter Project Details |
3.2
Validate & Store in the Database |
SUPERTECH BUILDERS E-SERVICE MANAGEMENT SYSTEM
|
Property |
DFD for Adding New Project
ADMIN |
4.1 Adds New Projects |
4.2 update the Money & per Square Foot Details |
Supertech Builders
E-Service Management System |
4.3 Project Details Updates |
Update Data |
DFD Payment Plans
ADMIN |
5.1 Generate New Payment Plans |
5.2 Update the payment plans for CLP, DP |
Supertech Builders
E-Service Management System |
5.3 update Payment |
Update Data |
Print/ Screen |
Payment |
DFD for Booking Inquiries Form
Customer |
6.1
Accept the Customer request |
SUPERTECH BUILDERS E-SERVICE MANAGEMENT SYSTEM
|
6.2
Check the Database for the require |
Booking
Status |
6.3
Respond to the customer |
Project |
Booking |
- MODULES AND TABLE DESIGN
- i) Modules & Their Description
The Supertech Builders E-Service Management System deals with the information System for Property Bookings. This project explains about the booking of properties developed by Supertech Group of builders. This group is constantly working for the development and shaping of land as well as contributing in the progress and growth of nation. This website helps any authorized person to book through internet and also shows the availability of a particular flat at the chosen location. The project is divided into different modules. They are follows:-
- Administration: This module is divided into different sub-modules, they are:-
- Booking
- Projects Available
- Payment Plans
- Payment Details
- Services
- Reports
- Search
- Users: This module is specially for Customers:-
- Service Details
- Projects Availability
- Booking
- Selecting Payment Plans
- Get information about the ongoing projects
- Get information about the projects completed
- Get information about the future plans
Project Details: Once the user click on this module he/she will be able to know the Project details along with its mode of services, he also can know these best services by his past records. This will also inform the customer how flexible mode of booking/secured/punctual it is.
Password: In this module, this website is for multiple users. If a User enters a password and the software checks its validity. If the password is valid then option is given to change the password, otherwise “Invalid User/Password” message is displayed. There is an option for password recovery, log out, login, new users sign in. The Administrator can also update changes in the site after login.
Feedback: This module keeps track of all the feedbacks given by the users for future records.
Reports: This module concerns with various report generation based on the Admin request. Following types of reports are generated-
- Project Details
- Plans Details
- Booking Status
- Payment Details
- Feedback Reports
Availability: The system also keeps track the information of the booking, whether it is available at chosen location or not.
- ii) DATABASE DESIGN
Admin Table
Field | Type | Constraint | Description |
Username | Char (30) | Not null | Admin user name |
Password | Char(30) | Not null | Admin user password |
Booking Table
Filed | Type | Constraint | Description |
Booking_No | Char (30) | Primary Key | Booking No |
Member_Id | Char(30) | Not null | Member Id |
Email_Id | Char (30) | Not Null | Email Id |
Name | Char (30) | Not Null | Name |
Address | Char (30) | Not Null | Address |
Date of booking | Date | Not Null | Date of booking |
Property_type | Char (30) | Not Null | Property type |
Location | Char (100) | Not Null | Location |
City | Char (30) | Not Null | City |
State | Char (30) | Not Null | State |
Users Table
Description: To store login details of the online users.
Field | Type | Constraints | Description |
User id | Char (30) | Primary Key | Id of user |
Username | Char (30) | Not Null | Name of user |
Password | Char (30) | Not Null | Password of user |
Char (20) | Not Null | Email of user | |
Security_question | Char (80) | Not Null | Security Question |
Answer | Char (50) | Not Null | Security Answer |
Feedback Table
Description: To store feedback details.
Field | Type | Constraints | Description |
Name | Char (30) | Not Null | Name of user |
Phone | Char (30) | Not Null | Phone No. of user |
Comment | Char(30) | Not Null | Comments given by users |
Project_Type Table
Description: To store details of the project types handled by the super Tech group. Super Tech Groups is handling residential, commercial, townships, hospitality and it Parks.
Field | Type | Constraint | Description |
Type_id | Char (30) | Not null | Id of Project |
Project_Type | Char(30) | Not null | Type of Project |
Project_details Table
Description: To store details of the project.
Field | Type | Constraint | Description |
Project_id | Char (30) | Not null | Project Id |
Project_Type | Char(30) | Not null | Project Type |
Plot_Area | Char (30) | Not Null | Plot Area |
Built_up_area | Char (30) | Not Null | Built up Area |
Dwelling_unit | Char(30) | Not Null | Dwelling unit |
Type_of_Units | Char (30) | Not Null | Type of units |
Project_cost | Char(30) | Not null | Project Cost |
Status | Char (30) | Not Null | Status |
Description | Char (250) | Not Null | Description |
Price Details Table
Description: To Store price details. These details are added by the administrator.
Field | Type | Constraint | Description |
Acc_type | Char (30) | Not null | Accomodation Type |
Super_area | Char(30) | Not null | Total area |
DPP | Char (30) | Not Null | Down Payment Price |
Flexi | Char (30) | Not Null | Flexi Payment Price |
CLP | Char(30) | Not Null | Construction Link Plan |
Payment Plans Table
Description: To store details of the payment plans three types of plans are available down payment plans, Flexi plans and construction link Plan.
Field | Type | Constraint | Description |
Particulars | Char (30) | Not null | Plan Details |
Percentage | Char(30) | Not null | Installment in Percentage. |
Plan_ Type | Char (80) | Not Null | Plan Type |
Plan_Name | Char(80) | Not Null | Plan Name |
Total_Amount | Char(80) | Not Null | Total Amount |
Property Type | Char(80) | Not Null | Property Type |
Duration | Char (80) | Not Null | Duration |
Floor Plans: SuperTech Group Provides 2, 3 and 4 Bedrooms apartments, area of which range between 930 sq.ft. To 2385 Sq.Ft. Floor Plans are 4 sided open.
Field | Type | Constraint | Description |
Project_Type | Char (30) | Not null | Project Type |
Area | Char(30) | Not null | Area |
Image | Char (80) | Not Null | Photograph of the floor plan |
Plan_Type_Table
Description: There are three types of plans- Down Payment, Flexi Payment and Construction link
Field | Type | Constraint | Description |
Plan_id | Char (30) | Primary Key | Plan No |
Plan_Type | Char(30) | Not null | Type of Plan |
Plan_ Type | Char (80) | Not Null | Plan Type |
Property Table
Field | Type | Constraint | Description |
Property_No | Char (80) | Primary Key | Property No |
Super Area | Char (80) | Not null | Area |
State | Char (80) | Not Null | State |
City | Char (80) | Not null | City |
Plan_Type | Char (80) | Not Null | Plan Type |
Plan_No | Char (80) | Not Null | Plan No |
Property Type | Char(80) | Not Null | Property Type |
Customer Table
Field | Type | Constraint | Description |
Cust_Id | Char (30) | Not Null | Customer Id |
Name | Char(30) | Not null | Name |
Address | Char (80) | Not Null | Address |
City | Char (80) | Not Null | City |
Payments Table
Field | Type | Constraint | Description |
Cust_Id | Char (30) | Not Null | Customer Id |
Tran_Id | Char(30) | Not null | Transition Id |
Payment_Details | Char (80) | Not Null | Payments Details |
Trans_Data | Char(80) | Not Null | Transition Id |
Amount | Numeric | Not Null | Amount |
- SECURITY
The security measures have been taken to make the software full proof in terms of various activities:-
- Authorization of the user as well as administrator
- Input Validations of the forms
- Output Validations of the result
- Login timing to maintain the Session management
- Logout timing of the user
- Data Security
- Software Security
- Hardware Security
- Illegal copying should be restricted
These are the few measures that are taken into account to meet the security measures while developing a project for an organization.
- FUTURE SCOPE & PROPOSED ENHANCEMENT OF THE PROJECT
DRAWBACKS:
- No automatic backup facilities available.
- To run the application Internet Explorer 5.0 and above is required.
- High bandwidth is required for as the transaction rate is high and Third party gateway.
LIMITATION:
- The project we will created is single user & does not support the multiuser environment i.e client / server.
- The project is web based & not the window based as required in most of the companies for admin panel.
- This project requires internet connection as this is a web based project.
- The project can be used only by a person who has complete knowledge of building plans.
- After the completion of the application software, the memory needed by it should be available on the hard disk.
FUTURE SCOPE:
- We can enhance the project by adding other types of properties details like commercial property, industrial property etc.
- We can add modules of Admin records (Employee details Modules, Attendance module, Salary Module)
- This is not a live project, we can upload this project by purchasing domain name and space from the web hosting companies.
- CONCLUSION
This project is designed to meet the requirements of the users for online purchasing or SUPERTECH BUILDERS E-SERVICES MANAGEMENT SYSTEM. It has been developed in PHP, keeping in mind the specifications of the system.
For designing the system we have used simple data flow diagrams.
Overall the project teaches us the essential skills like:
- Using system analysis and design techniques like data flow diagram in designing the system.
- Understanding the database handling and query processing using MY SQL.
- BIBLIOGRAPHY
- Senn James A : Analysis and Design of Information Systems, McGraw Hill, International Ed, 1989.
- O’Brien Jamea A : Management Information Systems, Galgotia Publications Pvt Ltd, New Delhi, 1998.
- Laudon & Laudon : Management Information Systems, Organisation and Technology, PHI, New Delhi, 1998.
- Wetherebe James : Systems Analysis and Design, Galgotia Publications Pvt Ltd, New Delhi, 1990