Showing posts with label Project. Show all posts
Showing posts with label Project. Show all posts

Saturday, November 3, 2018

Proejct Table Structures - Setting General Tables

Master  Tables


State_Master
id Auto Generated
code Auto Generated
Name User Input
ShortName User Input
createby Logged in User
createdate System Date
updateby Logged in User
updatedate System Date
STATUS User Input



Country_Master
id Auto Generated
code Auto Generated
Name User Input
ShortName User Input
createby Logged in User
createdate System Date
updateby Logged in User
updatedate System Date
STATUS User Input

Type_Master
id Auto Generated
code Auto Generated
Name User Input
createby Logged in User
createdate System Date
updateby Logged in User
updatedate System Date
STATUS User Input


SubType_Master
id Auto Generated
code Auto Generated
Name User Input
typeid Ref - Type_Master
createby Logged in User
createdate System Date
updateby Logged in User
updatedate System Date
STATUS User Input


User_Master
id Auto Generated
code Auto Generated
F_NAME      User Input
M_NAME      User Input
L_NAME      User Input
USER_NAME  
PASSWORD User Input
TYPEID      Ref - Type_Master
FIRST_LOGIN Auto Generated
EXPIRYDATE  Auto Generated
PASSUPDATE  Auto Generated
createby System Date
createdate Logged in User
updateby System Date
updatedate User Input
STATUS      User Input


First_Load (Back End table)
COMPANY_CODE    
COMPANY_NAME    
SOFTWARE_VERSION
SOFTWARE_NAME   
MAINSCREEN_PATH 
MOBILE_NO1      
MOBILE_NO2      
WEBSITE         
ADDRESS         
TAG_LINE        
PHONE_NO        
createby
createdate
updateby
updatedate
STATUS      User Input


SETTING_MASTER
 ID             Auto Generated
 CODE           Auto Generated
 FORM_NAME      User Input
 FORM_NAME_MENU User Input
 FORM_PATH      User Input
createby Logged in User
createdate System Date
updateby Logged in User
updatedate System Date
 STATUS         User Input

Wednesday, September 7, 2016

Title For College Project

List of Projects of Project for Computer Science and Application Students


1.      Railway Reservation & Inquiry System
2.      School Management
3.      Reliance Web World
4.      College Management System
5.      Income Tax Management
6.      Library Management
7.      Cyber CafĂ© Management
8.      Payroll Management
9.      Address Book
10.   Gas Agency Management
11.   JET Airways
12.   Jewellery Shop Management
13.   Inventory Control
14.   Result Management
15.   Simple Business Solution System
16.    Telephone Directory Management System
17.   Transport Management System
18.   Computer Center Management
19.   Hotel Management
20.   Hero Honda Showroom
21.   Retail Shop Management
22.   Job Consultancy
23.   Krishna Dutt Book Store Management
24.   Bus Reservation System
25.   Employ Information System
26.   Institute Management System
27.   ‘Italian Food Restaurant’ Management System
28.   Car Workshop Management
29.   Canteen Automation
30.   Hospital Management
31.   Lab Assistant Software
32.   Mobile Shop
33.   Customer Detail System
34.   Transport Management
35.   College Management
36.   Hotel  Management
37.   Home Loan(Cent Bank
38.   Online Examination
39.   Computer Shop Management
40.   Domestic Gas agency
41.   Showroom Management
42.   School Management
43.   Nokia care Project
44.   Patrol Pump Management
45.   Project on Departmental store
46.   Online Test enrollment
47.   LIC
48.   Telephone directory
49.   ATM Management
50.   Courier Service
51.   Air line Reservation
52.   Admission Management System
53.   City Transport
54.   Electricity Bill
55.   Travel agency
56.   Stationary Mngt
57.   Bus Mngt
58.   Pay slip Mngt
59.   Mobile shop Mngt
60.   Hero Honda Agency
61.   Institute Mngt System
62.   Sales Enquiry System
63.   News paper Mngt
64.   Medical Agency
65.   Loan Scheme
66.   Pathology Mngt System
67.    Telephone exchange
68.   Book store Mngt
69.   Job consultancy Mngt
70.   Tourism Project
71.   Inventory mngt
72.   Tyre Showroom Mngt
73.   Computerized Consoling
74.   Reception Mngt System
75.   Hostel Mngt
76.   Automation Of Sai Transport
77.   Relience Sales System
78.   Electronic Shop
79.   Clincal Mngt
80.   Staff Mngt
81.   Fees Mngt
82.   Office Mngt
83.   Factory Mngt
84.   Dealer Information System
85.   Estimate Genrator
86.   Computer Hardware Mngt
87.   Whole sale marketing Mngt
88.   Employee Salary Mngt
89.   First Flight courier Service Mngt
90.   Enquiry and Service Mngt

Live Projects
91.   Automation of cost of Thermal Power System
92.   Medical sales & Purchase
93.   Grouped Email Service
94.   Display Classfied
95.   Drinking water sales mngt
96.   Marriage Bureue mngt
97.   Whiz master
98.   Hardware sales & Service
99.   Vastuland Developer
100.    Placement Agency
101.    Result Generator
102.   Cyber Lab
103.  College Website
104.   Send Free SMS
105.   Balaji Cement Worker
106.   Automobiles
107.   Quick Share
108.    Robotics School
109.    Thyroid Care
110.    Advertisement Website
111.   Online Solution for ‘professional’s Training Academy’
112.   Human Resource Management System

113.     OPD Registration

WEB DEVELOPMENT
1 ONLINE APPLICATION FOR THE TRAINING AND PLACEMENT
2 ONLINE LEAVE MANAGEMENT SYSTEM
3 RECIPE MANAGEMENT SYSTEM
4 COMPLAINT MANAGEMENT SYSTEM
5 WEB BASED MEETING SCHEDULER
6 STUDENT PROJECT ALLOCATION AND MANAGEMENT
7 FAMILY CONNECTION
8 ONLINE ON-REQUEST COURSES COORDINATION SYSTEM
9 ONLINE CARRIER GUIDANCE AND PLACEMENT UNIT
10 AD AGENCY
11 SHOPPING CART
12 HOSPITAL MANAGEMENT SYSTEM
13 ONLINE EXAMINATION
14 COURIER MANAGEMENT SYSTEM
15 STUDENT MONITORING SYSTEM
16 CRIME REPORT MANAGEMENT
17 SEMINAR HALL BOOKING SYSTEM
18 ONLINE MATRIMONIAL SYSTEM
19 MOVIE RENTAL SYSTEMS
20 DISCUSSION FORUMS
21 STUDENT INFORMATION SYSTEM
22 BOOK RENTAL SYSTEM
23 RECEIVING ORDERS FOR PRINTING DIGITAL PHOTOGRAPHS
24 RESUME BUILDER APPLICATION
25 HOSTEL MANAGEMENT SYSTEM
NETWORKING IN LINUX
1 KICKSTART AUTOMATED INSTALLATION OF LINUX
2 WEB SERVER SETUP
3 FTP SERVER SETUP FOR UPLOADING AND DOWNLOADING
4 NFS FILE SERVER FOR SHARING FILES
5 SAMBA SERVER FOR LINUX TO WINDOWS FILE SHARING
6 LOG MONITORING AND LOG ROTATING
7 NETWORK SETUP AND MONITORING
8 SHELL SCRIPTING BASE ADMINISTRATION
BACK END PROJECT
1 An Analytical Study on Technology Deploymnet in Top Banking Companies in India (Banking, Insurance, Services)
2 Studying Top Mutual Fund Companies of India and IT Deployment among them (Banking, Insurance, Services)
3 An Analysis On Enhancing The Technology Usage among Top Insurance Companies in India (Banking, Insurance, Services)
4 An Analytical Study on Technology Adaption in Top Financial Services Companies in India (Banking, Insurance, Services)
5 A Descriptive Study of Cloud Computing Infrastructure of IT Sector in India (Cloud Computing)
6 A Detailed Analysis of SAP ERP Installed Companies in West Region of India (ERP - SAP)
7 A Detailed Analysis of SAP ERP Installed Companies in North Region of India (ERP - SAP)
8 A Study On The IT Strategies Adopted on Usage of  Virtualization Technology by Business Conglomerates in India (Virtualization)
9 An Analysis of Top 1000 IT Spenders Companies in India (IT Infrastructure)
10 A Detailed Analysis of ET 500 Companies in India (IT Infrastructure)
11 A Detailed Analysis of Fortune Next 500 Companies in India (IT Infrastructure)
12 A Study On Growing Ecommerce Industry and its Technology dependency in India (Ecommerce)
13 A Study On Deployment Of Information Technology In Automobile Sector (Automobile)
14 Detailed IT Infrastructure Analysis of Top 10000 Companies in India (India Market)
15 Study on Information Technology Usage and Management Structure of Top 500 companies of Thailand (Thailand Market)
16 Study of Top Insurance Companies of APAC Region (APAC Market)
17 Study on Information Technology Usage and Management Structure of Top 500 companies of Singapore (Singapore Market)
18 Study of Top Banks of APAC Region (APAC Market)

Financial Year Oracle PLSQL Program

 CREATE OR REPLACE function FINANCIAL_YEAR(p_date DATE) return varchar2 IS    v_first     varchar2(4);    v_second    varchar2(4);    v_year...