Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Get up to 1000 download points for every original document you upload!
Typology: Lecture notes
1 / 39
This page cannot be seen from the preview
Don't miss anything!
SUBMITTED IN PARTIAL FULFILLMENT OF THE REQUIREMENT FOR
Six Weeks Industrial Training
at
CS Infotech (From 5-June-2017 to 7-July-2017 )
SUBMITTED BY Naveen Rana Master of Computer Applications Univ. Roll No. - 1632189
Department of Computer Science
CS Soft Solution
TO WHOM IT MAY CONCERN (14 point)
I hereby certify that "NAME OF THE STUDENT" University Roll No………………………………….of Punjab College of Technical Education,Baddowal,Ludhiana has undergone four months Industrial training from…………………………to………………………
at ( Name of organization) to fulfill the requirements for the award of degree of Master of Computer Applications. He has worked on…………………………..project during the training under the supervision of………………………..During his/her tenure with us we found him/her sincere and hard working. Wishing him/her a great success in the future.
Signature of the Student
Signature of the SUPERVISOR (S)
Name of Student
Table of contents
s. no. topic page no.
(ii) Objectives of Project (^5) (iii) Working Environment (^) 6-
Company Profile
CS Group
CS Group founded by Mr. Chhotu Sharma is an amalgam of CS Soft Solutions Pvt. Ltd and
CS InfoTech. CS Soft Solutions is a complete IT solutions providing company with huge
clientele all over the world. CS InfoTech is a pioneer institution which is engaged in
providing computer education in software technologies, to students as well as professional
executives.
CS Soft Solutions Pvt. Ltd.
CS Soft Solutions is a complete IT solution providing company based in Mohali. CS Soft
Solutions was created to achieve the goal of providing its clients state-of-art web
development services comparable with best in the world.
The services provided by CS Soft Solutions Pvt. Ltd. Are
CS Soft Solutions Pvt. Ltd. was conceptualized in October 2009 by Mr. Chhotu Sharma and
Mrs. Shalini Sharma. The goal was to build a company that worked on solid principals, to
develop world class IT products and provide a congenial environment and adequately
encouraging work culture for all the team members at CS Soft Solutions Pvt. Ltd.
Consequently, there is a huge clientele from all across the world. For assistance please refer
to our website http://www.cssoftsolutions.com
One of the methods of paying back to the industry that has been adopted by the CS Group is
to recruit students from CS Infotech into CS Soft Solutions Pvt. Ltd. on the basis of their
performance and ability to perform in the industry.
Founders
▲ Facilitate education and training institutes in the non-formal sector.
▲ Develop a mechanism for dynamic revision of course curriculum and development of
the learning materials in the textbook, CD-ROM and web based form.
▲ Impart continuing education/refresher training and corporate training to engineering
graduates, working professionals and others.
▲ Develop and implement new schemes of courses in emerging areas as required by
industries and others.
▲ Undertake develop projects and provide services in IT and related.
Introduction
Project Title : RateMySkills
Project Duration : 6 Weeks
Project category : Web Based Application
The project named RateMySkills is developed using ASP.NET during the industrial training. This project has been developed in partial fulfilment of Requirements for the degree of B.TECH. (CSE), from I.E.T. Bhaddal Ropar.
Online skill assessment is an effective method of ensuring you have the skills needed for your job. RateMySkills’s online testing tool creates valid tests for various skills. Save your time and money, and reduce the possibility of interview failure by giving a pre-hiring skill assessment directly over the Web. No software other than a browser is needed. RateMySkills assures a reliable service, ease-of-use.
Statement about the Problem-existing system
Experts agree that the most valuable asset and only true competitive advantage of any organization are the people on its team. Having the right people in the right jobs can make the difference between industry leadership and mediocrity, between loyal customers and shrinking market share, and between project success and failure. That's why RateMySkills is dedicated to helping organizations use assessment science to predict employee success. Using the RateMySkills assessment platform, companies improve hiring and retention, boost training success, enhance customer satisfaction, and increase profitability.
When you go to a new restaurant and have a good experience, it's likely that you won't keep the place a secret. Many of us, particularly city dwellers, are naturally curious about what's new, popular or just plain good around town, and sharing with others is one of the easier and more reliable ways of establishing the best locations. The same goes for many other types of businesses or services -- drivers often recommend a good mechanic to people looking for affordable, honest work on a car. But it can work the opposite way, too. If you go to a restaurant and have a terrible time -- maybe the food is unappetizing, or the service is poor -- you want to warn others about it. Businesses live and die by this kind of communication, and now the Internet has made it even easier for word to spread quickly about the quality of all kinds of services. Social networking site that focuses on reviewing businesses and sharing information about them is Business Circle. Web site is like a large online bulletin board featuring user-generated content, all geared toward personal reviews based on experiences at local businesses.
This project is divided into four parts which correspond to the four layers of the logical architecture of the project. The users of the project interact with Presentation Layer. The Business Logic Layer(BLL) provides the internal computation of the requirements. The Data Access Layer (DAL) is the intermediate layer which communicates with the DATABASE.
These layers are as follows:-
Hardware Environment (End user’s PC) PC PC (Windows) Processor Intel I3 Processer RAM 4 GB HDD 30 GB of free HDD space for Internet Cache Internet Connection 225 K Modem Connection
Hardware Environment (Deployment Server) PC PC (Windows) Processor Intel I3 Processer RAM 4 GB RAM DD 160 GB
Software Environment (Deployment Server) Operating System MS Windows Server 2008 Other software MS SQL Server 2012 R2, Internet Information Server services (IIS 10 or higher), Dot Net Framework
ASP.NET is a platform that provides one-stop shopping for all application development that requires the processing of HTTP requests.
ASP.NET is a compiled, .NET-based environment; you can author applications in any .NET compatible language, including Visual Basic .NET, C#, and JScript .NET. Additionally, the entire .NET Framework is available to any ASP.NET application. Developers can easily access the benefits of these technologies, which include the managed common language runtime environment, type safety, inheritance, and so on.
ASP.NET is a web application framework developed and marketed by Microsoft to allow programmers to build dynamic web sites, web applications and web services. It was first released in January 2002 with version 1.0 of the .NET Framework, and is the successor to Microsoft's Active Server Pages (ASP) technology. ASP.NET is built on the Common Language Runtime (CLR), allowing programmers to write ASP.NET code using any supported .NET language.
Because computer systems commonly require interaction between new and older applications, the .NET Framework provides means to access functionality that is implemented in programs that execute outside the .NET environment.
The Common Language Runtime (CLR) is the execution engine of the .NET Framework. All .NET programs execute under the supervision of the CLR, guaranteeing certain properties and behaviors in the areas of memory management, security, and exception handling.
The .NET Framework introduces a Common Type System, or CTS. The CTS specification defines all possible datatypes and programming constructs supported by the CLR and how they may or may not interact with each other conforming to the Common Language Infrastructure (CLI) specification. Because of this feature, the .NET Framework supports the exchange of types
and object instances between libraries and applications written using any conforming .NET language.
The Base Class Library (BCL), part of the Framework Class Library (FCL), is a library of functionality available to all languages using the .NET Framework. The BCL provides classes which encapsulate a number of common functions, including file reading and writing, graphic rendering, database interaction, XML document manipulation and so on.
The .NET Framework includes design features and tools that help manage the installation of computer software to ensure that it does not interfere with previously installed software, and that it conforms to security requirements.
The design is meant to address some of the vulnerabilities, such as buffer overflows, that have been exploited by malicious software. Additionally, .NET provides a common security model for all applications.
ASP.NET is a unified Web development model that includes the services
necessary for you to build enterprise-class Web applications with a minimum of
coding. ASP.NET is part of the .NET Framework, and when coding ASP.NET
applications you have access to classes in the .NET Framework. You can code
your applications in any language compatible with the common language
runtime (CLR), including Microsoft Visual Basic and C#. These languages
enable you to develop ASP.NET applications that benefit from the common
language runtime, type safety, inheritance, and so on.
Data processing has traditionally relied primarily on a connection-based, two- tier model. As data processing increasingly uses multi-tier architectures, programmers are switching to a disconnected approach to provide better scalability for their applications.
The two main components of ADO.NET 3.0 for accessing and manipulating data are the .NET Framework data providers and the Dataset.
ARCHITECTURE OF SQL SERVER 2012
Protocol layer implements the external interface to SQL Server. All operations that can be invoked on SQL Server are communicated to it via a Microsoft- defined format, called Tabular Data Stream (TDS). TDS is an application layer protocol, used to transfer data between a database server and a client. Initially designed and developed by Sybase Inc. for their Sybase SQL Server relational database engine in 1984, and later by Microsoft in Microsoft SQL Server, TDS packets can be encased in other physical transport dependent protocols, including TCP/IP, Named pipes, and Shared memory. Consequently, access to SQL Server is available over these protocols. In addition, the SQL Server API is also exposed over web services.
The main unit of data storage is a database, which is a collection of tables with typed columns. SQL Server supports different data types, including primary types such as Integer, Float, Decimal, Char (including character strings), Varchar (variable length character strings), binary (for unstructured blobs of data), Text (for textual data) among others. The rounding of floats to integers uses either Symmetric Arithmetic Rounding or Symmetric Round Down (Fix) depending on arguments: SELECT Round(2.5, 0) gives 3.
Microsoft SQL Server also allows user-defined composite types (UDTs) to be defined and used. It also makes server statistics available as virtual tables and views (called Dynamic Management Views or DMVs). In addition to tables, a database can also contain other objects including views, stored procedures,
indexes and constraints, along with a transaction log. A SQL Server database can contain a maximum of 231 objects, and can span multiple OS-level files with a maximum file size of 220 TB.The data in the database are stored in primary data files with an extension .mdf. Secondary data files, identified with a .ndf extension, are used to store optional metadata. Log files are identified with the .ldf extension.
For physical storage of a table, its rows are divided into a series of partitions (numbered 1 to n). The partition size is user defined; by default all rows are in a single partition. A table is split into multiple partitions in order to spread a database over a cluster. Rows in each partition are stored in either B-tree or heap structure. If the table has an associated index to allow fast retrieval of rows, the rows are stored in-order according to their index values, with a B-tree providing the index. The data is in the leaf node of the leaves, and other nodes storing the index values for the leaf data reachable from the respective nodes. If the index is non-clustered, the rows are not sorted according to the index keys. An indexed view has the same storage structure as an indexed table. A table without an index is stored in an unordered heap structure. Both heaps and B-trees can span multiple allocation units.
confidential, security is a key issue. Information falling into the wrong hands could jeopardize the entire organization. Unlike in semi-computerized systems The proposed system offers adequate control to organize our files online and share with the users and Security of data and information. This is handled by the system providing individuals with separate login names and passwords. The new system is user-friendlier, which enables the end-user to complete his/ her work efficiently and accurately with interest. After taking the above fact into consideration we can state the operating of the proposed system within the organization is feasible. In this phase of the feasibility study the following two main topics
Technical performance aspect is explained in the technical feasibility report and there is no new information is needed in this to explain it again, but as for the acceptance within the organization the following points are important and those are explained according to the topics.
Based on the outline design of the system requirements in terms of inputs, output, Procedures, the technical issues raised during technical feasibility include:
As the software is very much economically feasible, then it is really important for it to be technically sound. The software will be build among:
▲ Front-End : ASP.NET 5. ▲ Logic Development: ASP. NET ▲ Back-End: MS SQL SERVER 2012, C#
ECONOMICAL FEASIBILITY
In making recommendations a study of the economics of the proposed system should be made. Even though finding out the costs of the proposed project is difficult we assume and estimate the costs and benefits as follows. According to the computerized system we propose, the costs can be broken down in two categories.
1 Costs associated with the development of the system.
2 Costs associated with operating the system.
SYSTEM DESIGN
“System Analysis” describes what a system should do to meet the info needs of users while “System Design” specifies how the system will accomplish this objective. This is most creative and challenging phase of system life cycle. The term ‘design’ describes a final system and process by which it is developed. It refers to the technical specifications.
There are two methods for the system design stage in SDLC:
Both activities produce System Specifications satisfying the system
Logical System Design involves developing general specification for how the basic IS activities of input, processing, output, storage and can meet the end user requirements. At this stage, we start giving shape to our database which includes detail structure of various tables used to store information. Physical System Design involves the detailed design of user interface methods and products, database structures, processing & control procedures. Hardware (machine, media), software (program and procedures) & personnel specifications are also developed for purpose system. At this point of
