SAD PRoject Report

SKYLINE

SAD Project Report Submitted in partial fulfillment of the requirements For the award of the degree of MCA

Guide:

Submitted By:

Mr. Vaibhav Gupta

Laxmikant Thanvi

(Asst. Professor LMCST-Jodhpur)

Vishal Purohit

Submitted To Lachoo Memorial College of Science & Technology

(

Affiliated Affiliated to Rajasthan Technical University )

(Year – 2008-2011)

SKYLINE: Mobile And DTH Recharge

Lachoo Memorial College of Science & Technology Department of Computer Science

Certificate This is to certify that the project entitled

SKYLINE Has been designed and developed by

Laxmikant Thanvi Vishal Purohit In partial fulfillment of the degree of of MCA 2010, IV th Sem examination, Under our supervision and guidance.

Mr. Vaibhav Gupta Assistant Professor Date: 9 Feb.2008

Pr. R.L.Mathur Principal

Dr. Rajeev Mathur Director


SELF CERTIFICATE This is to certify that the dissertation/project report entitled “SKYLINE ” is done by us is an authentic work carried out for the partial fulfillment of the requirements for the award of the degree of MCA under the guidance of Mr. Vaibhav Gupta The matter embodied in this project work has not been

submitted earlier for award of any degree or diploma to the best of our knowledge and belief.

Laxmi Kant Thanvi Vishal Purohit


AKNOWLEDGEMENT

Words cannot express our thankfulness to Mr. Vaibhav Gupta about their able guidance, support, advice and suggestions, which are been a source of constant motivation. They helped during the entire development of this project work and spare a lot of time for us in the completion of project. We are sincerely grateful to Mr. Vaibhav Gupta without whose supervision and able guidance, our project would have ever been done as a good one. He went out of his way, provided us with openhearted help, and gives his priceless opinions A project is always teamwork and this work is not an exception, we are thankful to all of our batch-mates. We are also thankful to our other faculty members, friends, and parents who have helped us in making our project a success.

Mr. Vaibhav Gupta Asst. Professor Lachoo Memorial College of Science & Technology

Laxmikant Thanvi Vishal Purohit


CONTENTS I. II. III. 1. 2.

Certificate Self Certificate Acknowledgment Abstract System Analysis I. II. III. IV. V.

3.

System Design I. II. III. IV. IV.

4.

Intr Introd oduc ucti tion on to Syst System em Reco Recogn gnit itio ion n of of nee need d Propos Proposed ed System System or Soluti Solution on Advant Advantage agess of propos proposed ed Syst System em Feas Feasib ibil ilit ity y Stud Study y Data Data Flo Flow w Dia Diagr gram am (DF (DFD) D) Entity Entity Relat Relation ionshi ship p Diagram Diagram (E-R (E-R Diagram) Diagram) Input Input outp output ut chart chartss (IPO) (IPO) / Screen Screen Shot Shotss Menu enu Dia Diagr graam

Conclusion I. Advantages II. II. Limi Limita tattion ions III. III. Futu Future re Expa Expans nsio ion n

5.

Bibliography


1. Abstract


Abstract:Mobile Mobile and DTH Recharge Recharge services are the most common services that are available at the every 4 th and 5th retail shop. To recharge mobile phones of various service provider. They have to maintain individual connection for each and every mobile company. And they need to maintain different handsets for f or different services provid providers ers compan companies ies.. Some Some of them them have have rechar recharge ge coupon coupons, s, Rechar Recharge ge coupons are available for both mobile and DTH services, So Retailer have a stress to maintain all these things. To avoid this kind of problems we are developing a web-based application that is used to recharge the mobile phones and DTH Activation services. This application will provide a unique and compact solution to the retailer for recharge the mobile phones and DTH service providers, For this the retailer has to register itself an authorized agency for this purpose like (TRAI) after this registration they will provided an unique user Id and after they can start their job using this given user identification. Retailer can recharge the customers mobile. There is no need of customer presence. Customer can be where so ever. This Application must store the individual retailer database that is helpful for the retailer to maintain its day to day record of billing. By the use of this application the retailer can provide its relative service to the customer from anywhere. And the most important things which are retailer retailer will not have to maintain maintain various connections connections and mobile handsets. handsets. They can service the customers by the present internet connection with pc and further this application can be expanded to mobile m obile internet, also. Adoption of this application is may be little bit expensive then the present scenario but facilities provided by this application worth it.


2. System Analysis


2. 1.

Introduction:-

The Mobile and DTH Recharge application is the application which is useful for the retailer, they used to recharge the mobile phone by easy recharge and recharge coupon as well as DTH service. This application provides a web environment to the retailer for the regular recharge service, using this retailer can serve its services to the customer. To get this facility and having this proposed compact solution retailer have to register itself with government authorized agency like TRAI. This System can intimate all the three modes of the main system such as customer, service Providers Company and Regulatory Authority (TRAI) by sending a SMS regarding to the service facilitated. Retailers have to spend some more buds to get this dynamic system.

2. 2.

Disa Disadv dvan anta tage gess of exis existi ting ng cu curr rren entt syst system em

The present system is facing following problems:(1) Retailers Retailers have to carry different different recharge recharge coupons of several mobile mobile companies. (2) Retailers have to get various mobile connections of different mobile companies and respectively have to maintain different handsets too. Retail iler erss must must have have to cred credit it his his acco accoun untt as prep prepai aid d serv servic icee (3) Reta irrespective to the fact that he/she may or may not sell it to the customers, because it is not in its control. (4) In reference of online banking there is facility provided by the banks to recharge mobile from ATM machine by following required steps, in this solution customer must have ATM card. refere renc ncee to inte intern rnet et bank bankin ing g mobi mobile le and and DTH DTH faci facili lity ty,, its its (5) In refe providing on intranet the procedure which is followed needs a bank account. (6) In all alternative alternative facility with concerned to the proposed proposed system, there there is not any customer care service which can here them, so over system directly calibrated with RA so that will responsive to the RA.


2. 3.

Recognit cog nition ion of Need

As we go for recharge recharge our Mobile Mobile and DTH connecti connection on we go for retailer retailer shop and retailer gives us some options for recharge like recharge coupons, e-top ups, for e-top up recharging users must have to carry different type of mobile connection of various companies and as well as mobile hand sets. This whole procedure seems very exhausting process. Thus, Thus, we need need automa automated ted softwa software re which which must must reliab reliable le and serve serve high high performance with simple user interface to retailers and service providers. We need software solution solution for this to decrease burden on both service provider provider and retailers in terms of limit allocation, automation, speed and compactness and give them feel of unique system which provides different services.

2. 4.

Proposed Solution

As consid consider er the recogniz recognized ed of needs needs the proposed proposed system system will will give give all required automated solution with full compactness that will provide easy user interface. We will develop software which provides a compact solution for above all recognized problem with the existing system. For this solution we establish centre control that will guide and control all retailers concerned with the proposed system i.e. mobile recharging, DTH recharging etc. By using proposed software the recharging of Mobile Phones and DTH are online. So, It will helpful to reduce papers i.e. RCV. Retailer don't have to maintain any mobile connection for recharge and by this software user get compact solution for provide basic service to ultimate customers on just a Few click.


2. 5. 5.

Advantages ges of of Pr Proposed Sy System

The proposed system has following advantages against the existing system:-

(1) Retailers don’t have have to contain different type of recharge recharge RCVs. (2) (2) Reta Retail iler erss don’ don’tt have have to get get vari variou ouss mobi mobile le conn connec ecti tion onss of different mobile companies and respectively have to maintain different handsets. (3) (3) Reta Retail iler erss don’ don’tt have have to credi creditt his his acco accoun untt as prep prepai aid d serv servic icee irrespective to the fact that he/she may or may not sell it to the customers, because it is not in its control. (4) Customer does not not need to have any bank bank account for recharging in reference of online banking, he just have to go retail shop and say for recharge. Compla lain intt and and feed feedba back ck syst system em is inco incorp rpor orat ated ed with with the the (5) Comp proposed system which will help to improve system in future and maintenance purpose.


2. 6. 6.

Feasibility St Study

After Considering all the User Requirements and identification of System Objectives, Feasibility Study is carried out that is Concerned with assessing whether the System is useful to business or not and Whether system meets performance standards or not. Any System Performance in judged under 3 steps:Identification of Specific system Objectives • •

Constraints Identification with Limitations regarding towards overall system solution and identifying up to which extend system contributes to business.

•

Description of outputs as required by the potential users.

There are three types of feasibility study considerations:1. Econom Economica icall Feas Feasibi ibilit lity y

The proposed system requires one-time investment that is only initial capital cost: Hardware Cost •

•

Software installation cost

•

Software Development Cost

•

Software Deployment Cost

•

Intranet Networking Cost

However, Proposed System May incur equipment operational cost such as: Annual Registration fee imposed by Regulatory Authority •

•

Maintenance Cost


2. Tec Techni hnical cal Feasi Feasibil bility ity

Technical Technical Feasibilit Feasibility y Considerati Considerations ons Concerned Concerned with Following Following Situation:Wheth hetheer the the curre urrent nt/e /ex xisti istin ng syste ystem m comp compat atib ible le enoug nough h to • accommodate and adopt technical enhancements proposed by the candidate system. •

Hardware, software repairs and availability, maintenance in case of damage or wear-tear.

In our project “Mobile and DTH Recharge via intranet” we propose following software and hardware: Software Requirements:-



•

Asp.Net Framework

•

Ms-Access or Ms- SQL Database

•

Microsoft windows XP(os) or above

•

Intranet Supported HTTP/FTP Compatible Compatible Software

Hardware Requirements:



For Server:•

256 Mb RAM (512 Recommended)

•

40 GB Hard disk

For Users or Retailers:•

128 Kb ROM for System Classes

•

Kb RAM for Application Classes


3. Beh Behavi aviora orall Feas Feasibi ibilit lity y

People always initially resist for changes. Any user finds uneasy to adopt and and swit switch ch over over to new new syst system em for for exis existi ting ng syst system em due due to lack lack of comput computer er knowle knowledge dge,, inerti inertiaa and wrong wrong assump assumptio tions ns for automa automated ted systems. The Proposed System is quite :User Friendly • •

Interactive

•

Gives look and feel of technical standards

•

Differentiate from rivalries in terms of technical advancement

•

User need not to require any profound technical knowledge or skills to use system.

By the the all all abov abovee disc discus ussi sion onss and and cons consid idera erati tion onss we conc conclu lude de that that proposed system is required of time, contributes to business in terms of cost, technical advances the existing system.


3. System Designs


3.1 Data Flow Diagrams .


Context Diagram : DFD ( Level 0 )

INTRANET

Service Provider 1

Dealers Service Provider 2

R.A. SERVER Service Provider 3 Retailers

Service Provider n


Retailer Registers in Data Base

New Registration Acknowledgment (id & Pwd) Form

Ack Mail

Request

Dealer

R.A. Response

Authentication Check

Login Process

Phase 1 DFD ( Level 1 )

Dealer Details


Retailer Reg in Database

New Registration Acknowledge via e-mail

Form

Ack Mail

Reg to

Req

Retailer

Dealer Res

R.A. Res

Authentication Check

Login Process


Dealer Details


Req

Retailer

R .A . Res

A/c Update

Received Receipt

Verify

Check From DB

Banking Process

Retailer Details

Verify ID & PWD Exist

Bank Receipt Balance

Request Bank

Get Info For Bal

Balance Info Req

Get Balance

Re-fill Balance

Update Bal Balance Details

Balance Request Process Not Enough

Chk DB



Recharge Request

Customer

Retailer

Amount Update Fill Info

Form Filling

Ackg

Ackg

Airtel/Idea etc

Service Provider

Done Ackg

Check R.A. Registration ID

Recharge Amount Yes Recharge

Valid User

Chk User

Autherized

Authorized ID / PWD

R.A. Chk Db


Ackg

Reg For New Registration Store in Db

New Rgistration

SKYLINE: Mobile And DTH Recharge Response (uid & pwd) via e-mail

Ack Form Fill FormAck

Form Fill Req

Retailer

Req

Dealer Res

R.A. Res

Chk Db

Dealer/Retailer Details

Authentication Check Banking Process

Valid User

R.A. Verified

Login Process

ID / PWD

Request for Balance

Service Provider

Get Balance

Re-fill Balance

Check Balance Not Enough Update Account

nce la nc n Ba la ro m Ma i n t F ro uc t F De Ded uc

Req For Recharge

Customer

Enough Balance

Ack Inform get Balance

Re-Charge

Generalized DFD ( Level 2 )


3.2 ER Diagrams


Main ER Diagram ( R.A. Side )

FirmNam e

password

R_ID S_Type Proof Doc

DOB Rtlr_MST R

DOB

Signature

Registratio n

Retailer R_ID Photo ID

Firm Name Owner Name

R.A.


Sub ER Diagram 1 ( R.A. Side )

Firm_Nam e SPN R_ID

Owner_Name

Mobile_No

R_ID Photo_ID

Retailer

Recharge_MSTR

Facili ty Mode

Signatur e

DOB

Date City

Proof_Do c

DTH_MSTR C_ID

Date

CON

Pkg_Price Package



Firm_Nam e Add R_ID

Frirm_Nam e

Owner_Name R_ID Photo_ID

Adre ss

Retailer

Signatur e

DOB Proof_Do c

Locator

ZIP Contact_N o City



Rtl_Mstr SPN Acc_No

SP_ID

Retailer

Maintai n Data Base

Service Provider

Amount Date



Rtl_Mstr SPN Acc_No

SP_ID

Retailer

Maintai n Data Base

Service Provider

Amount Date


Main ER Diagram ( Retailer Side )

Pkg Price

Package

DTH Log

CON

Date

C_ID Proof Doc

R_ID Signatur e

DOB

Firm Name

Maintai ns

Retailer

Limit Log

R_ID L_Amou nt

Photo ID

Firm Name

Date

Owner Name

Date

Mobile No. Mobile Log

Mode

SPN

Name


3.3 Database Tables


Databas Databasee Tables Tab les (R.A. (R.A. Side) Sid e) 1. Retail_MSTR Field Name R_ID Firm_Name Allotted_Password Date_of_Membership Service_Type

Data Type / Constraints Size Description Varchar 16 User ID Varchar 25 Name of Firm Password 16 Password Date ** Date and Time Varchar 10 Type of Service

2. Retailer_Detail Field Name R_ID Firm Name Owner_Name Photo_ID Signature_ID DOB Proof_Document

Data Type / Constraints Varchar Varchar Varchar Integer Integer Date Varchar

Description User ID Name of Firm Name of Owner Photo of User Signature of User Date and Time Document name for proof

Size 16 25 25 ** ** ** 10

3. Recharge_MSTR Field Name R_ID Mobile_no

Data Type / Constraints Varchar Integer

16 10

Service_Provider_Name Mode Date Time Price

Varchar varchar Date Time Currency

10 10 ** ** 5

Size

Description User ID Customer Mobile Number Name of Service Provider Recharge Mode Date Time Amount of Recharge

4. DTH_MSTR Field Name R_ID C_ID Cable_Operator_Name Package Package_Price

Data Type / Constraints Size Varchar 16 Varchar 16 Password 16 Date ** Currency 3

Description User ID Customer ID Name Of Cable Operator Type of Package Amount of package


5. Dealer_MSTR Field Name Data Type / Constraints Size Description D_ID Varchar 16 User ID N am e Varchar 25 Name of Dealer Address Varchar 25 Address of Dealer State Varchar 16 Name of State Date_of_Membership Date ** Date and time

6. Locator Field Na Name R_ID Firm_Name Address City Zip_Code Contactact

Data Ty Type / Cons nsttraint ntss Size Description Varchar 16 User ID Varchar 25 Name of Firm Varchar 25 Address of Dealer Varchar 16 Name of City Integer 6 Postal Code Integer 12 Contact Number

7. Complaint Field Name R_ID Cmplnt_ID Date Cmplnt_Dec

Data Type / Constraints Size Description Varchar 16 User ID Integer 10 Complaint ID Date ** Date and time Varchar 100 Description of Complaint

8. Feedback Field Name Data Type / Constraints Size Description F_ID Varchar 16 User ID N am e Varchar 25 Name of Firm E_Mail Varchar 25 E-mail ID Date_of_Membership Date ** Date and Time Fb_Text Varchar 100 Description of Feedback


9. Service_Provider_Details Service_Provider_Details Fie ielld Nam Namee SP_ID SP_Name Acc_No Amount Date

Data Ty Dat Type / Con onsstraints Size Description Varchar 16 Service Provider ID Varchar 25 Name of Dealer Integer 16 Account Number Currency 7 Amount To Be Given Date ** Date and time

Database Tables(Retailer Side) 1. Limit_Log Field Name Data Type / Constraints Size Description R_ID Varchar 16 User ID N am e Varchar 25 Name of Dealer Amount Currency 7 Amount of Recharge Date_of_Membership Date ** Date and time

2. Mobile_Log Fie ielld Nam Namee Mobile_No SP_Name N am e Mode Date Price

Data Ty Dat Type / Con onsstraints Size Description Integer 10 Mobile number Varchar 25 Name of Service Provider Varchar 25 Name of Customer Varchar 10 Mode of Recharge Date ** Date and time Currency 5 Amount of Recharge

3. DTH_Log Field Name C_ID C_Name Package Package_Price Date

Data Type / Constraint ntss Size Integer 16 Varchar 25 Varchar 25 Currency 3 Date **

Description Customer ID Name of Dealer Type of Package Amount of Package Date and time


3.4 Input/Output Form


Input / Output Forms

1. User Login form (User may be Dealer or Retailer)

Figure 1


2. Registration Form ( Dealer )

Figure 2


3. Registration Form ( Reailer )

Figure 3


4. Recharge Form ( Mobile & DTH )

Figure 4

Figure 5


5. Feedback Form

Figure 6


6. Complaint Form

Figure 7


4. Conclusion


4. 1.

Advantages:

This system has following advantages:1) Retailers Retailers don’t don’t have to contain contain different different type of recharge recharge RCVs. RCVs. 2)

Reta Retail iler erss don’ don’tt have have to get get vari variou ouss mobi mobile le conn connec ecti tion onss of different mobile companies and respectively have to maintain different handsets.

3) Reta Retail iler erss don’ don’tt have have to credi creditt his his acco accoun untt as prep prepai aid d serv servic icee irrespective to the fact that he/she may or may not sell it to the customers, because it is not in its control. 4) Customer Customer does not not need to have have any bank accoun accountt for recharging recharging in reference of online banking, he just have to go retail shop and say for recharge. 5) Compl omplaaint int and and feed feedba bacck syst system em is inc incorp orporate rated d wit with the the proposed system which will help to improve system in future and maintenance purpose.

4. 2.

Limitations;

This system has some limitations that are as follows: 1) Retailers Retailers can buy buy their their recharge recharge limit from from the R.A. only. only. 2) Retail Retailer er cannot cannot recharg rechargee the custome customer’s r’s account account more than his limit. 3) Retailer has to buy their limit within 10 days after the previous

limit complete or the validity period is over. 4) Retailer Retailer cannot cannot transfer his account account without without R.A. permissio permissions. ns. 5) Service Service providers providers get get their amount amount after after each each 7 days. days.


4. 3.

Future Expansions:

This system may expand according to required facilities: 1) This system will be provides on Mobile Phone also.

2) The facilit facility y of landlin landlinee or postpa postpaid id bill payment payment will will also also be includes. 3) The The facil facilit ity y like like onli online ne tick ticket et book bookin ing g of Bus, Bus, Trai Train n and and Airlines will be includes with this system. 4) Online Online guide guide facilit facility y before before journey journey.. 5) Financial facilities like PO Subscription, Insurance Premiums.


5. Bibliography Bibliography


Bibliography: Abraha ham m 1) Abra

Silb Silber ersc scha hatz tz,, Henr Henry y F. Kort Korth, h, S. Suda Sudars rsha han, n, “Database System Concepts”. 2) Ivan Bayross “SQL, PL/SQL The Programming Language of ORACLE”. 3) Elias M. Awad “System Analysis and Design”.

SAD PRoject Report

Recommend Documents