Self Reflection:
Basically I am belongs to the IT field but this task become very interesting for me because I am working in a group project.
The Mirror: firstly I fill it would become very easy task for me, because I have studied the SQL during my graduation. But I have never been to any company in my life to get information and implement that information in my application. It was really difficult for me to understand the requirements of the system. I was having the ideas about the EER, UML but I did not know how to implement it in real application, I have read the books and lectures slides and got information about the Normalization, EER, UML. Initially I felt that work distribution was the difficult part in the stage1.
The Microscope: after defining all the individual fields, it was became very important to make relationship between all the table, that means to defining the primary keys and the foreign keys. But it was the group work so our all tables must be connected with each other to share the data. So we were regularly meeting for this task and we help each other to make relationships among the tables. In the result we have create good schema of the tables. We have design EER, UML and 3rd normalization form. This all work was not possible without the group work.
The Binocular: after defining all the relationships among the tables, and after creating the EER diagrams, UML Diagrams up to 3rd normalization forms I have at least learnt from this task about the managing the data. How can we get the information from the organization, how can I initialize the attributes in the different table. How to draw the effective EER, UML diagrams to represent the entities and their relationships in better way. I have learnt so many things from the stage 1, which I can apply in the future to represent my work very efficiently.
Finally, I fill that I could make this web application more user friendly and I could add more functionalities in it but I have got little short time for this course work because of the other course work. But I have studied and tried to understand the concept and tried my level best to develop it.
UML diagrams
SALARY MASTER SALARY DETAILS SALARY PAYMENTS
BANK MASTER
LEAVE
BANK DETAILS
Self Assessment: Stag- 2
This is initially my second stage of the course work. In the first stage I have learnt how to distribute the individual work in the team, how I can be the active member of my team. I have got the idea about the EER and UML diagrams and the normalization. I have learnt how I can represent the data in good manner.
This is my second stage of the course work. I have all the idea about my previous work and I have to implement the concept to make the web application. I have used ASP.net web matrix to create my web application. I have used Microsoft Access in my back hand. I have learnt how can I create the web sites using the proper database management system.
In the beginning, I felt it is really hard and the complex task to me because I am very new with the web application and I have never work on such kind of web server script languages. But I have got good and clear concept from my professor Dr. Nawaz Khan and even he has given such knowledge of working with ASP.Net.
Finally, if I do self assessment of my self after finishing this course work, I can say I have got good enough knowledge of the web application. I have got good knowledge about how can I get the good future aspect in the IT company because I learn so many things which I can apply in the real field.
Self Reflection:
Basically I am belongs to the IT field but I am unaware with the web based application like ASP.Net, JAVA, and etc. so I was not having the clear concept in my mind how to even how to work on web based languages.
The Mirror: As I have mentioned above I was not having the clear concept about the web based application. So I have faced many difficulties I the beginning when I have started to work on the ASP.Net. From the my point of view I fill working with the database was easiest part for me because I have some concept of the database management systems. But I have good teaching and support from my professor.
The Microscope: I have used ASP.Net web matrix as a designing tool of my course work and Microsoft Access as my backhand. I have created a very simple design in my web application, to make my self more easier with the system. We all grope members have decided the individual system and we are sharing the same database with different design. One of the my group member Niraj Yadav(M00153727), has good experience and he helped me a lot in problem solving. I fill if I have tried to understand more then I was able to make my web application more interactive and more functionalize then current system.
The Binocular: I am really new to the web server scripting languages so in the beginning I have passed from the many difficulties in developing the web based system. But after getting good knowledge
of it and some of the research work I have made small web based application on my database. Most of the difficulties I face while I was getting the lots errors during the compilation. But slowly I got some knowledge about solving the errors. The task becomes little easies for me. In the such timing I have got ideas from the activities of the Lecture’s slides, book and even sometimes from the internet.
Finally, I fill that I could make this web application more user friendly and I could add more functionalities in it but I have got little short time for this course work because of the other course work and even I was having less knowledge of the web applications. But I have studied and tried to understand the concept and tried my level best to develop it.
Individual work narrative overview:
I have worked on the human resource management system. Thought, in this field the HR manager can be have many departments or many responsibilities. But I have taken some of this departments and its functionalities in my project. After gathering all the information from the company I have created the data base and applied relationship among them. So from this data I have created the EER diagrams and UML diagrams to make it simpler to understand. To start with the programming I must have the strong and appropriate backhand, so I can use and store data from it. I have created all the tables in the Microsoft Access. Our basic aim was that, we will have to share the same data base as a back hand which can make our work more reliable. So we have created only one database common in between all the group members. After that I have began with to creating the web application using the ASP.Net Web Matrix. Firstly I have created some basic page design or I can say paper work. Such design I have applied as design of my web pages.
Basically it was individual work, but we have taken it as a group work. So we are sharing the same data base. We were meeting twice in a week for this course work to share the ideas and to solve each others difficulties. I have created a such web pages in my course work which can be very easy to understand to any users. I have tried to understand more functionalities of the HR but I can apply some of it because of the less time I have got for this course work.
System Description:
Today in all the business applications that are been used in the real world need to store the some peace of the information in their database to analyse customer behavior and provide them better services. Such systems are really helpful in the big organization which has thousands of the employees or the customers such as bank or any multinational companies. So I have created this system to make my company to work in some effective way.
We have created the back hand tables in the Microsoft Access. We are sharing the same data base in the access. The image shows the basic tables layouts in the Microsoft access with the table names and owner names.
This is a web based system and I have used ASP.Net as my main designer tool or front hand. The .net frame work provides a platform for simplified rapid development of both web-based and windows based applications. As from the course work I have more concentrate on the some of the features of the ASP.Net and such features are like INSERT, UPDATE, DELETE, and SEARCH. These are the basic functions which are required to manage the backend database.
This is the web application so I have created one main page on which contains all the data tabs. This is the page on which I have attached the all links of other page. This is shown in the picture below. When I will run this application the system will load this page to the user after his proper Login to the system.
I am working on mainly six tables like bank master and detail tables, employee’s salary master and details tables and salary payments and finally the leave tables, which are listed on the header of the front page of the application. While I will press on the Bank Master link listed on the top of the page, the bank master form will automatically load on the screen. For that I have apply command on the link button is
response. redirect ("bankmaster")
this syntax says when I will press on that link button, in the response it will redirect me to the bankmaster page. To display the image, text, or any information I have use image button, Labels from the web control menu in the left side of the editor screen. To enter the data to the data base I have use textbox from the designing tool. After that to enter the some information I have to give some command this command can be applied with the help of the Command Button. These are the basic inbuilt tool provided by the ASP.Net and I have used in my project to work with the data.
On clicking the “Bankmaster” LinkButton it will load the Bank Master main page on the screen. I have created Bank Master page to manage the record of the Bank. I have given ID’s to the bank, because the numeric data are quite easy to manipulate and to call in to another table by referring them to the column of another table. I have applied basic required functions on the Bank Master page like, if I want to
Insert the name of the new bank, Delete the Bank names, Search the name of the bank or may be Update. I have applied INSERT, UPDATE, DELETE, and SEARCH command button on the bankmaster page, and wrote the codes for it.
The page given below is a page of Bank Master
In this form the tool which shows that data is called Datagrid.
in this table if want to insert some data then I have to input the name of the some bank in the text box given besides the bankID label and have to press INSERT Command button, so it will the name of new bank in the database. The codes works behind this process is
Sub Button1_Click(sender As Object, e As EventArgs)
if (textbox1.text)="" then
msgbox (" Please insert in the blank Field first")
end if
MyInsertMethod (textbox1.text)
datagrid1.datasource = MyQueryMethod ()
datagrid1.databind()
textbox1.text=""
exit sub
In this syntax firstly, on the command button’s click event, it will check whether text box is not empty if it is empty then it will show the message to enter some data. After checking it will move forward. In inserting method Data Source and DataBind functions are really important. ASP.Net provides Data binding which can significantly reduce the amount of code that needs to be written and maintained for displaying data. While data source will provide the data address to the methods of inserting, deleting, searching, and updating.
In the above image I have inserted the name of the Bank Of Scotland in the database. It is successfully inserted in the data base after pressing the Insert button. As mention above I have given the same INSERT function to other pages.
Similarly I have given the cods for the DELETE function on the Bank Master form, which will delete the non-required data.
Suppose, if I enter the bank ID no 45 in the text box to Delete then
Sub Button3_Click(sender As Object, e As EventArgs)
MyDeleteMethod(textbox1.text)
datagrid1.datasource=myquerymethod()
datagrid1.databind()
textbox1.text=""
End Sub
The similar code I have written, which I have written in the INSERT command. In this code MyDeleteMethod is the function of deletion which will take the value of the TextBox1.Text, then it will search the record from the datagrid, and finally the record will be deleted from the Database.
From the below picture we can see that Bank Of Scotland is not there in the database.
I have linked my all pages with each other in good manner, if I will click on the back command button then The main page will displayed on the screen with the links of many other pages.
on the my main page I have given a another link to the Bank Details web page. If I click on it then
In the above the data is coming from the three tables or I can say there are one primary key and two foreign keys in it. So the data we have entered that should be there in the parent table in the data base backhand. In the earliest forms I have described about the INSERT, And DELETE commands. In this table I have added new function called SEARCH. I have added data grid below to the command buttons to represent the out put of the insert method and search method.
If I want to delete or search any record from the database then I will enter any figure in the bank id and give command either Delete if I want to delete or search if I want to search some data. The search mechanism will work as below.
Firstly I have create a function called MySearchMethod using inbuilt ASP.Net function. Then I have selected the appropriate database connection and give path of that data base. Then on the click event of the search command button I have write following code.
Sub Button3_Click (sender As Object, e As EventArgs)
MySearchMethod (textbox9.text)
DataGrid1.DataSource () =MySearchMethod (textbox9.text)
DataGrid1.DataBind ()
End Sub
In this code the value of the textbox9.text which is BankID in the web page will loaded in the MySearchMethod. Then we pass the value from the function ant it will search for the particular record in the database and if it is there then will give the put in the Data Grid.
Suppose I want to find the record in which bank id is like 14. then I will type bank ID in the text box and give the search command to Web Server. It will give me an out put in this way.
The searched data are represented in DataGrid
SECURITY: Log-In / Pass-Word
I have tried to give some basic level of security to the web application by giving the User Name and Password. In the Log-In page. If the authorized users access the project with the Proper Id and Password then only next page will be loaded. Otherwise it will give a output as error message.
Evaluation of Proposed Implementation
There are many points in which have focused during the time of implementation.
Advantage of Web-based Application:-
Web applications are popular due to the ubiquity of the browser as a client. The ability to update and maintain Web applications without distributing and installing software on potentially thousands of client computers is a key reason for their popularity. A significant advantage of building Web applications to support standard browser features is that they should perform as specified regardless of the operating system or OS version installed on a given client.
Limitations and the Scope of the Application:-
This system has many limitations, I believe because it is my first web application. Such the limitations from the my point of view are
→ This system is not implemented properly,
- In scope, it could be more users friendly.
→ This system can have more then one users with many Id/Password, because this is web based application.
- In scope it can be one data base which store all the Id and passwords in one file.
→ it was possible to make interface more user friendly.
→ As a backhand I have used Access, IT could be more easier to retrieve the query based data if I used oracle as backhand.
These are some limitation of this web application.
Possible recommendations on strategies to overcome future challenges:-
Basically this web application which I have created is very small as is data strength. May be in the future in my company accept my application as future use, then I should have change many of the thing in it. Normally the multinational company has many departments worldwide with thousands of employees. At particular time it becomes very messy task to work with the data with this tables, because there may chance to generate millions of data from different departments with thousand redundant data. It can make big affect in company’s calculation. Because if the company uses such redundant data then it might affect their future prediction.
To handle this kind of problem we need to apply Data Were House and Data Mining System. This is the possible structure of the Data ware house and data mining.
A data warehouse is designed especially for decision support queries. Therefore only data that is needed for decision support is extracted from the operational data and stored in the warehouse. This is designed for strategic decision support, and is largely built up from the database that make up the operational database. The data ware house has some characteristic, it contains vast amount of data, which can mean billions of records. And similar local data ware house are called as Data Mart. Normally it is very difficult to retrieve the data from the data ware house because it has billions of records. It’s really easy to handle data by Data Warehouse and Data Mining Techniques.
The basic structure of the Data Ware house is
- Time Independent
- Non-Volatile
- Subject Oriented
- Integrated.
The most data mining tools involves very large volumes of data. The normal SQL interface to these data sets are simply too slow for the demands of the average data mining algorithms.
Approaches for dealing with Semi structured data and unstructured data.
Now a days the data base is becoming increasingly complex and more information is being generated automatically, for example in the retail, and food and finance sectors, which leads to a situation where organization are producing a huge amount of unstructured data. This arises because the structure of the data being gathered is some times not know in advanced, and also because organization are starting to store copies of their operational data in large data warehouse for decision support purposes. This can become very messy task. So to dealing with semi structured data and structured data, to apply more parallelize version systems, which can adapt old query technology in any new situations.
Threats:-
The computer running on a web server should be kept safe from the many things
1). Limitation of services:- The computer which is running on the web server should be kept to minimum. By removing all the unnecessary services we can reduce the way to hackers to attack on the web application.
2). Viruses:- there may a chance that out web server can be affected by the viruses, via the web application. Because there are many application there which can affect the server’s performance. For that we can protect our web server with appropriate anti viruses.
3). Unauthorized access:- It is possible that if out web application is not secured by the User Id and Password then some unauthorized person can visit the internal structure of the web application and change the relevant data for his benefit. For that we must provide secure user id and password to the known or registered person.
4). Network Threats:- there may be a physical connection of our web server with the internet (WWW). There may be chance of network viruses attack and they can make big damage. Fore that proper firewalls systems we must apply to our web server.
References:-
1). Middlesex University Lecture Activities:
2). Book Name :- Data Mining
Author :- Pieter Adriaans
Dolf Zantinge
3). ASP.NET 2nd Edition
Author :- O’REILLY
4). Microsoft Web Matrix Tutorials
Reflective learning journal of stage1 and stage 2:-
This course work was initially of two stages. In the first stage the I have gathered all the information from the company and initialize my entities, made relationship between them and draw the 3rd normalize EER diagram, UML Diagram. From the my point of view I have learnt from the stage1 is how to gathered the information from the company how to divide information in the entities. How to normalize the entities in to easier way, so that becomes very to understand. I have faced many difficulties but the reading material, lecture slides, and group work took off my all the errors and difficulties.
In the stage two, it was so difficult for me to develop the web based application, because I have never worked on such web server based languages. I have faced many difficulties and still I am confused in some functions. But after reading the books and lecture slides I have sort out many of the difficulties. Initially finishing the stage two I have learnt that how can we create the web server based application, and what are the usages of it, how can apply several functionality in the to the application and even how can we make it in more attractive way. Web based application now very widely used by the any organization, so this mechanism works in the real word that I came to know from the initially task2. Further more I have learnt what are the security measures should I provide to my web server and why it is needed. And many more useful things I have learnt from this module’s coerce work. I have taken lots of help from the group members and even from the internet web sites and books too. Initially I fill I concentrate more on this work then I could make this in better way.
