Category: SQL Server Projects

Abstract

The project titled “English to Spanish Translation” is designed using.NET with Microsoft Visual Studio.Net 2005 as the front end which works in .Net framework version 2.0.The coding language used is C# .Net.

EXISTING SYSTEM

• In the existing system, the extraction will not be a perfect one. It is a losing one. Because it has a lot of data losses while the text extraction.
• Also the existing one does not retrieve all the text from an image which has number of text. Also, it does not support the high-resolution images.
• The existing one does not provide any language conversion options.

PROPOSED SYSTEM

• The proposed one provides good extraction options. It has a minimized data losing.
• Also it supports high-resolution images which may have a lot of text.
• It provides a high level language conversion technique which is used to convert the extracted English text into Spanish.

HARDWARE CONFIGURATION

• SYSTEM : Pentium IV 2.4 GHz
•  HARD DISK: 40 GB
•  FLOPPY DRIVE: 1.44 MB
• MONITOR : 15 VGA color
• MOUSE : Logitech.
• RAM: 256 MB
• KEYBOARD: 110 keys enhanced.

SOFTWARE CONFIGURATION

• Operating system:- Windows XP Professional
• Front End:- Microsoft Visual Studio .Net 2005
• Coding Language: – C# 2005.
• Back End:- SQL server 2005

Index

• Introduction
• Proposed System
• Objectives to be fulfilled
• System Features
• Assumptions
• Entity Relationship Diagram
• Data Flow Diagram
• Data Dictionary
• Coding System
• Screen Layouts
• Operating Environment
• Proposed Enhancement
• Conclusion
• Bibliography

Introduction

The Project “Online Book Store” is a user interactive and delivery based website where the order can be booked and payments can be done shortly along with getting all the required details regarding each and every mobile.

Business done by e-commerce is far more efficient, faster and reliable than traditional commerce.

This method of adoption of doing business via e-commerce is a user-friendly system which will help the user to access the product easily.

Proposed System

The Online Book Store method of selling products through e-commerce is far more efficient than traditional commerce.

Objectives to be fulfilled

The following are the objectives which are fulfilled by creating an online shop for Selling Books Online.

To provide a wider market to the seller.

To remove monopoly and provide better products to the customers

To make products easily available to the customers.

Assumptions

While developing the E-Commerce website for Book Selling System, following assumptions were kept in mind for the administrator.

The user logged in with ID and Password is a valid user.

The Credit Card Number taken from the user is not received to the database, and is redirected directly to the www.paypal.com via SSL.

All Products are available according to the stock.

Context Diagram

First Level Diagram

Data Dictionary

Table: Board

This Table Keeps the records of different Discussion boards

Field Name	Data Type	Size	Constraint
BoardID	Int	4	Primary Key
B_Name	Varchar	40
B_des	Varchar	100
B_Order	Int	4

Table: Manufacturer

This Table Keeps the records of different Manufacturer Information

Field Name	Data Type	Size	Constraint
Man_id	Int	4	Primary Key
Man_name	Varchar	30
Man_img	Varchar	40

Table : NewestPhone

This Table Keeps the records of Newest Phone

Field Name	Data Type	Size	Constraint
Cheker	Varchar	40	Primary Key
Phone_Id	Int	4
Man_Id	Int	4	Primary Key
Price	Float	8
Thumnail	Varchar	40

Table : Ordertable

This Table Keeps The Records Of All The Orders

Field Name	Data Type	Size	Constraint
OrderId	Varchar	10	Primary Key
UserId	Varchar	20	Primary Key
PhoneId	Varchar	10	Primary Key
Ord_Quentity	Int	4
SubTotal	Float	8

Table : Payments

This Table Keeps The Records Of All The Payments

Field Name	Data Type	Size	Constraint
Order_Id	Varchar	10	Primary Key
User_Id	Varchar	50
Amount	Float	8
Exp_Date	Date	8
Card_No	Varchar	15
IP	Varchar	25
Ord_Date	Date	8
Status	Char	1

Table : PhoneDetails

This Table Keeps The Records Of All The Phones

Field Name	Data Type	Size	Constraint
Phone_Id	Varchar	10	Primary Key
Man_id	Varchar	20
Date_pub	Date	8
Bat_type	Varchar	50
Disp_type	Varchar	50
Big_img	Varchar	50
Small_img	Varchar	50
Thumnail	Varchar	50
Price	Float	8

Table: Post

This Table Keeps The Records Of All The Posts

Field Name	Data Typ	Size	Constraint
PostId	Int	4	Primary Key
PostSubject	Varchar	50
PostedBy	Varchar	50
Posted	Date	8
IP	Varchar	25
Massage	Varchar	200
ThreadID	Int	4

Table : Ratings

This Table Keeps The Records Of All The Ratings For Phones

Field Name	Data Type	Size	Constraint
RatingId	Int	4	PrimaryKey
Rating	Int	4
IP	Varchar	25
PhoneId	Varchar	10

Table : Cart

This Table Keeps The Records Of related cart.

Field Name	Data Type	Size	Constraint
TransId	Int	4	PrimaryKey
SecCode	Int	4
UserId	Varchar	50
PhoneId	Varchar	10
Man_Id	Varchar	20
Price	Float	8
Qty	Int	4

Table : Thread

This Table Keeps The Records Of All Thread

Field Name	Data Type	Size	Constraint
ThreadId	Int	4	PrimaryKey
Tname	Varchar	50
StartedBy	Varchar	50
BoardId	Int	4

Table : User

This Table Keeps The Records Of All The Users

Field Name	Data Type	Size	Constraint
UserId	Varchar	50	PrimaryKey
Pass	Varchar	50
Name	Varchar	50
L_name	Varchar	50
B_Date	Date	8
Country	Varchar	20
Previladge	Char	1
JoinDate	Date	8
ImgUrl	Varchar	200

 

Screen Layouts

Admin Login

Add New Phone

User Home

Listing Mobiles

Mobile’s Details

Contact Us

Coding System

In the Coding System, we have provided a unique primary key to all the Books so they can be searched uniquely.

There would be no redundant data in the coding system.

Operational Environment

The Hardware and Software requirements for this particular project is specified below

Hardware Configuration (Minimum Requirement)
Processor Pentium 233 Mhz
RAM 128 MB
HDD 500 MB
Monitor Supporting resolution up to 1024 * 768

Software Requirement (Minimum Requirement)
Internet Explorer 6 or Above—

Proposed Enhancement

The current Online Book Store project can be made more secure by providing cross-checking techniques and algorithms for keeping the user data secure.

This project is expandable if we can include more modules to it, like shipping and door to door delivery.

Conclusion

This is our first live Online Book Store project to handle an e-commerce website. The firm was only using a traditional commerce method for selling machinery.

During analysis, e gathered the information about the companies by taking interviews of organization staff members and even studied the manual system.

This Website Development Project gave us sound knowledge and experience in all major areas of computer application and to get exposure to various technical and management practices of IT industry.

INTRODUCTION

We see that when a group or society is formed then some rules and laws are made by the people, for the people and to the people. The purpose of these rules and laws are to give a comfortable life to all who are living in that society. Whenever any law is violated by any one then we say that crime is committed and who break that law is called CRIMINAL and to realize that person his/her mistake, there is also a criteria of punishment.

Some times these crimes are committed by same/different people in same /different manner repeatedly. So we have to manage a record of such type of people so that when any special type of crime is committed then that criminal can easily traced out and punish them so that they do not do that crime in future.

The basic entity of this System is FIR. Any victim can lodge a request for FIR through INTERNET from any place. It is not necessary that it should be lodged at same place where the crime occurred. As request lodged, it will automatically reached to the server of the nearest Police Station from the place of crime occurred with the help of information given in the Request Form. At the server side this request will be converted into an FIR and the case will hand over to the Investigation Officer of that Police Station. The IO will investigate the case on the basis of information given in FIR, arrest the suspect or criminal, collect the evidences, inquire the people on the spot and maintain his/her case diary, give his/her report on that case to Magistrate and case will be transfer to COURT where the final decision will taken out on that case and if suspect is proved CRIMINAL, the court will punish him/her. On the basis of court decision the information records such as crime record, criminal record are maintained.

For the easy retrieval of information or data the Databases are maintained at different levels of hierarchy of this System which are state, district, police station

Due to its easily accessible quality and complete Database this system helps the Police Force in collecting information of crime occurred, helps IO in his/her investigation by giving records of old criminal and crime occurred and helps Police Force to control on the occurrence of crime. The overall advantage of this System is basically for Police Force in achieving her objectives i.e. maintain peace in society by proper following of rules and laws.

MODULES

MASTER MAINTENANCE

Functions

This module helps the user to create a new code or modify or delete an existing code in the master tables. The system maintain master tables of items and there codes The master tables are required to codify the information at the time of data entry and decode of the digitized information while generating output.

A. POLICE STATION MASTER

This sub modules give the list of all Districts under State , Police station under each District .Also helps in add/delete new Districts and Police Station.

B. OFFICER MASTER

This sub modules help in listing all Investigation officers and their respective Ranks, rank code, address and telephone number for any future reference According to Police Station/District.

C. CRIME CLASSIFICATION

Minor Heads, Methods and Act& Section links are categorized in Major Heads. New entries modification/deletion of existing entry is possible.

D. ACT AND SECTION

This sub module provides comprehensive records of all acts and section with their linkages to their respective crime heads. A user can enter new act /section or add/edit/delete existing records.

2. ENTRY OF FORMS

Functions

This module helps to maintains the backbone of Crime Records Management System. This helps the user to call the already forms on the screen for editing and deleting the existing information in field.

A. FIRST INFORMATION REPORT

The first event in the Crime cycle starts with the reporting of a case, usually in the form of a First Information Report (FIR). The FIR is a detailed document that captures critical information about the nature of the crime, the location details, the sequence of details, information on victims where relevant and other pieces of information pertaining to the crime.

B. GENERAL DIARY

This module tells about daily working of the Police Station. Round a clock this dairy was maintained.

C. CASE DAIRY

This module is only for investigation officer & I.O. enter the information of case dairy.

D. CRIME DETAILS

Crime details is used to record the modus operandi of the case, Details of Victims, Motive of crime, Details of property involved stolen, Details of suspect, Description of place of crime.

E. PROPERTY SEIZURE

This sub module for the information of property seizure memo.

F. ARREST/COURT SURRENDER

This module show which suspect is arrested or surrendered in court and Details of that suspect and enables the user to capture the Details of arrested/surrender person.

G. FINAL REPORT

This sub module enables the user to enters the details of information collected on Final Report Form.

H. COURT DISPOSAL MEMO

Once the case is disposed off the Court details are recorded on Court Disposal.

I. TALASH FORM

This is an integrated form to enter the details about Missing, Kidnapped, Un-Identified, Dead Bodies and the like.

3. ENQUIRY

Functions

Enquiry module enables the users to retrieve the data on Enquiry parameter.

A. CRIME RELATED ENQUIRY

The user can retrieve the database on crime parameters (M.O).

B. CRIMINAL RELATED ENQUIRY

User can perform queries based on criminal parameters.

C. PROPERTY RELATED ENQUIRY

User can perform queries on parameters of properties involved in Crime or Seized.

4. REPORTS

Functions

This module of application helps to generate reports on Cases, Criminals, Properties, Matching of Properties/Persons and statistical details.

A. REPORTS ON CASE AND CRIMINALS

It helps to generate statistics on
1. CRIMINAL NAME WISE
2. MODUS OPERANDI
3. CRIMINAL DEFORMITY
4. CASE PROGRES
5. PENDING CASE

B. REPORTS ON PROPERTY

It helps to generate statistics on
1. LIST OF CULTURAL PROPERTY
2. LIST OF NUMBERED/UNNUMBERED
3. LIST OF FIREARMS
4. LIST OF AUTOMOBILES

C . STATICAL REPORTS

It helps to generate statistics on
1. COGNIGABLE
2. SECTION WITH CRIMES
3. CRIME AGAINST WOMEN
4. CRIME STATICS

D. MISCELLINEOUS REPORTS

It helps to generate list of Codes, States/Districts/Police Station, Code for Numbered, Unnumbered property etc.

SOFTWARE REQUIREMENTS 

SERVER

SQL Server

TOOLS

.NET Framework

ASP.NET Components

Microsoft Visual Studio.NET 

Services

ASP.NET XML Web Services

Architecture

Client Server Architecture

Project Title: Online Web Portal

Category: Application Development, Enterprise. 

A number of trends in computational science and engineering have increased the need for effective communication systems. The communication systems are characterized by the article multiplicity and social community. The communication system consists of a number of articles and blogs interconnected by a network. The web communication system integrated here facilitates information sharing by posting a contextual article and publishing it at a web interface of the system. A blog may be created because the user does wants to have the required information on the web. The blogs may also be organized collectively if the expected turn around time will be better.

From a user point of view, the set of anonymous readers in a communication system acts like a single virtual system. Hence, when an Author posts an article for publication, it becomes the responsibility of an administrator of the communication system to collect the ratings of the readers to processes and to rate the processes to suitable articles of the system according to these ratings.

An Administrator organizes the processes in a communication system to make use of the system information in such a manner that Article usage, response time, blog creation, and comments over read are optimized variety of widely differing thoughts and solutions for communication processes of a Information system have been proposed. This communication process can be broadly classified into three types:

1. Article posting in which each article submitted by an Author (Administrator) for publication is viewed as a collection of related topics and these topics are posted to web interface so as to provide information.
2. Article rating in which all the ratings submitted by the readers are distributed among the articles of the system so as to emphasize the interest up on the article.
3. Blog creation which simply attempts to create the topic of the system to blog post by assuring that no idea is idle while information wait for being communicated.
4. Comment posting in which each comment submitted by a reader for communicating is viewed as a collection of related ideas and these ideas are shared to suitable reader so as to improve communication.

Of these communication processes, the information sharing has valuable applicability in practical situations because it works on the assumption that the readers of all the categories to be communicated are shared in views. Furthermore the creating blogs that fall in this system do interaction of the dynamically changing thoughts of the readers. Hence we are enabling the information sharing approach for better communication.

The web communication approach is considered, as an appropriate solution because of the overwhelm involved in gathering information to achieve the objective is normally very quick, especially in communication systems having a large number of readers.

Technology : Asp.Net, C#.Net, MS SqlServer,

Database Server: Microsoft SQL Server

Tools: Microsoft Visual Studio .Net

User Interface: Asp.Net with Ajax

Code Behind: VC#.Net

Objective:-

The ultimate aim of this Human Resource Management System project is to automate the entire work of REPS using software.

Modules:-

1. Admin
2. Employee
3. Manager
4. Account

Description:

This section describes the processes to be automated with respect to the Human Resource (HR) department. 

Admin:

The Admin module contains the some of the Master Setup Process of Information’s. The sub modules presented are listed here.

• Employee details
• Previous Experience Details
• Loan Settings
• Leave Settings
• Department Details
• Holiday Settings
• Appraisal
• Promotion
• Designation Settings
• Add user
• Attendance 

Employee Details:

Employee details maintains a database of all the employees personal details. This  data bank helps in tracking changes in salary scales and allowances, Production of appropriate reports, verifying and registering personal details of each and every employee and also  while issuing loans to an employee.

Previous Experience details:

Here to collect the all the Previous experience information about particular employee. This help the HR to track the performance of the employee in the previous company.

Loan Settings:

The loan module walks through the employees salary details and sanctions loan.

Loan is provided by the company based on the annual income of  the individual. This module calculates the EMI for the loan provided and finally it generates a report.

Leave Settings: 

The  Leave  details maintenance help to credit leave to employee accounts, Maintain details on leave availed and required approvals, Maintain details of   leave encashment, Validate details of residual leave.

Appraisal management 

The appraisal module helps the employer in maintaining details of timely performance reports that portrays an employees performance. This module helps in rating the employees skill level and generates appropriate appraisal to employees.

Promotion-details Management

The promotion module helps in keeping track of the experience gained by the employee and generates a list of eligible candidates for promotion. Promotion is awarded according to the performance and seniority.

Department details

The department details module maintains department details of employees.

This helps in work allocation, transfer of  employee from one department to another, Providing promotion and also to examine the performance of  a group of employee.

Holiday Settings

This lists yearly holidays provided for all the employees by the company.

Designation settings

This module maintains all employees’ designation details and defines a work profile to the employee. This provides a clear layout of  the employee’s authorities and responsibilities.

Add user

This allows new users to register.

Attendance management

This module keeps track of each employee’s late arrival and overtime worked by the employee. This keeps an attendance register and captures interface data. A report is generated regarding an employees in time and out time.  

Software Requirements:

Development Environment : Visual Studio.NET

Front End : ASP.NET

Back End : SQL Server

Client Side Scripting : JavaScript

Server Side Script : C#.NET