MSC - It Project Sample
MSC - It Project Sample
……………….
ENROLLMENT NO.:……………………..
UNDER GUIDANCE OF
AKHILA S. HUNGUND
ACKNOWLEDGEMENT
With Candor and Pleasure I take opportunity to express my sincere thanks and obligation
guidance and co-operation without which it would not have been possible for me to
complete my project.
It is my pleasant duty to thank all the staff member of the computer center who never
and as always, nothing in my life would be possible without God, Thank You!
DECLARATION
I hereby declare that this project work titled “SUMSUNG MOBILE SERVICE
submitted for any other degree purpose or published in any other from till date.
TABLE OF CONTENT
Declaration 4
1.1 Introduction 8
1.3 Advantage 13
1.6 Need 16
2. System Study
3. System Analysis
4. System Design
4.5 Modules 57
4.7 Scheduling 62
5. System Development
6. Testing
7. System Implementation
*****************
1.1 INTRODUCTION
Simply after filling the Mobile repair estimate form service center will send the
customers estimate. If the customer accepts the estimate service center will start
repairing the Mobile. Samsung mobile repairing engineers are experienced in
troubleshooting and fixing the most challenging problems. Moreover, if a
customer has faulty or broken mobile sitting around not being used, Samsung
Service center will buy it from the customer at a fair price. Users have to click
Sell your Mobile and provide service center with some information about the
mobile. Samsung Mobile Service Center will respond shortly with an offer. I am
confident that this software package can be readily used by non-programming
personal avoiding human handled chance of error. This project is used by two
types of users
i. Online Users.
ii. Administrator (management of the company).
Online users can check their service details, service center details, repair estimate
etc. Administrator can maintain daily updates in the records. Administrator is
must be an authorized user. He can further change the password. There is the
facility for password recovery, logout etc.
Management System.
ii. This Website is useful for the users who are interested in Mobile
yourself.
• Users can further get the information of the Showrooms and Service
centers.
pictures.
• Report Generation
the company.
Proposed System
1.3 ADVANTAGE
I have designed the given proposed system in the ASP and SQL SERVER to
Efficiency: The basic need of this website is efficiency. The website should be
efficient so that whenever a new user submits his/her details the website is
updated automatically. This record will be useful for other users instantly.
Control: The complete control of the project is under the hands of authorized
person who has the password to access this project and illegal access is not
supposed to deal with. All the control is under the administrator and the other
members have the rights to just see the records not to change any transaction or
entry.
Security: Security is the main criteria for the proposed system. Since illegal access
may corrupt the database. So security has to be given in this project.
- 10 Baluja Labs
-
Baluja Labs
• The current manual system has a lot of paper work and it does not deal
job.
• With the increase in database, it will become a massive job to maintain the
database.
• Requires large quantities of file cabinets, which are huge and require quite
a bit of space in the office, which can be used for storing records of
previous records.
tedious job.
• Lack of security for the records, anyone disarrange the records of your
system.
- 11 Baluja Labs
-
Baluja Labs
- 12 Baluja Labs
-
Baluja Labs
8. This should always be observed during the development of the software that
the user is not from technical background, so the software should be user friendly
and can be handled easily.
10. The data retrieval and other manipulation related task which is done at the
database level should be fast enough. The database should support multiple
users at a time.
- 13 Baluja Labs
-
Baluja Labs
1.6 NEED
I have designed the given proposed system in the ASP.NET to automate the
process of Sumsung Mobile Service Centre Management System. This project is
useful for the authorities who keep track of all the Sumsung Mobile Service
Centre Management System.
The following steps that give the detailed information of the need of proposed
system are:
• Performance: During past several decades, the records are supposed to be
manually handled for all activities. The manual handling of the record is time
consuming and highly prone to error. To improve the performance of the
system, the computerized system is to be undertaken. The computerized
project is fully computerized and user friendly even that any of the members
can see the report and status of their enquiries.
• Efficiency: The basic need of this website is efficiency. The website should be
efficient so that whenever a new user submits his/her details the website is
updated automatically. This record will be useful for other users instantly.
• Control: The complete control of the project is under the hands of authorized
person who has the password to access this project and illegal access is not
supposed to deal with. All the control is under the administrator and the
other members have the rights to just see the records not to change any
transaction or entry.
• Security: Security is the main criteria for the proposed system. Since illegal
access may corrupt the database. So security has to be given in this project.
- 14 Baluja Labs
-
Baluja Labs
FRONT END
In the business world, competitive strategies have become the order of the day to
improve quality, cut costs and provide a high response customer service base.
Most organizations today need to be market driven and do a lot of value addition
to their products and services. This naturally calls for rational decision making,
which requires information. Information Technology or IT provides that effective
channel to support and implement this strategy. Client/Server is the technology
that empowers the desktop, thus setting a trend for the way successful
organizations will use technology in the next decade.
- 15 Baluja Labs
-
Baluja Labs
What is .NET?
• A vision of how information technology will evolve
• A platform that supports the vision
• A business model of software as a service
1. A Vision.
• Web sites will be joined by Web services
• New smart devices will join the PC
• User interfaces will become more adaptable and customizable
• Enabled by Web standards
2. A Platform.
• The .NET Framework
• ASP.NET
• .NET Enterprise Servers
o Database, Messaging, Integration, Commerce, Proxy, Security,
Mobility, Content Management
• .NET Building Block Services
o Passport
o .NET My Services (“Appin”)
• Goal: make it incredibility easy to build powerful Web applications and
Web services
3. A business model.
• Software as a service
• Subscription-based services
• Application hosting, e.g. bCentral
- 16 Baluja Labs
-
Baluja Labs
Web Services
• A programmable application component accessible via standard Web
protocols
• The center of the .NET architecture
• Exposes functionality over the Web
• Built on existing and emerging standards are HTTP, XML, SOAP, UDDI,
WSDL, …
- 17 Baluja Labs
-
Baluja Labs
• The introduction of the Internet and its rapid growth in the recent past has
led to the development of a number of new Technologies.
• One of the most important requirements of such applications is the ability
to interchange information across platforms and to benefit from the
functionality provided by other applications.
- 18 Baluja Labs
-
Baluja Labs
- 19 Baluja Labs
-
Baluja Labs
- 20 Baluja Labs
-
Baluja Labs
ADO.NET
• Is a model used by Visual Basic .NET applications to communicate with a
database for retrieving, accessing, and updating data?
• Uses a structured process flow to interact with a database.
Evolution of ADO.NET
The first data access model, DAO (data access model) was created for local
databases with the built-in Jet engine which had performance and functionality
issues. Next came RDO (Remote Data Object) and ADO (Active Data Object)
which were designed for Client Server architectures but soon ADO took over
RDO. ADO was a good architecture but as the language changes so is the
technology within it. With ADO, all the data is contained in a record set object
which had problems when implemented on the network (Internet) and
penetrating firewalls. ADO was a connected data access which means that when
a connection to the database is established the connection remains open until the
application is closed, which raises concerns about database security and network
traffic. And also as databases are becoming increasingly important and as they
are serving more people a connected data access model makes us think about its
use. For example, an application with connected data access may do well when
connected to two clients, the same may do poorly when connected to 10 and
might be unusable when connected to 100 or more. Also, open database
- 21 Baluja Labs
-
Baluja Labs
Why ADO.NET?
To cope up with some of the problems mentioned above, ADO.NET came into
existence. ADO.NET addresses the above mentioned problems by maintaining a
disconnected database access model which means that when an application
interacts with the database the connection is opened to serve the request of the
application and is closed as soon as the request is completed. Likewise if a
database is updated, the connection is opened long enough to complete the
Update operation and is closed. By keeping connections open for only a
minimum period of time ADO.NET conserves system resources and provides
maximum security for databases and also has less impact on system
performance. Also, ADO.NET when interacting with database uses XML by
converting all the data into XML and using it for database related operations
making them more efficient.
Features of ADO.NET
- 22 Baluja Labs
-
Baluja Labs
• Data Provider
o Is used for connecting to a database, retrieving data, and storing the
data.
• Is of two types:
o OLE DB data provider
o SQL Server data provider
• Data command
o Is a SQL statement or a stored procedure that is used to retrieve,
insert, delete, or modify data from a data source.
o Is an object of the OleDbCommand or SQLCommand class.
- 23 Baluja Labs
-
Baluja Labs
• Data reader
o Is used to retrieve data from a data source in a read-only and
forward-only mode.
o Stores a single row at a time in the memory.
o Commonly used methods:
Read()
Close()
NextResult()
• Dataset
o Is a disconnected, cached set of records that are retrieved from a
database?
o Is present as a DataSet class in the System.Data namespace.
o Has its own object model.
- 24 Baluja Labs
-
Baluja Labs
- 25 Baluja Labs
-
Baluja Labs
- 26 Baluja Labs
-
Baluja Labs
A system analysis is a separation of a substance into parts for study and their
implementation and detailed examination.
Before designing any system it is important that the nature of the business and
the way it llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll
What are the potential problems that may make the task more
difficult?
- 27 Baluja Labs
-
Baluja Labs
- 28 Baluja Labs
-
Baluja Labs
There are several attributes in which the computer based information works.
Broadly the working of computer system is divided into two main groups:
♦ Transaction System
♦ Decision Support System
l
• Topic Understanding.
• Modular Break – Up of the System.
• Processor Logic for Each Module.
• Database Requirements.
Topic Understanding:
It is vital that the field of application as introduced in the project may be totally a
new field. So as soon as the project was allocated to me, I carefully went through
the project to identify the requirements of the project.
- 29 Baluja Labs
-
Baluja Labs
- 30 Baluja Labs
-
Baluja Labs
The design document that we will develop during this phase is the blueprint of
the software. It describes how the solution to the customer problem is to be built.
Since solution to complex problems isn’t usually found in the first try, iterations
are most likely required. This is true for software design as well. For this reason,
any
in the real world. That is, the structure of the software design should (whenever
possible) mimic the structure of the problem domain.
The design activity begins when the requirements document for the software to
be developed is available. This may be the SRS for the complete system, as is the
case if the waterfall model is being followed or the requirements for the next
"iteration" if the iterative enhancement is being followed or the requirements for
the prototype if the prototyping is being followed. While the requirements
specification activity is entirely in the problem domain, design is the first step in
moving from the problem domain toward the solution domain. Design is
essentially the bridge between requirements specification and the final solution
for satisfying the requirements.
The design of a system is essentially a blueprint or a plan for a solution for the
system. We consider a system to be a set of components with clearly defined
behavior that interacts with each other in a fixed defined manner to produce
some behavior or services for its environment. A component of a system can be
considered a system, with its own components. In a software system, a
- 31 Baluja Labs
-
Baluja Labs
Data modeling defines primary data objects, composition of each data object,
and attributes of the object, relationships between each object and other
objects and between objects and the processes.
List of Tables:
Entity Users
Description: To store login details of the online users.
Entity : Feedback
Decription: To store feedback details.
- 32 Baluja Labs
-
Baluja Labs
Cardinality:
The data model must be capable of representing the number of occurrences of
objects in a given relationship. The cardinality of an object relationship pair is
Modality:
- 33 Baluja Labs
-
Baluja Labs
The object relationship pair can be represented graphically using the Entity
Relationship Diagrams. A set of primary components are identified for the Entity
Relationship Diagram,
1. Attributes,
2. Relationships and
3. Various Type Indicators.
The primary purpose of the Entity Relationship Diagram is to represent data
objects and their relationships.
Searching
In this module, whenever an existing entity is required to be searched the
corresponding forms are opened and the database is manipulated and the data is
fetched. Again, the checks are followed in case there is any invalid entry.
Servicing
- 34 Baluja Labs
-
Baluja Labs
In this module, servicing details of all the Mobiles is stored in the database. This
database will be uploaded so that, if a user or customer who wants to service a
Mobile can check his/her servicing details. There are some conditions and
durations for servicing. Suppose a customer has purchased a Mobile from any
showroom of SAMSUNG then he can get services from any authorized service
center of the SAMSUNG.
Showroom_details
In this module, detail of all the showrooms is stored in the database. This
database will be uploaded so that, if a user or a customer who wants to purchase
a Mobile can check about the Samsung Mobile showrooms.
Owners
In this module, detail of the owners of the Mobile is stored in the database. This
database will be uploaded so that, if a user or a customer who wants the services
from any authorized service centers can be tracked.
Repair Estimates
If a customer is interested in repair of their Mobile, he can fill a form and can get
the repair estimate from the service center.
Service Tips
In this module, service tips are provided to the customers so that they can save
their money.
Emails
In this module, Administrator can inform or remind all the customers whose
service is due; this will be checked automatically from the database.
Admin Panel
This module is useful for the administers as follows:
- 35 Baluja Labs
-
Baluja Labs
- 36 Baluja Labs
-
Baluja Labs
Reviewing of Code efficiency for a module is carried out after the module is
successfully compiled and all the syntax errors eliminated. Code efficiency
review is extremely cost-effective strategies for reduction in coding errors in
order to produce high quality code. Normally, two types of efficiency are carried
out on the code of a module - code optimization and code inspection. The
procedure and final objective of these two efficiency techniques are very different
as discussed below.
One of the purposes of the testing is to validate and verify the system.
Verification means checking the system to ensure that it is doing what the
function is supposed to do and Validation means checking to ensure that system
is doing what the user wants it to do.
- 37 Baluja Labs
-
Baluja Labs
limits. If we implement the system without proper testing then it might cause the
problems.
iques. This type of testing plays very important role in increasing the systems
productivity. We have checked our system by using the integration testing
techniques.
3. SYSTEM TESTING:
A part from testing the system to validate the functionality of
software against the requirements, it is also necessary to test the non-functional
aspect of the system. Some examples of non-functional tools include tests to
check performance, data security, usability/user friendliness, volume,
load/stress that we have used in our project to test the various modules.
1. Program(s) testing.
2. String testing.
3. System testing.
4. System documentation.
5. User acceptance testing.
Sumsung
Mobile Service
Tested By: Self Project Name Centre
Management
System
- 38 Baluja Labs
-
Baluja Labs
T.C RESUL
ACTUAL
ID T
1 Ok Pass
- 39 Baluja Labs
-
Baluja Labs
1 Ok Pass
2 Ok Pass
1 Ok Pass
2 Ok Pass
1 Ok Pass
2 Ok Pass
1 Ok Pass
2 Ok Pass
T.C RESUL
ACTUAL
ID T
- 40 Baluja Labs
-
Baluja Labs
1 Invalid Fail
1 Invalid Fail
1 Ok Fail
1 Ok Fail
TEST DATA
Specifications
for
Sumsungmrc.co
m add customer
details
Programmer
Test Date 27-4-2010 Pawan Kumar
name:
Administrative
Support System
Tested By: Pawan Kumar Project Name For Sumsung
Mobile Repairing
Centre
The major V&V activities for software development are inspection, reviews, and
testing (both static and dynamic). The V&V plan identifies the different V&V
tasks for the different phases and specifies how these tasks contribute to the
project V&V goals. The methods to be used for performing these V&V activities,
- 41 Baluja Labs
-
Baluja Labs
the responsibilities and milestones for each of these activities, inputs and outputs
for each V&V task, and criteria for evaluating the outputs are also specified.
The two major V&V approaches are testing and inspections. Testing is an activity
that can be generally performed only on code. It is an important activity and is
discussed in detail in a later chapter. Inspection is a more general activity that can
be applied to any work product, including code. Many of the V&V tasks are such
that for them, an inspection type of activity is
- 42 Baluja Labs
-