27-08-2014, 03:19 PM
The proposed system can be used to provide an improved automated system for aTraining Program that can be used by the SQL Server Admin for automated creation of credentials for a particular module of the batch for which the batch owner has raised a request. It provides an interface for Trainee Admin who can create a batch, change batch owner for already created batch, schedule modules for a batch, add modules, schedule assessments i.e. tests and retests, allot Educators and Tech Associates for various scheduled modules, assign Evaluators to evaluate Trainee Scripts. It also provides an interface for Batch Owners to request credentials for a particular module of batch assigned to him/her and can also view evaluator assigned for evaluating the scripts of a particular trainee. It also provides an interface for Educators to get the objects created by a trainee at the time of Assessments(Test/Retest).
Purpose
The objective of this application is to provide an improved automated system for a Training Program that can be used by the SQL Server Admin for automated creation of credentials for a particular module of the batch for which the batch owner has raised a request. It provides an interface for Trainee Admin who can create a batch, change batch owner for already created batch, schedule modules for a batch, add modules, schedule assessments i.e. tests and retests, allot Educators and Tech Associates for various scheduled modules, assign Evaluators to evaluate Trainee Scripts. It also provides an interface for Batch Owners to request credentials for a particular module of batch assigned to him/her and can also view evaluator assigned for evaluating the scripts of a particular trainee. It also provides an interface for Educators to get the objects created by a trainee at the time of Assessments(Test/Retest).
Overview General: Application should be accessible to the members of ETA with appropriate permission. Authorization and authentication should be done with the help of windows authentication and Organization.s address book. Based on roles: Trainee Admin:
· Trainee Admin will create a batch.
· He will add the modules for the batch and its schedule.
· He will allocate Batch Owner to a particular batch.
· He will allocate Educator for each course for a batch.
· He can change the Batch Owner.
· He will schedule tests and retests.
· He can assign Educators for evaluation of a test/retest.
· Automatic system generated mail should be sent on all kind of updates.
.Training SQL Server. Admin:
· He will accept or reject the request for SQL server credentials.
Educator:
· Educator can request for the objects (tables, scripts etc.) created by trainee.
· Requested objects should be sent to the Educator through mail.
Batch Owner:
· He will be able to view the details of his batch
· He will be able to see the evaluator for a particular trainee
· He will be able to request the SQL credentials for his batch
Specific to Auto E-mail functionality:
System generated E-mails should be sent automatically to
Batch Owner
ü On creation/updation of batch
ü Onupdating modules schedule
ü Onupdating assessment (Test/Re-Test) schedule
ü On Accepting/Rejecting the request for creation of credentials
ü On creation of credentials
ü Two days before the starting of any course
ü One day before the starting of any course as a reminder
Educator
ü On their allotment to the modules
ü On request of the objects
.Training SQL Server. Admin
ü On being requested for the credentials
Specific to Training SQL Server Database should be created for the requested batch according to module and purpose. SQL server instance logins should be generated for all the students. Users should be created in the newly created database, with respect to the logins. Schemas should be generated for all the users and assigned to the particular user as his default schema. Organization Profile
INFOSYS is a global leader in consulting, technology, and outsourcing solutions. As a proven partner focused on building tomorrow.s enterprise, INFOSYS enables clients in more than 30 countries to outperform the competition and stay ahead of the innovation curve. With US$8.25bn in FY14 revenues and 160,000+ employees, we provide enterprises with strategic insights on what lies ahead. We help enterprises transform and thrive in a changing world through strategic consulting, operational leadership, and the co-creation of breakthrough solutions, including those in mobility, sustainability, big data, and cloud computing.
In 1981, seven engineers started INFOSYS Limited with just US$250. From the beginning, the company was founded on the principle of building and implementing great ideas that drive progress for clients and enhance lives through enterprise solutions. For over three decades, we have been a company focused on bringing to life great ideas and enterprise solutions that drive progress for our clients.
We recognize the importance of nurturing relationships that reflect our culture of unwavering ethics and mutual respect. It.ll come as no surprise, then, that 97 percent (as of March 31, 2014) of our revenues come from existing clients.
INFOSYS has a growing global presence of more than 160,000+ employees worldwide, across 73 offices and 93 development centers in the United States, India, China, Australia, Japan, Middle East, and Europe.
At INFOSYS, we believe our responsibilities extend beyond business. That is why we established the INFOSYS Foundation – to provide assistance to some of the more socially and economically depressed sectors of the communities in which we work. And that is why we behave ethically and honestly in all our interactions – with our clients, our partners and our employees.
Definition and Acronyms
Acronym
Definition
HTML
Hyper Text Markup Language.
It is used for creating web pages and other information that can be displayed on Web Browser
SQL
Structured Query Language
It is designed for managing data held in a Relational Database Management System (RDBMS)
CSS
Cascading Style Sheets
It is used for look and formatting of a document written in a Mark Up language
IIS7
Internet Information Services
It is an extensible web server created by Microsoft for use with Windows NT
GUI
Graphical User Interface
Front end for the application users.
IDE
Integrated Development Environment
Environment in which the application is developed
SMTP
Simple Mail Transfer Protocol
Protocol used to interact through mails
SYSTEM DESCRIPTION Existing System
· No mechanism to remind the Batch Owner to request for credentials for SQL server specific modules.
· Batch Owner needs to know the .Training SQL Server. Admin to make a request for credentials.
· Batch Owner or .Training SQL Server. Admin needs to fetch the students details of the batch.
· .Training SQL Server. Admin needs to manually create the credentials for each and every student of the batch on server.
· Educator can.t directly get the objects created by a particular trainee during assessment.
Proposed System
AJAX
· This provides the framework for building a richer, more interactive, highly personalized cross-browser web applications.
Ajax is a technique for creating fast and dynamic web pages. Ajax allows web pages to be updated asynchronously by exchanging small amounts of data with the server from behind the scenes. This means that it is possible to update parts of web page without reloading the whole page.
Layered Architecture
An architecture in which data moves from one defined level of processing to another. Layer indicates logical separation of components, such as having distinct namespaces and classes for the Database Access Layer and Business Logic Layer. Data Tier is basically the server which stores all the application.s data. Data tier contents Database Tables, XML Files and other means of storing Application Data. Business Tier is mainly working as the bridge between Data Tier and Presentation Tier. All the Data passes through the Business Tier before passing to the presentation Tier. Business Tier is the sum of Business Logic Layer, Data Access Layer and Value Object and other components used to add business logic. Presentation Tier is the tier in which the users interact with an application. Presentation Tier contents Shared UI code, Code Behind and Designers used to represent