By adminOn

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

 

 

 

 

 

 

 

  1. 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

 

 

 

  1. 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.

 

  1. 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.

 

  1. 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

 

 

 

 

 

 

 

 

 

  1. 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

 

  1. 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.

  1. 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.


  1. ER-DIAGRAM

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  1. 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

 

 

  1. MODULES AND TABLE DESIGN

 

 

  1. 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:-

  1. Administration: This module is divided into different sub-modules, they are:-
    • Booking
    • Projects Available
    • Payment Plans
    • Payment Details
    • Services
    • Reports
    • Search

 

  1. 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.

 

 

 

 

 

  1. 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
Email 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

 

 

  1. SECURITY

 

The security measures have been taken to make the software full proof in terms of various activities:-

 

  1. Authorization of the user as well as administrator
  2. Input Validations of the forms
  3. Output Validations of the result
  4. Login timing to maintain the Session management
  5. Logout timing of the user
  6. Data Security
  7. Software Security
  8. Hardware Security
  9. 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.

 


  1. FUTURE SCOPE & PROPOSED ENHANCEMENT OF THE PROJECT

 

DRAWBACKS:

  1. No automatic backup facilities available.
  2. To run the application Internet Explorer 5.0 and above is required.
  3. High bandwidth is required for as the transaction rate is high and Third party gateway.

 

LIMITATION:

  1. The project we will created is single user & does not support the multiuser environment i.e client / server.
  2. The project is web based & not the window based as required in most of the companies for admin panel.
  3. This project requires internet connection as this is a web based project.
  4. The project can be used only by a person who has complete knowledge of building plans.

 

  1. After the completion of the application software, the memory needed by it should be available on the hard disk.

 

FUTURE SCOPE:

  1. We can enhance the project by adding other types of properties details like commercial property, industrial property etc.
  2. We can add modules of Admin records (Employee details Modules, Attendance module, Salary Module)
  3. This is not a live project, we can upload this project by purchasing domain name and space from the web hosting companies.

 

  1. 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.

 

  1. BIBLIOGRAPHY

 

  1. Senn James A : Analysis and Design of Information Systems, McGraw Hill, International Ed, 1989.
  2. O’Brien Jamea A : Management Information Systems, Galgotia Publications Pvt Ltd, New Delhi, 1998.
  3. Laudon & Laudon : Management Information Systems, Organisation and Technology, PHI, New Delhi, 1998.
  4. Wetherebe James : Systems Analysis and Design, Galgotia Publications Pvt Ltd, New Delhi, 1990