Table 1234567890
Table 1234567890
Table 1234567890
INTERNSHIP REPORT
A report submitted in partial fulfillment of the requirements for the Award of Degree of
BACHELOR OF TECHNOLOGY
in
COMPUTER SCIENCE AND ENGINEERING
by
K.SIREESHA
Regd. No.: 14A51A0565
Under Supervision of
Mr. Srinivas, HR
NanoMindz Technologies pvt.Ltd, Vishakapatanam.
(Duration: 8th May, 2017 to 7th June, 2017)
i
[ Harshit Kikani ] [211290107022]
CERTIFICATE
This is to certify that the “Internship report” submitted by K.SIREESHA(Regd. No.: 14A51A0565)
is work done by her and submitted during 2017 – 2018 academic year, in partial fulfillment of the
requirements for the award of the degree of BACHELOR OF TECHNOLOGY in COMPUTER
SCIENCE AND ENGINEERING, at NanoMindz Technologies pvt.Ltd, Vishakapatanam.
Dr.G.S.N.Murthy
M. Tech.,Ph.D.
Head of the Department
Department of CSE
ii
[ Harshit Kikani ] [211290107022]
iii
[ Harshit Kikani ] [211290107022]
ACKNOWLEDGEMENT
I also would like all the people that worked along with me NANOMINDZ,
Vishakapatanam with their patience and openness they created an enjoyable working
environment.
It is indeed with a great sense of pleasure and immense sense of gratitude that I
acknowledge the help of these individuals.
I would like to thank my Head of the Department Dr. G.S.N.Murthy for his
constructive criticism throughout my internship.
I am extremely great full to my department staff members and friends who helped
me in successful completion of this internship.
K.SIREESHA
(14A51A0565)
iv
[ Harshit Kikani ] [211290107022]
ABSTRACT
Business intelligence (BI) systems depend on efficient integration of disparate and often
heterogeneous data. The integration of data is governed by data-intensive flows and is driven by a
set of information requirements. Designing such flows is in general a complex process, which due
to the complexity of business environments is hard to be done manually. In this paper, we deal
with the challenge of efficient design and maintenance of data-intensive flows and propose an
incremental approach, namely Co Al, for semi-automatically consolidating data-intensive flows
satisfying a given set of information requirements. Co Al works at the logical level and
consolidates data flows from either high-level information requirements or platform-specific
programs. As Co Al integrates a new data flow, it opts for maximal reuse of existing flows and
applies a customizable cost model tuned for minimizing the overall cost of a unified solution. We
demonstrate the efficiency and effectiveness of our approach through an experimental evaluation
using our implemented prototype.
Organisation Information:
This ground up approach helps us deliver not only the solution to our clients but also add value to
At the core NANO MINDZ operates in three specific domains namely Software Development,
Website Design& Development and Geographic Information Services. We also offer our services
in building E-Commerce solutions, Search Engine Optimization (SEO) and Database
Administration services. Under each division we further provide specific industry solutions on
focused domains with cutting edge technologies. We emphasize on building relationships with our
clients by delivering projects on time and within budget.
v
[ Harshit Kikani ] [211290107022]
Methodologies:
We follow a structured methodology for our projects which starts from designing the solution to
the implementation phase. Well planned Project reduces the time to deliver the project and any
additional ad-hoc costs to our clients, hence we dedicate majority of our time understanding our
clients business and gather requirements. This ground up approach helps us deliver not only the
solution to our clients but also add value to your investments.
Under each division we further provide specific industry solutions on focused domains with cutting
edge technologies.
Under each division we further provide specific industry solution on focused domains with cutting
edge technologies. We emphasize on building relationships with our clients by delivering projects
on time and within budget.
vi
[ Harshit Kikani ] [211290107022]
INDEX
1.1. Modules……………………………………………………………………….2
2. Analysis…………………………………………………………………………....3
4. Technology…………………………………………………………………………5
4.1. ASP.NET……………………………………………………………………….5
4.3. C#.NET………………………………………………………………………….7
4.4. JAVA…………………………………………………………………………….7
5. Coding……………………………………………………………………………….10
6. Screenshots...................................................................................................................11
7. Conclusion…………………………………………………………………………….16
8. Bibilography…………………………………………………………………………..17
vii
[ Harshit Kikani ] [211290107022]
➢ Internships are generally thought of to be reserved for college students looking to gain
experience in a particular field. However, a wide array of people can benefit from Training
Internships in order to receive real world experience and develop their skills.
➢ An objective for this position should emphasize the skills you already possess in the area
and your interest in learning more
➢ Some internship is used to allow individuals to perform scientific research while others are
specifically designed to allow people to gain first-hand experience working.
➢ Utilizing internships is a great way to build your resume and develop skills that can be
emphasized in your resume for future jobs. When you are applying for a Training
Internship, make sure to highlight any special skills or talents that can make you stand apart
from the rest of the applicants so that you have an improved chance of landing the position.
viii
[ Harshit Kikani ] [211290107022]
ix
[ Harshit Kikani ] [211290107022]
x
[ Harshit Kikani ] [211290107022]
1. INTRODUCTION
The complexity of business environments constantly grows, both with regard to the amount of
data relevant for making strategic decisions and the complexity of included business processes.
Today’s dynamic and competitive markets often imply rapid (e.g., near real-time) and accurate
decision making. Relevant data are stored across a variety of data repositories, possibly using
different data models and formats, and potentially crossed with numerous external sources for
various context aware analysis. A data integration process combines data residing on different
sources and provides unified view of this data for a user [1]. For example, in a data warehousing
(DW) context, data integration is implemented through extract-transform- that extracts,
cleans, and transforms data from multiple, often heterogeneous data sources and Finally,
delivers data for further analysis. There are various challenges related to data Flow design.
Here we consider two: design evolution and design complexity.
In an enterprise environment data is usually shared among users with varying technical skills
and needs, involved in different parts of a business process. Typical real-world data-intensive
workloads have high temporal locality, having 80% of data reused in a range from minutes to
hours. However, the cost of accessing these data, especially in distributed scenarios, is often
high. At the same time, intertwined business processes may also imply overlapping of data
processing. For instance, a sales department may analyze the revenue of the sales for the past
year, while Finance may be interested in the overall net profit. Computing the net profit can
largely benefit from the total revenue already computed for the sales department and thus, it
could benefit from the sales data Flow too. The concept of reusing partial results is not new.
Software and data reuse scenarios in data integration have been proposed in the past, showing
that such reuse would result in substantial cost savings, especially for large, complex business
environments. Data Flow re use could result in a significant reduce in design complexity, but
also in intermediate Flow executions and thus, in total execution time too.
1.1Module Description:
Shopper:
======
1
[ Harshit Kikani ] [211290107022]
Supplier
=======
1) send product details
2) send payment verification
3) Store buying detail
4) Store line items using join product and order
Order
=============
1) Store all the user details.
2) Order detail
2. SYSTEM ANALYSIS
2
[ Harshit Kikani ] [211290107022]
System:
3
[ Harshit Kikani ] [211290107022]
The software requirement specification can produce at the culmination of the analysis task.
The function and performance allocated to software as part of system engineering are refined
by established a complete information description, a detailed functional description, a
representation of system behavior, and indication of performance and design constrain,
appropriate validate criteria, and other information pertinent to requirements.
Software Requirements:
Hardware Requirement:
4
[ Harshit Kikani ] [211290107022]
4. TECHNOLOGY
4.1 ASP.NET
ASP.NET works on top of the HTTP protocol, and uses the HTTP commands and
policies to set a browser-to-server bilateral communication and cooperation.
ASP.NET web forms extend the event-driven model of interaction to the web
applications. The browser submits a web form to the web server and the server returns a full
markup page or HTML page in response.
All client side user activities are forwarded to the server for tasteful processing.
The server processes the output of the client actions and triggers the reactions.
Now, HTTP is a stateless protocol. ASP.NET framework helps in storing the information
regarding the state of the application, which consists of:
• Page state
• Session state
The page state is the client state, i.e., the content of various input fields in the web
form. The session state is the collective information obtained from various pages the user
visited and worked with, i.e., the overall session state. To clear the concept, let us take an
example of a shopping cart.
5
[ Harshit Kikani ] [211290107022]
User adds items to a shopping cart. Items are selected from a page, say the items
page, and the total collected items and price are shown on a different page, say the cart page.
Only HTTP cannot keep track of all the information coming from various pages. ASP.NET
session state and server side infrastructure keeps track of the information collected globally
over a session.
The ASP.NET runtime carries the page state to and from the server across page
requests while generating ASP.NET runtime codes, and incorporates the state of the server side
components in hidden fields.
This way, the server becomes aware of the overall application state and operates
in a two-tiered connected way.
ASP.NET is a technology, which works on the .NET framework that contains all
web-related functionalities. The .Net frame work is made of an object-oriented hierarchy. An
ASP.NET web applications is made of pages. When a user requests an ASP.NET page, the IIS
delegates the processing of the page to the ASP.NET runtime system.
The ASP.NET runtime transforms the .aspx page into an instance of a class, which
inherits from the base class page of the .Net framework. Therefore, each ASP.NET page is an
object and all its components i.e., the server-side controls are also objects.
4.2 ADO.NET
As you develop applications using ADO.NET, you will have different requirements
for working with data. In some cases, you might simply want to display data on a form. In other
cases, you might need to device a way to share information with another company.
No matter what you do with data, there are certain fundamental concepts that you
should understand about the data approach in ADO.NET. You might never need to know some
of the details of data handling- for example, you might never need to directly edit an XML file
containing data- but it is very useful to understand the data architecture in ADO.NET, what the
major data components are, and how the pieces fit together.
This introduction presents a high-level over view of these most important concepts.
The topic deliberately skips over many details- for example, there is much more to data sets
than what is mentioned here- in favour of simply introducing you to ideas behind the data
integration in ADO.NET.
6
[ Harshit Kikani ] [211290107022]
A model based on always connected data can make a difficult and impractical to
exchange data across application and organizational boundaries using a connected
architecture. If two components need to share the same data, both have to be connected, and a
way must be devised for the components to pass data back and forth.
For all the reasons, data accessed with ADO.NET is designed around an architecture
that uses connections sparingly. Applications are connected to the database only long enough
to fetch or update the data. Because the database is not holding onto connections that are largely
idle, it can service many more users.
➢ C# is a simple, modern, object oriented, and type –safe programming language derived from
C and C++.
• It will immediately be familiar to C and C++ programmers.
• C# aims to combine the high productivity of visual basic and the raw power of C++
➢ Visual C#.NET is Microsoft’s C# development tool.
➢ It includes an interactive development environment, visual designers for building windows and
web applications, a compiler and a debugger.
➢ Visual C#.NET is part of a suite of products, called Visual Studio .NET, that also includes
Visual Basics .NET, Visual C++.NET and the Jscript scripting language.
➢ The .NET frame work defines a “Common Language Specification” (CLS), a short of lingua
franca that ensures seamless interoperability between CLS-complaint languages and class
libraries.
➢ For C# developers this means even though C# is a new language, it has complete access to
the same rich class libraries that are used by seasoned tools such as Visual Basic.NET and
Visual C++.NET.
4.4 JAVA
JavaScript is an interpreter, client-side, event-based, object oriented scripting language that you
can use to add dynamic interactivity to your web pages.
JavaScript scripts are written in plain text, like HTML, XML, Java, PHP and just about any
other modern computer code. In this code, we will use Windows Note Pad to create and edit
our JavaScript code, but there are a large number of alternatives available.
7
[ Harshit Kikani ] [211290107022]
• Create special effects with images that give the impression that a button is either highlighted
or depressed whenever the mouse pointer is hovered over it.
• Validate information that users enter into your web forms
• Open pages in new windows, and customise the appearance of those new windows.
• Detect the capabilities of the user’s browser and alter your page’s content appropriately.
• Create custom pages “on the fly” without the need for a server-side language like PHP.
JavaScript is not Java, though if you come from a Java background, you will notice that both
languages look similar when written. Java is a full featured and comprehensive programming
language similar to C or C++, and although JavaScript can interact with Java web applications,
the two should not be confused.
Different web browsers will run your JavaScript in different, sometimes incompatible ways.
In order to work around this, it is often necessary to use JavaScript itself to detect the
capabilities of the browser in which it finds itself, and alter its operation depending on the
result.
To revisit the original definition in this chapter, note the following points:
• Interpreted refers to the fact that JavaScript code is executed (acted on) as it is loaded into the
browser. This is a change of pace from compiled languages like Java, which check your
program thoroughly before running a single line of code, and can have many implications that
can catch you out if you are from a non-interpreted programming background.
• Client-side has been defined already in the previous chapter.
• Event-based refers to JavaScript’s ability to run certain bits of code only when a specified
event occurs. An event could be the page being loaded, a form being submitted, a link being
clicked, or an image being pointed at by a mouse pointer.
• Object-oriented signals that JavaScript’s power to exert control over an HTML page is based
on manipulating objects within that page.
• If you are familiar with object-oriented programming, you will be aware of some of the power
that this can bring to the coding environment.
4.5 DATABASE
8
[ Harshit Kikani ] [211290107022]
Relational Database
There are different ways to organize data in a database but relational databases are
one of the most effective. Relational database systems are an application of mathematical set
theory to the problem of effectively organizing data. In a relational database is collected into
tables called relations in relation theory.
When organizing data into tables, you can usually find many different ways to define
tables. Relational database theory defines a process, normalization, which ensures that the set
of tables you define will organize our data effectively.
Client/Server
Examples of servers are: In Client/Server database architecture, the database files and DBMS
software resides on a server. A communications component is provided so applications can run
on separate clients and communicate to the database server over a network. The SQL server
communication component also allows communication between an application running on the
server and SQL server.
Server applications are usually capable of working with several clients at the same
time. SQL server can work with thousands of client applications simultaneously. The server
has features to prevent the logical problems that occur if a user.
9
[ Harshit Kikani ] [211290107022]
To work with data in a database, you must use a set of commands and statements
(language) defined by the DBMS software. There are several different languages that can be
used with relational database; the most common is SQL. Both the American national standards
institute (ANSI) and the International Standards Organization (ISO) has defined standards for
SQL.
5. CODING
Registration Form
10
[ Harshit Kikani ] [211290107022]
Mobile</td>
<td>
<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Gender</td>
<td>
<asp:RadioButtonList ID="RadioButtonList1" runat="server"
RepeatDirection="Horizontal">
<asp:ListItem>Male</asp:ListItem>
<asp:ListItem>Female</asp:ListItem>
</asp:RadioButtonList>
</td>
</tr>
<tr>
<td>
UserId</td>
<td>
<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Password</td>
<td>
<asp:TextBox ID="TextBox5" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label1" runat="server" style="font-weight: 700"></asp:Label>
</td>
<td>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click"
Text="Register" />
</td>
</tr>
</table><br /><br /><br />
</asp:Content>
11
[ Harshit Kikani ] [211290107022]
MasterPage
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<asp:ContentPlaceHolder id="head" runat="server">
</asp:ContentPlaceHolder>
<style type="text/css">
.style1
{
width: 100%; border:
1px solid #0000FF;
background-color: #FFFFFF;
}
</style>
</head>
<body bgcolor="skyblue">
<form id="form1" runat="server">
<table class="style1">
<tr>
<td>
<asp:Image ID="Image1" runat="server" Height="312px" Width="883px" />
</td>
12
[ Harshit Kikani ] [211290107022]
</tr>
<tr>
<td>
<asp:Menu ID="Menu1" runat="server" Orientation="Horizontal"
style="font-weight: 700">
<DynamicMenuStyle HorizontalPadding="60px" VerticalPadding="50px"
Width="1000px" />
<Items>
<asp:MenuItem Text="Home" Value="Home"
NavigateUrl="~/Admin/home.aspx"></asp:MenuItem>
<asp:MenuItem Text="Add Products" Value="About Us"
NavigateUrl="~/Admin/products.aspx"></asp:MenuItem>
<asp:MenuItem Text="View Users" Value="Login"
NavigateUrl="~/Admin/viewusers.aspx"></asp:MenuItem>
<asp:MenuItem Text="View Reports" Value="Contact Us"
NavigateUrl="~/Admin/reports.aspx"></asp:MenuItem>
<asp:MenuItem Text="View Orders" Value="View Orders"
NavigateUrl="~/Admin/vieworders.aspx"></asp:MenuItem>
<asp:MenuItem NavigateUrl="~/Default.aspx" Text="Logout"
Value="Logout">
</asp:MenuItem>
</Items>
<StaticMenuItemStyle Width="100px" />
<StaticMenuStyle HorizontalPadding="60px" Width="800px" />
</asp:Menu>
</td>
</tr>
<tr>
<td style="margin-left: 80px">
<asp:ContentPlaceHolder ID="ContentPlaceHolder1" runat="server">
</asp:ContentPlaceHolder>
</td>
</tr>
<tr>
<td style="text-align: center; margin-left: 80px">
<strong>Copy Rights reserved</strong></td>
</tr>
</table>
</form>
</body>
</html>
13
[ Harshit Kikani ] [211290107022]
6. SCREENSHOTS
Home page:
14
[ Harshit Kikani ] [211290107022]
Registration page:
15
[ Harshit Kikani ] [211290107022]
Login Page:
16
[ Harshit Kikani ] [211290107022]
7. CONCLUSION
8. BIBLOGRAPHY
The following books are referred during the analysis and execution phase of the project
1. M. Lenzerini, “Data integration: A theoretical perspective,” in PODS, 2002, pp. 233– 246.
17
[ Harshit Kikani ] [211290107022]
4. Y. Chen, S. Alspaugh, and R. Katz, “Interactive analytical processing in big data systems:
A cross-industry study of map reduce workloads,” Proceedings of the VLDB Endowment, vol.
5, no. 12, pp. 1802–1813, 2012.
WEBLINKS:
18