Academic Projects & Tech Interview

Online Shopping System Context level Data Flow Diagram

2020-02-04T21:29:00.001-08:00

Online Shopping System Context level Data Flow Diagram

Online Shopping Project allows customer to buy products online from a seller’s website in real-time system using Internet. Online Shopping System can handle general working of any Online Shopping store and it also maintain the back office process whenever we buy products online.

Level 0 Diagram

A context diagram is also called DFD Level 0. This is top level data flow diagram and provides overview of the entire system. This diagram contains only one process node that generalizes the entire system function in relationship to external entities.

Source: https://123projectlab.com/data-flow-diagram-symbols-and-examples/

Online Book Shopping System

2012-09-28T22:03:00.001-07:00

Online Book Shopping Project is the process whereby many consumers directly buy their books online from a seller interactively in real-time system without an intermediary service by using Internet. This System covers the detailed working of any Online Book Store and it also covers all what happens whenever we to buy a books online.

Some of the features of the proposed project Online Book Shopping are as follows:

Online Book Shopping System also gives facility of password recovery option in users email id.If user forgot his password , he can go to forgot password option ,enter his email id and he will receive a mail in his email id containing his password.
The Online Book Shopping System is menu driven. This project provides facility of storing and maintaining details of customer, books,publishers,author etc.
Online Book Shopping System also maintains some information of customers and back office book order processing, such as customer details, order processing etc. Detail of any individual can be searched by giving its id.

Software requirements for online book shopping system

Microsoft Visual Studio 2008

SQL Server 2005 / 2008

Hardware Requirements for online book shopping system

Processor : Minimum 1.6
RAM: Minimum 384 MB
Hard-Disk space: 2.2 GB of available hard-disk space
Display: 1024 x 768 or higher-resolution display

To view online demo of Online Book Shopping System project leave a comment below with your Email id, or send us email at projects602@gmail.com we will send you link of online demo video of this project

Details of Purchasing Online Book Shopping Project
Project Code   :: 22
Project Type    :: Web
Technology      :: Visual Studio 2008(using C#) ,Sql Server 2005 / 2008, Java Script
Project Cost    :: Rs.(INR) = 2000/-

>>Click Here to Buy<<

Download project report on Factory Automation System

2012-09-18T04:31:00.003-07:00

The project entitled “Factory Automation System (FAS)” aims at automation of various processes of a food product manufacturing company. Current manual system that is employed is quite inadequate it only makes the process more difficult and hard. Main purpose of this software is to reduce manpower and paper work and provide the security from unauthorized access. It helps in producing different kinds of report required in organization for different managerial aspects.

The projects aims at Business process automation, i.e. we have tried to computerize various processes of a food products manufacturing company. As the company deals in the sector of manufacturing, purchasing as well as selling we have computerizes their inventory and stock maintenance. FAS is very flexible software and can be used in any for any manufacturing and selling based company having little or no changes. In this software we have also tried to provide all the account related facilities which help company in preparing many account statements without using any specialize accounting package. This system is Menu-Driven and embodies distinctive features like accuracy, consistency of information, conciseness, integrity of data, flexibility and security because this system works for more than one system such as maintenance of stocks of different kinds of items and products with which the company deals. The system is capable of monitoring the current stock status at any instance of time.

For downloading project report Click Here

Online Shopping System

2012-09-14T22:48:00.001-07:00

Online Shopping System is the process where consumers can directly buy products online from a seller in real-time over the Internet. The Given System provides the detailed working of the Online Shopping Store Processing and what all happens whenever we or any one of us goes to buy a products online.

Online shopping system is cost effective and measurable .Online Shopping System benefits both customers and marketers simultaneously. Customers can buy products 24 hours a day from anywhere around the world and interact with sellers (via his website) to find the product or service information they desire. Product selling companies can interact with customers and enable them to learn more about customers’ needs, build good customer relationships, increase efficiency and reduce costs, and gain access to national and international markets quickly

Hardware Requirements for Online Shopping System

Processor : Minimum 1.6 GHz
RAM: Minimum 384 MB
Hard-Disk space: 2.2 GB of available hard-disk space
Display: 1024 x 768 or higher-resolution display
Additional Hardware: DVD-ROM Drive

To view online demo of Online Shopping System project leave a comment below with your Email id, or send us email at projects602@gmail.com we will send you link of online demo video of this project

Details of Purchasing This Project
Project Code   :: 21
Project Type    :: Web
Technology      :: Visual Studio 2008(using C#) ,Sql Server, Java Script
Project Cost    :: Rs.(INR) = 2000/-

>>Click Here to Buy<<

---------------------------------------------------------------------------------------------------------------------------------------------
keywords :
Ready,made,readymade,project,online,shopping,system,sourccode,asp.net,visual,studio,.net,vb.net,.net,c sharp,c#,for,BTech,BCA,MCA,DOEACC,IGNOU,mcs044,mcs,044,44,MCSP060,SMU,Live,Project,in Asp.Net,Asp Net,Project,Synopsis,report,DFD,Documentation,online,book,store,er,diagram, Online Shopping System

Most Common Interview Mistakes ,Oops!

2012-09-09T07:48:00.003-07:00

In our last post we discussed about Job Interview Success and Tips for Interviews. Now here we are going to discuss interview mistakes that we commonly do in our interview.

Do not Discuss on salary before getting a job offer

In an interview sometimes you may be asked about salary needs. If you tell an amount which is lower than what the employer is planning to pay then most likely he may not pay you more and you may lost potential income. If you tell an amount that is too high then the employer may be that you will not to take the job at the salary. After receiving job offer, it is perfectly acceptable to negotiate on salary - generally an employer will not retract his job offer. But discussing on salary before the offer is given must be avoided .

Not Recognizing your strengths and weaknesses.

Only you can understand your strengths and weaknesses. You must be able to specify your strengths and your weaknesses.

Arriving Late

Running late not only suggests poor time management skills, but shows a lack of respect for the company, the position and even your interviewer.Budget your time so that you make it to the interview five to ten minutes early.

Not Knowing Anything About the Company

When you walk into a job interview, knowledge of the company's history, goals and current activity proves to the interviewer that you are not only prepared for the interview, but also that you want to be a part of the organization.

Talking Too Much

Keep your focus on the job at hand and, even if a personal issue arises, concentrate on discussing your qualifications and skills .

Bad-mouthing for Your old Employer

You should not look like a complainer. Do not bad - mouthing for your old employer .

Some related articles are :

Top 15 Key Questions for Any Interview

Tips to Handle a Phone Interview Successfully

Job Interview Success and Tips for Interviews

Tips to write a GOOD Resume for freshers !

2012-09-03T10:33:00.003-07:00

In our last Post ' What you should NEVER include in your resume ! ' we talked about what we should not include in our resume.Now in this post we have tried to include best things that must be in your resume.

Use keywords in your resume that match with what the employer is looking for :

Review the advertisements posted and use the key words in your resume to match with what the employer is looking for. You must showcase to the employer your relevant skills and qualification to suit that particular position.

Think of what makes you unique :

Remember your resume is marketing a brand called you. It is a tool that you could use to your benefit if it is crafted well. See that you enlist your features and benefits that they just can’t be missed. Think of what makes you unique and definitely include that. Make sure that all the relevant information is there.

Number of Page in Resume:

Recruiters never read your resume; they do a spot check of your resume.Lengthy resume does not make you more impressive, and there are many other reasons to keep your resume short too.There is a good practice to keep your resume to one page when you have less than 5 years of experience or at maximum two pages .

Use an appropriate font size:

See that your resume reads easily. Format it carefully, use an appropriate font which is no smaller than 10.

Use Tables in Your Resume:

Use tables to show your year wise qualifications. It helps interviewer to understand your achievements easily.

Use of Bullets:

Use bullets in your resume to show . It gives good visibility to the interviewer .

Add Your Projects:

Candidates must add their top 3 - 4 projects in their resume either academic project or industrial projects.

Get someone else to review your resume:

Ask someone to review your resume before you send it so that any flaws can be picked out and rectified. Also ask them to ask you questions based on your resume so you can practice answering convincingly.

Create an email proof formatting:

It is very likely that you will end up sending your resume via email to most companies. Apart from having a Word document ready to go as an attachment, you should also have a text version of your resume that does not look disfigured in the body of the email or in online forms. Attachments might get blocked by spam filters, and many people just prefer having the resume on the body of the email itself.

You can download 10 free resume templates

10 best employment providing Websites in india and there popularity as per Alexa ranking

2012-09-02T11:00:00.002-07:00

Naukri.com

Services :
Resume Writing Services
Resume Spotlight
Jobs4U

Alexa Ranking [As on 02/Sep/2012 ] : Global 422,India 21

monsterindia.com

Services :
XpressResume+
RightResume
Career Booster
Resume Highlighter

Alexa Ranking [As on 02/Sep/2012 ] : Global 1640 , India 136

timesjobs.com

Services :
Resume Services
Resume Critique
Profile Verification

Alexa Ranking [As on 02/Sep/2012 ] : Global 1525,India 127

jobsahead.com

Services :
Right Resume
Express Resume Service
Career Booster

Alexa Ranking [As on 02/Sep/2012 ] : Global 254874,India 45588

devnetjobsindia.org

Services:
Broadcast Resume
Search Jobs

Alexa Ranking [As on 02/Sep/2012 ] : Global 140629,India 23283

careerbuilder.co.in

Services:
My Career Builder
Post Resume

Alexa Ranking [As on 02/Sep/2012 ] : Global 13682,India 697

clickjobs.com

Services:
Resume Writing,Broadcast,Highlight
Salary Center - Salary Calculator,Salary Articls

Alexa Ranking [As on 02/Sep/2012 ] : Global 58477,India 9673

careerage.com

Services:
Jobs Abroad
Walkins

Alexa Ranking [As on 02/Sep/2012 ] : Global 23630,India 2442

freshersworld.com

Services:
Power Resume
Job Mentor
Power Placement Preparation

Alexa Ranking [As on 02/Sep/2012 ] : Global 4365,India 320

shine.com

Services:
Resume Service
Career Advice
Industry Information

Alexa Ranking [As on 02/Sep/2012 ] : Global 2212,India 147

Job Interview Success and Tips for Interviews

2012-09-01T06:39:00.002-07:00

Employers look for a person who will be a pleasure to work with and who can work into the company’s work atmosphere just as much as they look for skills. Keep that in mind when conversing with potential employers.

Remain positive during the interview

During the interview try to remain as cool as possible. Ask for clarification if you're not sure what's been asked and remember that it is perfectly acceptable to take a moment or two to frame your responses so you can be sure too fully answer the question.

Do not speak negatively

Do not speak negative about your current or former employer or give any confidential information that you shouldn't. We have seen people lose out on jobs by criticizing former employers or by mentioning things about their current employer that they should not have.

Practice Makes Perfect

Have a career counselor or friends and family ask you a list of questions and give you feedback.Film your responses and review your performance.

If appropriate ask questions

After completing major part of interview , if appropriate, ask some questions , they will know enployer your interest in the job .

Do some research before interview

C Language Interview Questions VOL-III

2012-08-31T06:18:00.001-07:00

Q.1 Define Constructors?

Ans: A constructor is a member function with the same name as its class. The constructor is invoked whenever an object of its associated class is created.It is called constructor because it constructs the values of data members of the class.

Q.2 What is message passing?

Ans: An object oriented program consists of a set of objects that communicate with each other. Message passing involves specifying the name of the object, the name of the function and the information to be sent.

Q.3 How do declare an array?

Ans: We can declare an array by specify its data type, name and the number of elements the array holds between square brackets immediately following the array name.syntax : data_type array_name[size];

Q.4 What are the advantages of using array of pointers to string instead of an array of strings?

Ans: Efficient use of memory.Easier to exchange the strings by moving their pointers while sorting.

Q.5 What is the difference between the functions memmove() and memcpy()?

Ans: The arguments of memmove() can overlap in memory. The arguments of memcpy() cannot.

Q.6 Is it better to use a macro or a function?

Ans: The answer depends on the situation you are writing code for. Macros have the distinct advantage of being more efficient (and faster) than functions, because their corresponding code is inserted directly into your source code at the point where the macro is called. There is no overhead involved in using a macro like there is in placing a call to a function. However, macros are generally small and cannot handle large, complex coding constructs. A function is more suited for this type of situation.Additionally, macros are expanded inline, which means that the code is replicated for each occurrence of a macro. Your code therefore could be somewhat larger when you use macros than if you were to use functions.Thus, the choice between using a macro and using a function is one of deciding between the tradeoff of faster program speed versus smaller program size. Generally, you should use macros to replace small, repeatable code sections, and you should use functions for larger coding tasks that might require several lines of code.

Q.7 Give two use of bitwise and (&) operator?

Ans: It can be used to check whether particular bit is set or not. Eg suppose we have a number 101. Now if we want to check whether its second bit is on or off. To know this we must simply do bitwise and operation on this number with 010. Since result is 0 therefore we can acknowledge that second bit is low in our case.It can be used to unset particular bit. Eg if you want to unset second LSB of any number then you must simply do bitwise operation between that number and …11111101.

Q.8 What the advantages of using Unions?

Ans: When the C compiler is allocating memory for unions it will always reserve enough room for the largest member.

Q.9 What is conversion operator?

Ans: You can define a member function of a class, called a conversion function, that converts from the type of its class to another specified type.

Q.10 What does the error ‘Null Pointer Assignment’ means and what causes this error?

Ans: As null pointer points to nothing so accessing a uninitialized pointer or invalid location may cause an error.

Q.11 What is encapsulation?

Ans: Containing and hiding information about an object, such as internal data structures and code. Encapsulation isolates the internal complexity of an object’s operation from the rest of the application.

Q.12 What is dynamic binding?

Ans: Dynamic binding (also known as late binding) means that the code associated with a given procedure call is not known until the time of the call at run time.It is associated with polymorphism and inheritance.

Q.13 What is generic pointer in C?

Ans: In C void* acts as a generic pointer. When other pointer types are assigned to generic pointer,conversions are applied automatically (implicit conversion).

Q.14 What is dynamic array?

Ans: The dynamic array is an array data structure which can be resized during runtime which means elements can be added and removed.

Q.15 What is static identifier?

Ans: A file-scope variable that is declared static is visible only to functions within that file. A
function-scope or block-scope variable that is declared as static is visible only within that scope. Furthermore, static variables only have a single instance. In the case of function- or block-scope variables, this means that the variable is not “automatic” and thus retains its value across function invocations.

Q.16 What is the use of default constructor?

Ans: A constructors that accepts no parameters is called the default constructor.If no user-defined constructor exists for a class A and one is needed, the compiler implicitly declares a default parameterless constructor A::A(). This constructor is an inline public member of its class. The compiler will implicitly define A::A() when the compiler uses this constructor to create an object of type A. The constructor will have no constructor initializer and a null body.

10 free resume templates for IT jobs

2012-08-30T00:45:00.003-07:00

10 free resume templates for IT jobs in the high-tech industry. Information-Technology and Computer Science occupations with sample resumes for free download: Software Developer, Web Developer, Entry-Level Software Engineer, Database Administrator / DBA, Oracle Developer, LAMP Developer, Perl / Python Developer, IT Project Manager, Computer Programmer, Network Manager, Computer Technician, LAN Administrator, Software Quality Assurance, Info Security, more.

These are free sample resume for your reference. It gives a brief outline to frame a standard resume to catch the attention of your employer. Update your resume with your skills and job profile in your present and previous organization. We hope the sample will help you in getting you your desired position.All resume examples in Microsoft Word

Download Resume Format No. 01
Download Resume Format No. 02
Download Resume Format No. 03
Download Resume Format No. 04
Download Resume Format No. 05
Download Resume Format No. 06
Download Resume Format No. 07
Download Resume Format No. 08
Download Resume Format No. 09
Download Resume Format No.10

What you should NEVER include in your resume !

2012-08-28T05:29:00.001-07:00

Avoid Bad grammar and obscure words

Describing yourself as a "Verry detail oriented multi-taster" is likely to get no other response than, "Yeah, right" before it's passed around the HR department for laughs--and then tossed. And don't try to impress with big words. No one needs to know you are endowed with "sophrosyne," when "good sense" will do.

Cut out all the irrelevant work experiences

If you're still listing that prized shift leader position from your high school days, it's time to move on.Yes, you might've been the "king of making milkshakes," but unless you're planning on redeeming that title, it's time to get rid of all that clutter.

Your short-term jobs.

Short-term jobs raise red flags for hiring managers, who will wonder if you were fired, couldn't do the work, or had trouble getting along with co-workers. Plus, a few months on a job won't typically be useful in showing any real accomplishments or advancement anyway.

Any Personal Data Beyond Your Contact Information

Do not include any personal information beyond your address, email, and phone number. Leave out your age,religion, political affiliation, and the names and ages of your spouse and/or children. While some of this information may be required in a CV, it should be left out of a resume.

Your salary

Resumes don't typically include a salary history, so candidates who include it come across as naive. And by sharing that information unbidden, you'll also compromise your negotiating power later.

Extra pages

If you're in your 20s, your resume should only be one page; there's not enough experience to justify a second one. If you're older, two pages are fine, but you go over that limit at your own peril. Hiring managers may spend only 20 or 30 seconds on your application initially, so extra pages are either ignored or they dilute the impact of the others. Your resume should be for highlights, not extensive detail.

Avoid Negative Words/Ideas

Avoid saying what you did not do or have not yet accomplished; focus on what you have done or are in the process of achieving. For example, if you are still in college, do not say "not yet graduated," but instead list the year in which you will graduate. If you didn't graduate, simply list the dates you attended. Instead of saying that you have "limited experience" in administrative work, simply provide examples of your previous experience.

"References Available Upon Request"

Generally it is assumed that a job applicant will have references. Instead of including the references on your resume or saying "references available upon request," you can send the hiring manager a separate sheet of references or wait until you are asked to provide references.

Criminal Record

If you get hired, the company will likely conduct a search of your criminal record. However, there is no need to include this information on your resume.

A crazy objective

So you want to be the next Bill Gates. Terrific! And you may even have the chops to make it happen. But please don't put it in your objective statement. Outlandish, overconfident, or "out there" objective statements almost always ensure that the rest of your resume isn't read.

20 -Online Bus Ticket Booking Website

2012-08-25T19:41:00.001-07:00

In Online Bus Ticket Booking Website there has been a collection of buses, customer which gives station name,tour date and departure time for searching bus. According to its name Online Bus Ticket Booking manages the details of all Customers, tickets,rental details, and timing details and so on. It also manages the updating of the objects.

In this project (Online Bus Ticket Booking Website) there is information about bus, who has been taking customers at their destination, it also contain the detailed information about the customer, who has been taken from which bus and at what are the number of members he or she is taking his/her journey. Online Bus Ticket Booking also contain the details of booking time of the seat(s) or collecting time of the tickets, Online Bus Ticket Booking Website also contain the Tour date and the name of destination, by which the customer can reserve the seats for his journey

The silent features of Online Bus Ticket Booking project are :

In Online Bus Ticket Booking Website customer can see a graphical seat status of Available/ Booked seats and select his desired seat in the bus.
In Online Bus Ticket Booking Website customer can book/cancel seates from his home without booking agents.
In Online Bus Ticket Booking Website we have also given email notification feature in the project . Customer will get a Ticket No notification on his email id .
Online Bus Ticket Booking Website also has provision that If customer forgot his password he can get it by selecting forgot password option and system will forward his password to his email id

In this project (Online Bus Ticket Booking Website) we have divided the whole project into two parts according to user role

Administrator part
Customer/User part

In Administrator part of Online Bus Ticket Booking Website we have following modules :

Station Master
Bus Type Master
Bus Master
Route Master
Email Setup
Admin Report
View Enquiry
Customer List

In customer/user part of Online Bus Ticket Booking Website we have included following modules :

Search Bus
Book Tickets
My Tickets
Edit Profile
Cancel Ticket
Post Enquiry
About Us

To view online demo of Online Bus Ticket Booking Website project leave a comment below with your Email id, or send us email at projects602@gmail.com we will send you link of online demo video of this project

Details of Purchasing Online Bus Ticket Booking Project
Project Code    :: 20
Project Type    :: Web
Technology    :: Asp.net,C#,Sql Server, Java Script,Crystal Report
Project Cost    :: Rs.(INR) = 2000/-

>>Click Here to Buy<<

Control your Android phone with SMS

2012-08-24T07:00:00.001-07:00

In case you have misplaced your phone at home and had kept it in silent mode then ringing the phone to find it, is not an option. However, if yours is an Android device, then you can change the settings remotely just through an SMS by using a wonder app

.'Agastya' is a new Android app that lets you “remotely” perform various tasks on your phone from any other phone via simple SMS commands. The other phone, that is sending the commands, need not be running Android – even the basic Nokia 1100 would do just fine – and either phones don’t require GPS or data plans (Internet).

List of SMS commands that you can try on your Android phone:

RINGER – Turn on the ringer

SILENT – Turn off the phone’s ringer

IMEI – Get the IMEI number* of your phone

LAST CALLS – Know the last 5 missed/received/dialed numbers

LAST MESSAGES – Retrieve the last 5 text messages received on your phone

<CONTACT> – Fetch the contact number of a person from the address book.

The data which could be fetched includes

Phone Profile (Changing profile mode to Ringer or Silent)

SIM Number (Retriving SIM Number)

SMS logs (Checking SMS's received on your phone)

Contacts (Fetching contact number from your Address book)

Call Logs (Checking Missed Calls/Received Calls/Dialed Numbers)

IMEI Number

You can dowanload it Here or Click Here

How to use RequiredFieldValidator

2012-08-22T11:52:00.003-07:00

One of the main tasks for every web developer is to check for errors while developing web pages. According to the server side terminology, this concept is called as Validation.This is one of the important controls used in majority of web applications.

Use of RequiredFieldValidator

If a user fails to enter the required information on the form then the message given on this validation control will appear thereby forcing the user to fill up the required information.The RequiredFieldValidator control is used to make an input control a required field.With this control, the validation fails if the input value does not change from its initial value. By default, the initial value is an empty string ("").

Important Properties

ControlToValidate

The id of the control to validate

ErrorMessage

The text to display in the ValidationSummary control when validation fails.
Note:This text will also be displayed in the validation control if the Text property is not set.

Text

The message to display when validation fails

The code given below will illustrate this concept in detail

<p>
Name:
<asp:TextBox id="TextBox1" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator id="RequiredFieldValidator1" runat="server" ErrorMessage="Please enter your name" ControlToValidate="TextBox1"></asp:RequiredFieldValidator>
</p>
<p>
Age:   
<asp:TextBox id="TextBox2" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator id="RequiredFieldValidator2" runat="server" ErrorMessage="Please enter your age" ControlToValidate="TextBox2"></asp:RequiredFieldValidator>

Build a Career in Android !

2012-08-20T07:35:00.000-07:00

What is Android

Android is a free, open source, mobile platform operating system that was introduced, with the help of Google, by the Open Handset Alliance in November of 2007. Since then, Android’s popularity has skyrocketed, giving mobile app developers plenty of reason to celebrate.

Android System and Architecture

Dalvik VM (Android counterpart of JVM). Android Platform Versions.

Android application development

Android application development helps the developers to create new and powerful mobile application quickly and easily as per the needs and demands of users. Since Android application development can run on Linux platforms and supports Java, it helps to create third party applications together by integration. Android application development comes with so many core application inclusions like SMS, E-mail compatibility, Personal Information Management Program, Web browser, Google Map application, Picture viewer, Music Player, Amazon MP3 store and also facility to download third party applications.

List of Mobile App Development Companies/Developers in India

Halosys Technologies
Location : New Delhi
Website : http://www.halosys.com/

Tech Ahead Software
Location : Noida
Website : http://www.techaheadcorp.com/

Shah Deep International Business Solutions Ltd
Location : Noida
Website : http://www.shahdeepinternational.com/

Mobisoft Technologies
Location : Noida
Website : http://mobisofttechnologies.com/

Quytech
Location : Gurgaon
Website : http://www.quytech.com/

Softweb Solutions
Location : Ahmedabad
Website : http://www.softwebsolutions.com/

Fusion Informatics PVT Ltd
Location : Ahmedabad
Website : http://www.fusioninformatics.com/

Inheritx Solutions PVT Ltd
Location : Ahmedabad
Website : http://inheritx.com/

CDN Solutions Group
Location : Indore
Website : http://www.cdnsol.com/

Stark Infotech
Location : Pune
Website : http://www.starkinfotech.com/

LogicTree IT Solutions
Location : Hyderabad/Bangalore
Website : http://www.logictreeit.com/

Wit Innovation Technologies
Location : Bangalore
Website : http://www.witinnovation.com/

Xoriant
Location : Mumbai, Pune, Kolkata
Website : http://www.xoriant.com/

Sybrant Technologies PVT Ltd
Location : Chennai
Website : http://www.sybrant.com/

Zylog Systems
Location : Chennai
Website : http://www.zsl.com/in/

BlazeDream Technologies (P) Ltd
Location : Chennai
Website : http://www.blazedream.com/

RMN Infotech PVT Ltd
Location : Hyderabad
Website : http://www.rmninfotech.com/

Make Superb Facebook Timeline Covers

2012-08-20T04:24:00.000-07:00

For Making Your Timeline, Designing it; may be difficult for you so here I will tell you about websites where you can easily create superb pages. Grab all these sites

Timeline Cover Banner

Ttimelinecoverbanner.com helps you to create a more creative and customized timeline banner. It also support the timeline editor with tons of graphic clipart and backgrounds . You just need to browse them and copy paste the GRAPHIC ID of your desired image to our editor, and,.. presto!.. your chosen graphic is added and ready to combine with your photo.

Face Coverz

If you are looking for the best Facebook Covers with a large selection go to the Face Coverz

Here you can get high quality & cool Covers for your Facebook Timeline profile.

Cover Junction

This site is the place for creating, sharing and discovering the highest-quality Facebook Covers online.

Core Java - Interview Questions and Answers VOL-III

2012-08-16T20:10:00.001-07:00

Q.1 What is the purpose of the Runtime class?

Ans: The purpose of the Run time class is to provide access to the Java run time system.

Q.2 Can a public class MyClass be defined in a source file named YourClass.java?

Ans: No the source file name, if it contains a public class, must be the same as the public class name itself with a .java extension.

Q.3 Can main method be declared final?

Ans: Yes, the main method can be declared final, in addition to being public static.

Q.4 What will be the output of the following statement?

System.out.println ("1" + 3);

Ans: It will print 13.

Q.5 When a thread blocks on I/O, what state does it enter?

Ans: A thread enters the waiting state when it blocks on I/O.

Q.6 To what value is a variable of the String type automatically initialized?

Ans: The default value of a String type is null.

Q.7 What is the catch or declare rule for method declarations?

Ans: If a checked exception may be thrown within the body of a method, the method must either catch the exception or declare it in its throws clause.

Q.8 What is the difference between a MenuItem and a CheckboxMenuItem?

Ans: The CheckboxMenuItem class extends the MenuItem class to support a menu item that may be checked or unchecked.

Q.9 What is a task's priority and how is it used in scheduling?

Ans: A task's priority is an integer value that identifies the relative order in which it should be executed with respect to other tasks. The scheduler attempts to schedule higher priority tasks before lower priority tasks.

Q.10 What is the purpose of the enableEvents() method?

Ans: The enableEvents() method is used to enable an event for a particular object. Normally, an event is enabled when a listener is added to an object for a particular event. The enableEvents() method is used by objects that handle events by overriding their event-dispatch methods.

Q.11 What is the difference between the File and RandomAccessFile classes?

Ans: The File class encapsulates the files and directories of the local file system. The RandomAccessFile class provides the methods needed to directly access data contained in any part of a file.

Q.12 What class is the top of the AWT event hierarchy?

Ans: The java.awt.AWTEvent class is the highest-level class in the AWT event-class hierarchy.

Q.13 When a thread is created and started, what is its initial state?

Ans: A thread is in the ready state after it has been created and started.

Q.14 What is the difference between preemptive scheduling and time slicing?

Ans: Under preemptive scheduling, the highest priority task executes until it enters the waiting or dead states or a

higher priority task comes into existence. Under time slicing, a task executes for a predefined slice of time and then reenters the pool of ready tasks. The scheduler then determines which task should execute next, based on priority and other factors.

Q.15 Is the numeric promotion available in other platform?

Ans: Yes. Because Java is implemented using a platform-independent virtual machine, bitwise operations always yield the same result, even when run on machines that use radically different CPUs.

Q.16 What is the difference between the Boolean & operator and the && operator?

Ans: If an expression involving the Boolean & operator is evaluated, both operands are evaluated. Then the & operator is applied to the operand. When an expression involving the && operator is evaluated, the first operand is evaluated. If the first operand returns a value of true then the second operand is evaluated. The && operator is then applied to the first and second operands. If the first operand evaluates to false, the evaluation of the second operand is skipped.Operator & has no chance to skip both sides evaluation and && operator does. If asked why, give details as above.

Q.17 Name Component subclasses that support painting ?

Ans: The Canvas, Frame, Panel, and Applet classes support painting.

Q.18 What is a native method?

Ans: A native method is a method that is implemented in a language other than Java.

Q.19 How can you write a loop indefinitely?

Ans: for(;;)--for loop; while(true)--always true, etc.

Q.20 Can an anonymous class be declared as implementing an interface and extending a class?

Ans: An anonymous class may implement an interface or extend a superclass, but may not be declared to do both.

Q.21 What is the purpose of finalization?

Ans: The purpose of finalization is to give an unreachable object the opportunity to perform any cleanup processing before the object is garbage collected.

Q.22 When should the method invokeLater()be used?

Ans: This method is used to ensure that Swing components are updated through the event-dispatching thread.

Q.23 How does Java handle integer overflows and underflows?

Ans: It uses low order bytes of the result that can fit into the size of the type allowed by the operation.

Q.24 What class allows you to read objects directly from a stream?

Ans: The ObjectInputStream class supports the reading of objects from input streams.

Q.25 How are this() and super() used with constructors?

Ans: this() is used to invoke a constructor of the same class. super() is used to invoke a superclass constructor.

Q.26 How is it possible for two String objects with identical values not to be equal under the == operator? How are this() and super() used with constructors?

Ans: The == operator compares two objects to determine if they are the same objects in memory. It is possible for two String objects to have the same value, but located in different areas of memory.

Q.27 What is an IO filter?

Ans: An IO filter is an object that reads from one stream and writes to another, usually altering the data in some way as it is passed from one stream to another.

Q.28 What will be the initial value of an object reference which is defined as an instance variable?

Ans: The object references are all initialized to null in Java. However in order to do anything useful with these references, you must set them to a valid object, else you will get NullPointerException everywhere you try to use such default initialized references.

Q.29 What are the different scopes for Java variables?

Ans: The scope of a Java variable is determined by the context in which the variable is declared. Thus a java variable can have one of the three scopes at any given point in time.
1. Instance : - These are typical object level variables, they are initialized to default values at the time of creation of object, and remain accessible as long as the object accessible.
2. Local : - These are the variables that are defined within a method. They remain accessible only during the course of method execution. When the method finishes execution, these variables fall out of scope.3. Static: - These are the class level variables. They are initialized when the class is loaded in JVM for the first time and remain there as long as the class remains loaded. They are not tied to any particular object instance.

Q.30 What is the default value of the local variables?

Ans: The local variables are not initialized to any default value, neither primitives nor object references. If you try to use these variables without initializing them explicitly, the java compiler will not compile the code. It will complain about the local variable not being initialized..

PHP interview questions and answers

2012-08-10T07:00:00.001-07:00

Q.1 What type of inheritance that php supports?.

Ans: PHP supports only single inheritance.But multiple inheritance can be implemented in php through use of interface.

Q.2 What’s the special meaning of sleep and wakeup?

Ans: __sleep returns the array of all the variables than need to be saved, while __wakeup retrieves them.

Q.3 Would you initialize your strings with single quotes or double quotes?

Ans: Since the data inside the single-quoted string is not parsed for variable substitution, it’s always a better idea speed-wise to initialize a string with single quotes, unless you specifically need variable substitution.

Q.4 How come the code <?php print "Contents: $arr[1]"; ?> works, but <?php print "Contents: $arr[1] [2]"; ?> doesn’t for two-dimensional array of mine?

Ans: Any time you have an array with more than one dimension, complex parsing syntax is required. print "Contents: {$arr[1][2]}" would’ve worked.

Q.5 What is the difference between echo and print?

Ans:
echo:
Is a command only.
Faster than print
print:

Is a function.

It will return true(1) or false(0) or some values.

Q.6 POST and GET Methods : Which will execute faster POST or GET? Explain?

Ans: Once most important difference is when you are sending the form with GET method. It displays name/value pair used in the form at the address bar of the browser preceded by url.Whereas if you send the form with POST method then user can not see that information and Secondly When you want to send short or small data & Less Sensitive Data then you can use GET Method. But for long data & Sensitive Data sending say more then 100 character you can use POST method

Q.7 What’s the difference between htmlentities() and htmlspecialchars()?

Ans: htmlspecialchars only takes care of <, >, single quote ‘, double quote " and ampersand.
htmlentities translates all occurrences of character sequences that have different meaning in HTML.

Q.8 How do you define a constant?

Ans: Via define() directive, like define ("MYCONSTANT", 100);

Q.9 Explain the ternary conditional operator in PHP?

Ans: Expression preceding the ? is evaluated, if it’s true, then the expression preceding the : is executed, otherwise, the expression following : is executed.

Q.10 What does a special set of tags <?= and ?> do in PHP?

Ans: The output is displayed directly to the browser.

Q.11 What’s the difference between include and require?

Ans: It’s how they handle failures. If the file is not found by require(), it will cause a fatal error and halt the execution of the script. If the file is not found by include(), a warning will be issued, but execution will continue.

Q.12 How do you pass a variable by value?

Ans: Just like in C++, put an ampersand in front of it, like $a = &$b

Q.13 Difference between require() and include()?

Ans: if filepath not found .. require() teriminates the program and gives fatal error but include() not teriminate the program it gives warning msg and continues to program.

Q.14 What are cron jobs? Explain in details. ?

Ans: CRON is the name of program that enables UNIX users to execute commands or
scripts (groups of commands) automatically at a specified time/date. It is
normally used for sys admin commands like makewhatis which builds a search
database for the man -k command or for running a backup script but can be used
for anything. A common use for it today is connecting to the internet and
downloading your email.

Q.15 What is the diffrence between Notify URL and Return URL?.

Ans: Notify URL: The URL to which PayPal posts information about the transaction via Instant Payment Notification. Must be URL-encoded. Its an optional field have maximum 256 characters length.

Q.16 How do I find out the number of parameters passed into function?

Ans: func_num_args() function returns the number of parameters passed in.

Q.17 what are the various methods to pass data from one web page to another web page ?

Ans:
1.POST
2.GET
3.SESSION
4.COOKIES
5.QUERY STRING

Q.18 Will comparison of string "10" and integer 11 work in PHP?

Ans: Yes, internally PHP will cast everything to the integer type, so numbers 10 and 11 will be compared.

Q.19 What is differenc between mysql_connect and mysql_pconnect?

Ans: mysql_connect opens up a database connection every time a page is loaded. mysql_pconnect opens up a connection, and keeps it open across multiple requests. mysql_pconnect uses less resources, because it does not need to establish a database connection every time a page is loaded.

Q.20 How do you call a constructor for a parent class?

Ans: parent::constructor($value)

Q.21 When are you supposed to use endif to end the conditional statement?

Ans: When the original if was followed by : and then the code block without braces.

Q.22 What’s the difference between md5(), crc32() and sha1() crypto on PHP?

Ans: The major difference is the length of the hash generated. CRC32 is, evidently, 32 bits, while sha1() returns a 128 bit value, and md5() returns a 160 bit value. This is important when avoiding collisions.

Q.23 What is htaccess? Why do we use this and Where?

Ans: .htaccess files are configuration files of Apache Server which provide a way to make configuration changes on a per-directory basis. A file containing one or more configuration directives is placed in a particular document directory and the directives apply to that directory and all subdirectories thereof.

Q.24 What is the difference between characters 23 and x23?

Ans: The first one is octal 23, the second is hex 23.

Q.25 How do you know (status) whether the recipent of your mail had opened the mail i.e read the mail?

Ans: In PHP we can use "Disposition-Notification-To:" in header function.

Dowanload VLC media player beta for Android free

2012-08-06T07:00:00.002-07:00

The new VLC beta (Neon) has been released for Android smartphones and tablets.It is in beta stage but it can still be downloaded on select Android devices running on specific versions of ARM processor. VLC media player for desktops is

that all-in-one style software that supports playback of a large variety of video and audio formats.

Some of its features are :

It can play all local audio and video files as in it's desktop version
It supports multi track audio
You can browse folders directly or make library for your audio & video files

Minimum requirements

Android 2.1
CPU ARVMv7

You can dowanlod it Here of Click Here

C# Interview Questions with answers

2012-07-25T02:49:00.002-07:00

Q1. What is C#?

Ans: C# (is pronounced as "C sharp") is a simple, modern, object-oriented, and type-safe programming language.It combines the high productivity of Rapid Application Development (RAD) languages.

Q2. Explain a DataSet?

Ans: It is an in memory representation of data loaded from any data source.

Q3. Explain Constructors?

Ans: It is called constructor because it constructs the values of data members of the class.It is a member function with the same name as its class. It is invoked whenever an object of its associated class is created.

Q4. What is object?

Ans: It is an instance of a class. It is created by using operator new. A class that creates an object in memory will contain the information about the values and behaviours of that specific object.

Q5. Explain interface class?

Ans: It’s an abstract class with public abstract methods all of which must be implemented in the inherited classes.

Q6. What is ENUM?

Ans: It is used to define constants.

Q7. What does Dispose method do with connection object ?

Ans: Deletes it from the memory.

Q8. Explain difference between Class And Interface?

Ans: It is collection of data and related sub procedures with defination.Class is a logical representation of object.
Interface is also a class containg methods which is not having any definations.Class does not support multiple inheritance while interface can support.

Q9. Explain the role of the DataReader class in ADO.NET connections?

Ans: It returns a read-only dataset from the data source when the command is executed.

Q10. Is it possible to change the value of a variable while debugging a C# application?

Ans: Yes, if we are debugging via Visual Studio.NET, just go to Immediate window.

Q11. Explain the difference between the Debug class and Trace class?

Ans: Debug class is used for debug builds and Trace class is used for both debug and release builds.

Q12. How can we sort the elements of the array in descending order?

Ans: By calling Sort() and then Reverse() methods.

Q13. Are private class-level variables can inherited?

Ans: Yes, but they are not accessible, so we can say that they are not inherited. But they are.

Q14. Explain the types of comment in C#?

Ans: Types of comments in C#.
•    Single line (//)
•    Multi (/* */)
•    Page/XML Comments (///).

Q15. Explain difference between // comments, /* */ comments and /// comments?

Ans: Single-line, multi-line and XML documentation comments.

Q16. Is it possible to declare the override method static while the original method is non-static?

Ans: No, we can not do so, the signature of the virtual method must remain the same, only the keyword virtual is changed to keyword override.

Q17. What does the This window show in the debugger?

Ans: It shows the object that’s pointed to by this reference. Object’s instance data is shown.

Q18. What are the different namespaces used in C#.NET?

Ans: Namespace used in C#.NET are
•    using System;
•    using System.Collections.Generic;
•    using System.Windows.Forms;

Q19. Explain the types of access modifiers in C#?

Ans: Access modifiers in C# are :
•    public
•    protect
•    private
•    internal
•    internal protect

Q20. What are three services model (three-tier application).

Ans:
Presentation (UI)
Business (logic and underlying code)
Data (from storage or other sources).

Q21. Can we override private virtual methods?

Ans: No, moreover, we cannot access private methods in inherited classes, have to be protected in the base class to allow any sort of access.

Q22. Explain an abstract base class?

Ans: It is a class that is designed to be specifically used as a base class. An abstract class contains at least one pure virtual function.

Q23. Why can’t we specify the accessibility modifier for methods inside the interface?

Ans: They all must be public. So, for preventing us from getting the false impression that we have any freedom of choice, we are not allowed to specify any accessibility, it’s public by default

Q24. Explain polymorphism?

Ans: Polymorphism means multiple forms but one name. It allows us to have more than one function with the same name in a program.It allows us to have overloading of operators so that an operation can exhibit different behaviours in different instances.

Q25. Is it possible to store multiple data types in System.Array?

Ans: No.

Q26. Explain multicast delegate?

Ans: It’s a delegate that points to and eventually fires off several methods.

Q27. Explain difference between the System.Array.CopyTo() and System.Array.Clone()?

Ans: System.Array.CopyTo() performs a deep copy of the array while System.Array.Clone() is shallow.

Q28. Explain the use of using statement in C#?

Ans: This statement is used to obtain a resource, execute a statement, and then dispose of that resource.

Q29. Explain the role of the DataReader class in ADO.NET connections?

Ans: It returns a read-only dataset from the data source when the command is executed.

Q30. Explain the difference between Structure and Class?

Ans: Difference between Structure and Class are
•    Structures are value type and Classes are reference type
•    Structures can not have contractors or destructors.
•    Classes can have both contractors and destructors.
•    Structures do not support Inheritance, while Classes support Inheritance.

Q31. Explain the pre-requisite for connection pooling?

Ans: Multiple processes must agree that they will share the same connection, where every parameter is the same, including the security settings.

Q32. Explain the types of arrays in C#?

Ans:
•    Single-Dimensional
•    Multidimensional
•    Jagged arrays.

MySQL Interview Questions

2012-07-19T21:59:00.002-07:00

Q.1 What does tee command do in MySQL?

Ans: tee followed by a filename turns on MySQL logging to a specified file. It can be stopped by command note.

Q.2 How do you start MySQL on Linux?

Ans: /etc/init.d/mysql start

Q.3 What are HEAP tables in MySQL?

Ans: HEAP tables are in-memory. They are usually used for high-speed temporary storage. No TEXT or BLOB fields are allowed within HEAP tables. You can only use the comparison operators = and <=>. HEAP tables do not support AUTO_INCREMENT. Indexes must be NOT NULL.

Q.4 how you will Create a database on the mysql server with unix shell

Ans: mysql> create database databasename.

Q.5 how to list or view all databases from the mysql server.

Ans: mysql> show databases;

Q.6 How do you concatenate strings in MySQL?

Ans: CONCAT (string1, string2, string3)
.

Q.7 What are ENUMs used for in MySQL?

Ans: You can limit the possible values that go into the table. CREATE TABLE months (month ENUM ‘January’, ‘February’, ‘March’,…); INSERT months VALUES (’April’).

Q.8 What does tee command do in MySQL?

Ans: tee followed by a filename turns on MySQL logging to a specified file. It can be stopped by command note.

Q.9 How do you change a password for an existing user via mysqladmin?

Ans: mysqladmin -u root -p password “newpassword”.

Q.10 Use mysqldump to create a copy of the database?

Ans: mysqldump -h mysqlhost -u username -p mydatabasename > dbdump.sql.

Q.11 What does myisamchk do?

Ans: It compressed the MyISAM tables, which reduces their disk usage.

Q.12 How do you start and stop MySQL on Windows?

Ans: net start MySQL, net stop MySQL.

Q.13 How do you control the max size of a HEAP table?

Ans: MySQL config variable max_heap_table_size.

Q.14 How to see table's field formats or description of table .

Ans: mysql> describe tablename.

Q.15 How to delete a database from mysql server.

Ans: mysql> drop database databasename.

Q.16 How to delete a table

Ans: mysql> drop table tablename.

Q.17 How you will Show all data from a table.

Ans: mysql> SELECT * FROM tablename.

Q.18 What is SERIAL data type in MySQL?

Ans: BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT.

Q.19 Explain the difference between FLOAT, DOUBLE and REAL. ?

Ans: FLOATs store floating point numbers with 8 place accuracy and take up 4 bytes. DOUBLEs store floating point numbers with 16 place accuracy and take up 8 bytes. REAL is a synonym of FLOAT for now.

Q.20 What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?

Ans: It stops incrementing. It does not overflow to 0 to prevent data losses, but further inserts are going to produce an error, since the key has been used already.

Q.21 What does myisamchk do?

Ans: It compressed the MyISAM tables, which reduces their disk usage.

Q.22 how to Return total number of rows.

Ans: mysql> SELECT COUNT(*) FROM tablename.

Q.23 How to Update database permissions/privilages.

Ans: mysql> flush privileges.

Q.24 How we get Sum of column ?

Ans: mysql> SELECT SUM(*) FROM [table name].

Q.25 How do you find out which auto increment was assigned on the last insert?

Ans: SELECT LAST_INSERT_ID() will return the last value assigned by the auto_increment function. Note
that you don’t have to specify the table name.

Q.26 Explain the difference between FLOAT, DOUBLE and REAL. ?

Q.27 Can you save your connection settings to a conf file?

Ans: Yes, and name it ~/.my.conf. You might want to change the permissions on the file to 600, so that it’s not readable by others.

Q.28 Explain the difference between MyISAM Static and MyISAM Dynamic. ?

Ans: In MyISAM static all the fields have fixed width. The Dynamic MyISAM table would include fields such as TEXT, BLOB,etc. to accommodate the data types with various lengths. MyISAM Static would be easier to restore in case of corruption,since even though you might lose some data, you know exactly where to look for the beginning of the next record.

Q.29 How would you select all the users, whose phone number is null?

Ans: SELECT user_name FROM users WHERE ISNULL(user_phonenumber).

Q.30 When would you use ORDER BY in DELETE statement?

Ans: When you’re not deleting by row ID. Such as in DELETE FROM techpreparation_com_questions ORDER BY timestamp LIMIT 1. This will delete the most recently posted question in the table techpreparation_com_questions.

12 - Library Management System [VB 6.0 / Oracle]

2012-07-18T08:14:00.001-07:00

The “LIBRARY MANAGEMENT SYSTEM” process made computerized to reduce human errors and to increase the efficiency. The main focus of this project is to lessen human efforts. The maintenance of the records is made efficient, as all the records are stored in the Sql database, through which data can be retrieved easily. The navigation control is provided in all the forms to navigate through the large amount of records. If the numbers of records are very large then user has to just type in the search string and user gets the results immediately.

The editing is also made simpler. The user has to just type in the required field and press the update button to update the desired field.The Books and members are given a particular unique id no. So that they can be accessed correctly and without errors. Our main aim of the project is to get the correct information about a particular student and books available in the library.

Modules of the project

01-User Login
02-Book Module
03-Publiher Module
04-Author Module
05-Member Module
06-Book Issue & Receive Module
07-Report Module

Project abstract

Introduction

The project “Library Management System” is dedicated to the general requirements of the library system .Manually handling of large records is tedious and not always enjoyable. Efforts and energies are hence focused at not just speeding up the management capabilities ,but also on consciously reducing their load in an effort to provide accurate and depending information. Computers are able to do all kinds of tasks at amazing speed than done manually. Therefore, come forth the idea of developing a project on the general requirements of library system.

Objective

THE SYSTEM GOING TO BE DESIGNED MUST FULLFILL THE FOLLOWING NEEDS OF THE Library system

    Facility to store the information of new book, member, author, publisher, city, state etc.
    Facility to keep record of the users of the system.
    Facility to change user’s password or delete an exiting user’s account.
    Facility to set different access rights for different users.
    Facility to backup the database
    Facility to generate different reports, which are helpful for the management in decision making.

Project Category

This project “Library Management System” can be placed under the Relational Database Management System (RDBMS) category as it is to provide each end every detail regarding the Library system

Module Description

USER & SECURITY MANAGEMENT MODULE

The output managing modules are:

User list
Permission to library master module and book transaction module

LIBRARY MASTER MODULE

The output of this module is:

Book detail & status to book transaction module
Book detail to member management module

MEMBER MANAGEMENT MODULE

The outputs of this module are:

Member record to book transaction module
Member to report preparation module

BOOK TRANSACTION MODULE

The outputs of this module are

Book issue
Book report

REPORT PREPARATION MODULE

The outputs of this module are

Book status report
Member report

To view online demo of Library Management System project leave a comment below with your Email id, or send us email at projects602@gmail.com we will send you link of online demo video of this project

Details of Purchasing This Project

Project Code :: 12

Project Code :: Desktop

Technology :: VB 6.0 ,Oracle 9i,Crystal Report

Project Cost :: Rs.(INR) 1600/-

>>Click Here to Buy<<

-----------------------------------------------------------------------------------------------------------

keywords
Readymade Project, Academic Projects in Visual Basic, VB.NET, C#, ASP.NET, SQL Server Source Code for final year student, project of BE, BSC-IT, BCA, MCA, Synopsis, DFD, Requirement, Documentation,Live Project,Synopsis,MCSP060,MCS-044,oracle
Academic Project Readymade Project BTech BCA MCA MBA Bsc-IT MS BIT ADIT DOEACC IGNOU SMU Live Project in Asp.NET,VB.NET, C#,Visual BasicTRT.

15 - Online Library Management System

2012-07-10T10:22:00.000-07:00

This project of “ONLINE LIBRARY MANAGEMENT SYSTEM” is a web base project on Asp.Net. It gives us the complete information about the library. We can enter the record of new books and retrieve the details of books available in the library. We can issue the books to the students and maintain their records and can also check how many books are issued and stock available in the library.The Online Library Management System is designed & developed for a receipt and issuance of books in the library along with the student’s details.

The books received in the library are entered in Books Entry form and the new student is entered in the student entry form. When the student wants to get the desired book the same is issued on the availability basis to the student. This project is base on Asp.Net technology and sql server database.

Modules of the project

01-New User
02-View User
03-Change Password
04-State Master
05-City Master
06-Book Master
07-Author Master
08-Publisher Master
09-Member Master
10-Library Card Master
11-Book Issue
12-Book Receive
13-Member Register
14-Book Registration

Project abstract

Objective

The Online Library Management System is an application for assisting a librarian in managing a book library in a university.The system would provide basic set of features to add/update members, add/update books, and manage check in specifications for the systems based on the client’s statement of need.Online Library management system is a typical management Information system (MIS),its Development include the establishment and maintenance of back-end database and front-end application development aspects. For the former require the establishment of data consistency and integrity of the strong data security and good libraries. As for the latter requires the application fully functional, easy to use and so on.

Existing System

In daily transaction process student demands for book in inquiry window. The availability demanded book and gives book availability details to student. If book is available, Librarian fills up book information and student information. If staff demand for book then librarian fill up person information and issues book.System Analysis is a detailed study of the various operations performed by a system and their relationships within and outside of the system. Here the key question is- what all problems exist in the present system What must be done to solve the problem Analysis begins when a user or manager begins a study of the program using existing system.During analysis, data collected on the various files, decision points and transactions handled by the present system. The commonly used tools in the system are Data Flow Diagram, interviews, etc. Training, experience and common sense are required for collection of relevant information needed to develop the system. The success of the system depends largely on how clearly the problem is defined, thoroughly investigated and properly carried out through the choice of solution. A good analysis model should provide not only the mechanisms of problem understanding but also the frame work of the solution. Thus it should be studied thoroughly by collecting data about the system. Then the proposed system should be analyzed thoroughly in accordance with the needs.

Features

Proposed system is an automated Online Library Management System. Through our software user can add books, search books, renewal, update information, edit information, and return books in quick time. Our proposed system has the following advantages.

User friendly interface and fast access to database
Less error and More Storage Capacity
Searching facility
Look and Feel Environment
Quick transaction
A librarian can issue a book to the student
A Student Can view The different categories of books available in the Library .
A librarian Can view the List of books available in each category
Can take the book returned from students
Add books and their information of the books to the database
Edit the information of the existing books.
Check the report of the issued Books.
Access all the accounts of the students.
View the List of books available in each category
Student can put a request for a new book
View the history of books issued to him previously
Search for a particular book.

To view online demo of Online Library Management System project leave a comment below with your Email id, or send us email at projects602@gmail.com we will send you link of online demo video of this project

Details of Purchasing This Project

Project Code :: 15

Project Type :: Web

Technology :: Asp.net,C#,Sql Server, Java Script,Crystal Report

Project Cost :: Rs.(INR) = 2000/-

>>Click Here to Buy<<

---------------------------------------------------------------------------------------------------------------------------------------------
keywords :
Ready made Online Library Management System Project BTech BCA MCA DOEACC,IGNOU,mcs044,MCSP060,SMU Live Project in Asp.Net,Asp Net,VB.NET,C#,Library Management System in Asp.Net,Asp Net,Visual Basic,VB.6.0,C#,mcs044,MCSP060,SQL Server,Oracle,Dowanload Source Code,BCA,MCA,Project Synopsis,DFD,Documentation,Live Project use and so on.

Interview questions with answers on SQL VOL-IV

2012-07-06T09:09:00.001-07:00

Q.1 What is database Trigger?

Ans: A database trigger is a PL/SQL block that can defined to automatically execute for insert, update, and delete statements against a table. The trigger can e defined to execute once for the entire statement or once for every row that is inserted, updated, or deleted.

Q.2 What are the different types of data models ?

Ans:

Entity relationship model
Relational model
Hierarchical model
Network model
Object oriented model
Object relational model

Q.3 What is Self Join?

Ans: A self join can be of any type, as long as the joined tables are the same. A self join is rather unique in that it involves a relationship with only one table.

Q.4 What are the type of Synonyms?

Ans: There are two types of Synonyms are :

Private

Public

Q.5 What is an Integrity Constrains?

Ans: An integrity constraint is a declarative way to define a business rule for a column of a table.

Q.6 What is referential integrity?

Ans: Referential integrity refers to the consistency that must be maintained between primary and foreign keys, i.e. every foreign key value must have a corresponding primary key value.

Q.7 What is Table?

Ans: A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.

Q.8 What is a synonym?

Ans: A synonym is an alias for a table, view, sequence or program unit.

Q.9 What is Rollback Segment?

Ans: A Database contains one or more Rollback Segments to temporarily store "undo" information.

Q.10 What does COMMIT do?

Ans: A Commit makes permanent the changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that start only after transaction is committed.

Q.11 What are defaults? Is there a column to which a default can't be bound?

Ans: A default is a value that will be used by a column, if no value is supplied to that column while inserting data. IDENTITY columns and timestamp columns can't have defaults bound to them. See CREATE DEFUALT in books online.

Q.12 What is diffrence between Co-related sub query and nested sub query?

Ans: Correlated subquery runs once for each row selected by the outer query. It contains a reference to a value from the row selected by the outer query.Nested subquery runs only once for the entire nesting (outer) query. It does not contain any reference to the outer query row.

Q.13 What is the use of DBCC commands?

Ans: DBCC stands for database consistency checker. We use these commands to check the consistency of the databases, i.e., maintenance, validation task and status checks.

Q.14 What is a Linked Server?

Ans: Linked Servers is a concept in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T-SQL Statements. With a linked server, you can create very clean, easy to follow, SQL statements that allow remote data to be retrieved, joined and combined with local data.

Q.15 What is Collation?

Ans: Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types and character width.

Q.16 What are different type of Collation Sensitivity?

Ans: The different phases of transaction are

Kana Sensitivity

Width sensitivity

Case sensitivity

Accent sensitivity

Q.17 What is the difference between a primary key and a unique key?

Ans: Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index on the column, where are unique creates a nonclustered index by default. Another major difference is that, primary key doesn’t allow NULLs, but unique key allows one NULL only.

Q.18 What is the difference between Function and Stored Procedure?

Ans: Difference between Function and Stored Procedure

UDF can be used in the SQL statements anywhere in the WHERE / HAVING / SELECT section where as Stored procedures cannot be.

UDFs that return tables can be treated as another rowset. This can be used in JOINs with other tables.

Inline UDF’s can be though of as views that take parameters and can be used in JOINs and other Rowset operations.

Q.19 What command do we use to rename a db?

Ans: sp_renamedb “oldname” , “newname” If someone is using db it will not accept sp_renmaedb. In that case first bring db to single user using sp_dboptions. Use sp_renamedb to rename database. Use sp_dboptions to bring database to multi user mode.

Q.20 What is BCP?

Ans: BulkCopy is a tool used to copy huge amount of data from tables and views. BCP does not copy the structures same as source to destination.

Q.21 What is Cross Join?

Ans: A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join. The size of a Cartesian product result set is the number of rows in the first table multiplied by the number of rows in the second table.

Q.22 What is Storage Manager?

Ans: It is a program module that provides the interface between the low-level data stored in database, application programs and queries submitted to the system.

Q.23 What is "index covering" of a query?

Ans: Index covering means that "Data can be found only using indexes, without touching the tables"

Q.24 What are stored-procedures? And what are the advantages of using them?

Ans: Stored procedures are database objects that perform a user defined operation. A stored procedure can have a set of compound SQL statements. A stored procedure executes the SQL commands and returns the result to the client. Stored procedures are used to reduce network traffic.

Q.25 What is OLTP?

Ans: Online Transaction Processing (OLTP) relational databases are optimal for managing changing data. When several users are performing transactions at the same time, OLTP databases are designed to let transactional applications write only the data needed to handle a single transaction as quickly as possible.

Q.26 What is DDL (Data Definition Language)?

Ans: A data base schema is specifies by a set of definitions expressed by a special language called DDL.

Q.27 What is Weak Entity set?

Ans: An entity set may not have sufficient attributes to form a primary key, and its primary key compromises of its partial key and primary key of its parent entity, then it is said to be Weak Entity set.

Q.28 What is a deadlock?

Ans: Two processes wating to update the rows of a table which are locked by the other process then deadlock arises.

Q.29 What do you mean by flat file database?

Ans: It is a database in which there are no programs or user access languages. It has no cross-file capabilities but is user-friendly and provides user-interface management.

Q.30 Define candidate key, alternate key, composite key.

Ans: A candidate key is one that can identify each row of a table uniquely. Generally a candidate key becomes the primary key of the table. If the table has more than one candidate key, one of them will become the primary key, and the rest are called alternate keys. A key formed by combining at least two or more columns is called composite key.

Core Java - Interview Questions and Answers VOL-II

2012-07-03T19:00:00.001-07:00

Q.1 How can you force garbage collection?

Ans: You can't force GC, but could request it by calling System.gc(). JVM does not guarantee that GC will be started immediately.

Q.2 What is the immediate superclass of the Applet class?

Ans: Panel

Q.3 When is the ArithmeticException throwQuestion: What is the GregorianCalendar class?

Ans: The GregorianCalendar provides support for traditional Western calendars.

Q.4 What is the SimpleTimeZone class?

Ans: The SimpleTimeZone class provides support for a Gregorian calendar.

Q.5 What is casting?

Ans: There are two types of casting, casting between primitive numeric types and casting between object references. Casting between numeric types is used to convert larger values, such as double values, to smaller values, such as byte values. Casting between object references is used to refer to an object by a compatible class, interface, or array type reference.

Q.6 Explain the usage of the keyword transient?

Ans: This keyword indicates that the value of this member variable does not have to be serialized with the object.

When the class will be de-serialized, this variable will be initialized with a default value of its data type (i.e. zero for

integers).

Q.7 What is the immediate superclass of the Dialog class?

Ans: Window.

Q.8 What is clipping?

Ans: Clipping is the process of confining paint operations to a limited area or shape.

Q.9 What is a native method?

Ans: A native method is a method that is implemented in a language other than Java.

Q.10 Can a for statement loop indefinitely?

Ans: Yes, a for statement can loop indefinitely. For example, consider the following: for(;;) ;

Q.11 What are order of precedence and associativity, and how are they used?

Ans: Order of precedence determines the order in which operators are evaluated in expressions. Associatity determines whether an expression is evaluated left-to-right or right-to-left

Q.12 Is Empty .java file a valid source file?

Ans: Yes, an empty .java file is a perfectly valid source file.

Q.13 Can a .java file contain more than one java classes?

Ans: Yes, a .java file contain more than one java classes, provided at the most one of them is a public class.

Q.14 Is String a primitive data type in Java?

Ans: No String is not a primitive data type in Java, even though it is one of the most extensively used object. Strings in Java are instances of String class defined in java.lang package.

Q.15 Is main a keyword in Java?

Ans: No, main is not a keyword in Java.

Q.16 Is next a keyword in Java?

Ans: No, next is not a keyword.

Q.17 Is delete a keyword in Java?

Ans: No, delete is not a keyword in Java. Java does not make use of explicit destructors the way C++ does.

Q.18 Can an object's finalize() method be invoked while it is reachable?

Ans: An object's finalize() method cannot be invoked by the garbage collector while the object is still reachable. However, an object's finalize() method may be invoked by other objects.

Q.19 What is the Set interface?

Ans: The Set interface provides methods for accessing the elements of a finite mathematical set. Sets do not allow duplicate elements.

Q20. Name three Component subclasses that support painting.

Ans: The Canvas, Frame, Panel, and Applet classes support painting.

Q21. What value does readLine() return when it has reached the end of a file?

Ans: The readLine() method returns null when it has reached the end of a file.

Q.22 Is exit a keyword in Java?

Ans: No. To exit a program explicitly you use exit method in System object.

Q.23 What happens if you don't initialize an instance variable of any of the primitive types in Java?

Ans: Java by default initializes it to the default value for that primitive type. Thus an int will be initialized to 0, a Boolean will be initialized to false.

Q.24 How can a subclass call a method or a constructor defined in a superclass?

Ans: Use the following syntax: super.myMethod(); To call a constructor of the superclass, just write super(); in the first line of the subclass's constructor.

Q.25 What is the Properties class?

Ans: The properties class is a subclass of Hashtable that can be read from or written to a stream. It also provides the capability to specify a set of default values to be used.

Q.26 What interface must an object implement before it can be written to a stream as an object?

Ans: An object must implement the Serializable or Externalizable interface before it can be written to a stream as an object.

Q.27 What is the ResourceBundle class?

Ans: The ResourceBundle class is used to store locale-specific resources that can be loaded by a program to tailor the program's appearance to the particular locale in which it is being run.

Q.28 How do you know if an explicit object casting is needed?

Ans: If you assign a superclass object to a variable of a subclass's data type, you need to do explicit casting. For example:
Object a; Customer b; b = (Customer) a;When you assign a subclass to a variable having a supeclass type, the casting is performed automatically.

Q.29 What is a Java package and how is it used?

Ans: A Java package is a naming context for classes and interfaces. A package is used to create a separate name space for groups of classes and interfaces. Packages are also used to organize related classes and interfaces into a single API unit and to control accessibility to these classes and interfaces.

Q.30 How do you restrict a user to cut and paste from the html page?

Ans: Using Servlet or client side scripts to lock keyboard keys. It is one of solutions.