Thursday, 2 June 2016


MCA 4th sem 2016-17 JUNE Exam Question Paper



First Exam was Mcs-043(Advanced Database Mathematics Management System). It was very easy Exam.

MCS-043





Sunday, 6 March 2016

Project Proposal (Synopsis) for MCA Mini Project at IGNOU 2016(sample)


Index page


1.INTRODUCTION

            1.1  Background
            1.2  Objectives
            1.3  Purpose and Scope
                        1.3.1  Purpose
                        1.3.2  Scope

2. SURVEY OF TECHNOLOGIES

            2.1 Php
            2.2 MySQL

3. REQUIREMENTS AND ANALYSIS

            3.1 Problem Definition
            3.2 Requirements Specification
            3.3 Planning and Scheduling
            3.4 Software and Hardware Requirements
            3.5 Preliminary Product Description
            3.6 Conceptual Models

4. REFERENCES




1.INTRODUCTION

 1.1            Background
A software company maintenance  the details of work status of its projects manually. So maintain all procedures like assigning a project to one team, knowing the status of projects, keeping the project related data for future use  etc. are very difficult. This problem can solve using an online application. Before developing an online  web based application system named “Online Project Work Status” , it is necessary to know or study the existing system.
The maintenance of various procedure related to software company are being done manually. This will lead to many drawbacks.
The main drawbacks of Existing System are:-
·         There  is no proper way to know the status of the project in each steps.
·         Allotting project work to a team by manually is a little time wastage.
·         There is no good way to know which team is working on which project.
·         It is tedious to customer to come and check the project work  status  everyday.
·         There is chance of losing the details of the  project and the documention for future purpose  if it keep in a paper or computer system.
·         Wastage of time and papers.


1.2 Objectives

The main objectives of the project is as explained below
·         To make a online system for Project Work status of a software company.
·         To keeps tracks of allocation of teams to projects.
·         To keep track of status of every project and future resource requirements.
·         To provide needed information and other details to authorized person  in time.
Some of the major roles and responsibilities of any person working in software company is to interact with the higher level person and customer. This system provide a status a project started by a team. It can viewed by other authorized person and customers and also data collection and other related activities.
The proposed project specifically addresses most of these to improve the general efficiency of the software company and related activities in the same.

1.3            Purpose and Scope

1.3.1       Purpose
An online web based application for a software company to maintains the details of work status of its projects. This web based application will help the company to complete all works fast and efficient without time wastage. It provide all features and help to both company and its clients related to project works.

1.3.2         Scope
This system provide the scope of online web based working using the internet such as user registration, project team registration, add project team, update the project status, view the project status etc.



 2. SURVEY OF TECHNOLOGIES


2.1 PHP
The PHP Hypertext Preprocessor (PHP) is a programming language that allows web developers to create dynamic content that interacts with databases. PHP is basically used for developing web based software applications. PHP started out as a small open source project that evolved as more and more people found out how useful it was. Rasmus Lerdorf unleashed the first version of PHP way back in 1994.
·        PHP is a recursive acronym for "PHP: Hypertext Preprocessor".
·        PHP is a server side scripting language that is embedded in HTML. It is used to manage dynamic content, databases, session tracking, even build entire e-commerce sites.
·        It is integrated with a number of popular databases, including MySQL, PostgreSQL, Oracle, Sybase, Informix, and Microsoft SQL Server.
·        PHP is pleasingly zippy in its execution, especially when compiled as an Apache module on the Unix side. The MySQL server, once started, executes even very complex queries with huge result sets in record-setting time.
·        PHP supports a large number of major protocols such as POP3, IMAP, and LDAP. PHP4 added support for Java and distributed object architectures (COM and CORBA), making n-tier development a possibility for the first time.
·        PHP is forgiving: PHP language tries to be as forgiving as possible.
·        PHP Syntax is C-Like.
Common uses of  PHP
·        PHP performs system functions, i.e. from files on a system it can create, open, read, write, and close them.
·        PHP can handle forms, i.e. gather data from files, save data to a file, thru email you can send data, return data to the user.
·        You add, delete, modify elements within your database thru PHP.
·        Access cookies variables and set cookies.
·        Using PHP, you can restrict users to access some pages of your website.
·        It can encrypt data.
Characteristics of PHP
Five important characteristics make PHP's practical nature possible −
  • Simplicity
  • Efficiency
  • Security
  • Flexibility
  • Familiarity

2.2 MySQL
MySQL is the most popular Open Source Relational SQL database management system. MySQL is one of the best RDBMS being used for developing web-based software applications.MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses. MySQL is developed, marketed, and supported by MySQL AB, which is a Swedish company. MySQL is becoming so popular because of many good reasons:
·        MySQL is released under an open-source license. So you have nothing to pay to use it.
·        MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.
·        MySQL uses a standard form of the well-known SQL data language.
·        MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, JAVA, etc.
·        MySQL works very quickly and works well even with large data sets.
·        MySQL is very friendly to PHP, the most appreciated language for web development.
·        MySQL supports large databases, up to 50 million rows or more in a table. The default file size limit for a table is 4GB, but you can increase this (if your operating system can handle it) to a theoretical limit of 8 million terabytes (TB).
·        MySQL is customizable. The open-source GPL license allows programmers to modify the MySQL software to fit their own specific environments.


 3. REQUIREMENTS AND ANALYSIS


3.1 Problem Definition

 

A software company follows a standard waterfall model for development of every project and each step of this model is called a task by the company. Every project is responsibility of a project lead, who makes a schedule of completion of each task. A team of 2 analysts or 2 design experts or 2 programmers or 2 testers are allotted to the project based on the present state of the project. Project lead has to make an online request for reserving the teams. A delayed project needs to be re-allotted the teams. There is a time period to every project all these activities doing manually make so much of problems and wastage of time. The main difficulties  are:-

·         There is no proper way to know the status of the project in each steps.
·         Allotting project work to a team by manually is a little time wastage.
·         There is no good way to know which team is working on which project.
·         It is tedious to customer to come and check the project work  status  everyday.
·         There is chance of losing the details of the  project and the documention for future purpose  if it keep in a paper or computer system.
·         Wastage of time and papers.




3.2 Requirements Specification
Website for Online Project Work Status, this site will be able to handle and automate all functionalities of a software company. It shall be able to do the following functionalities. Information gathering is usually the first phase of the software development project. The purpose of this phase is to identify and document the exact requirements of the system.
The entire system has 3 type of users. Project team , Admin or project lead and Customer .
Login: all user should login their own page using their user ID and Password
Registration: here user and a team should register to this system.
Add new Project: add new project to this system. This is done by admin.
Request to team: send a request to team about new project.
Update status: update the status of the project by team.
View Status : view the status of a project work.

3.3 Planning and Scheduling





3.4 Software And Hardware Requirements

Hardware specification for Developer
ü  512MB RAM(Minimum)
ü  2GB Free Disk Space(Minimum)
ü  Keyboard interface
ü Mouse interface

Software specification for Developer
ü  Adobe Dream Weaver CS3
ü  Apache Server
ü  Language: Php
ü  Web Technologies:HTML5, CSS, JavaScript
ü  OS: Windows 7 and above

Hardware specification for client
ü  Pentium 4 Processor(Minimum)
ü  256MB RAM(Minimum)
ü  1GB Free Disk Space(Minimum)
ü Mouse interface
ü  Keyboard interface

Software specification for client
ü  OS: Windows 7 and above
ü  Database: Apache Server





3.5 Preliminary Product Description
“Online Project Work Status” is to maintains the details of work status of projects of a software company. Company follows a standard waterfall model for development of every project and each step of this model is called a task by the company. Every project is responsibility of a project lead or admin, who makes a schedule of completion of each task. A team of 2 analysts or 2 designers or 2 experts or 2 programmer or 2 testers are allotted to the project based on the present state of the project. Admin make online request to team to reserving project. A delayed project will be re-allotted the teams. The date of starting a task and date of completion of a task  are recorded by this application. In case the task is not yet completed the expected date of completion is recorded. This online system keeps track of allocation of teams to projects and also keep track of status of every project and future resource requirements.

Main Modules
·        Team
. Software company contain a  team of 2 analysts or 2 designers or 2 experts or 2 programmer or 2 testers. A whole team has a login page and that contain the project details given by project or admin. Here team can update the status of particular project with different tasks. (Company follows a standard waterfall model for development of every project and each step of this model is called a task by the company).
Team can do
Ø  Login to Online Project Work Status with user id and password.
Ø  View project details.
Ø  Registration
Ø  Update the status of the project work.

·        Admin
Software company contain a admin or project lead. He collect the project leads and make new user or customer according to registration of user. Add new team, add new project and request to team are also duties of an admin.
Ø  Login to Online Project Work Status with user id and password.
Ø  Add new team.
Ø  Add new user.
Ø  Add new project.
Ø  Request to team.
Ø  View status of work.
·        User
New user can register this website. After admin approval he can login with userid and password. User can also view the status of the project that given to the company.
Ø  Registration
Ø  Login to Online Project Work Status with user id and password.
Ø  View status of work

Static pages are:
Ø  Home
Ø  About company
Ø  Contact us



3.6 Conceptual Models

3.6.1 Level 0





 3.6.2



  3.6.3



   3.6.4


4. REFERENCES