Monday, September 24, 2012

Window application for Medical Shop

Another project idea for you, & it is Medical shop application.

It has to be a windows application since only the shop will access it.
You can create it using C#.NET or VB.NET.

So what are the problems in the old system?

  1. Shop have to put it in the proper place & remember every time how much it is remaining.
  2. Shop have to calculate the bill of the customer.
  3. The shop may search the required medicine for 2-5 minutes & later will say that stock is finished now.
  4. The shop owner has to write details on the bill for the customer.
So what will the new system contain?
  1. A database storing all the Medicine details such as Medicine Name, ID, Place where it is stored, Cost, Stock available, etc.
  2. The shop owner will only enter the name of medicine & he will get all details about it.
  3. After adding all medicines of customer shop owner will calculate it through application only.
  4. Bill will be generated automatically.
  5. It will automatically decrease medicine counter whenever a medicine is bought.
So what are the advantages:
  1. Don't waste time for searching the medicine
  2. No need to write a bill, it is automatically generated.
  3. Work done is at the faster speed.
So you have 2 ways to do this:
  • Windows application with VB.NET
  • Windows application with C#.NET

Saturday, September 22, 2012

Train ticket reservation


A new idea, but its kinda old as I know.
This can be Web-based i.e ASP.NET using C# or VB.

Front end: - ASP.NET with VB or C#
Back end: - MS Access or any database language
You know the problems in ticket reservation for Train that are
  1. You have to go to at specific places for getting tickets.
  2. There is a big queue for getting tickets (Wastage of time).
  3. You also don't know that if there are tickets available or not.
  4. You are in the queue for hours & tickets not available is again wastage of time.
  5. Mumbai is known for people who don't have time & this wastage is not allowed.
So here's the good project idea since it is the actual scenario everywhere.
So what project should actually have?
  1. The basic step is registration of the user, which no one has to forget & then logging in the system.
  2. Users need a colorful, attractive & user-friendly pages, with which they will interact.
  3. Forget the old charts of Trains, make a colorful, user-friendly table showing Train details.
  4. A form where the user can book a seat for himself/herself & can pay later by going at the office or can pay at the time by using his/her credit card.
  5. A database containing train details such as, Train ID, Train Name, Train Route, Arrival & Departure time of Train, Break points in route, etc.
  6. A database for the registered user containing the username, password, contact info., etc. is displayed.
  7. When the user clicks specific a train, a record of remaining available seats is displayed.
After this what are the advantages of this system?
Then following are advantages: -
  1. You can book tickets anywhere in the world.
  2. You can also check if tickets are available are not before going to check out.
  3. Credit card facility is also available.
  4. Information provided is very fast.
  5. Assurance of data consistency.

Here you have two options:
  1. ASP.NET with C#
  2. ASP.NET with VB

A College Forum


It can be a web based i.e. ASP.NET with VB or C#

Front end: - ASP.NET with VB or C#
Back end: - MS Access or any database language

It is a forum for students of same college & teacher to get connected with each other through internet.
It will provide:
1. There will be various sections such as IT, Mechanical Engg., Electrical Engg., Instrumental Engg., Commerce, Arts, etc. for each type of question to ask.
2. A student can register with his/her College ID & then can login the website. (You can make it available only for college students or anyone in the world. Since if your college is having expert teachers, others might want to know something from them so they can ask too.)
3. A student can also help other students to solve their problem.
4. Anyone can also ask questions that are not related to subject (in Others) section, such PC spec questions, PC problem & fixing solutions, Other configurations, etc.
5. Database for Student records such as College ID, Password, Mobile No., Email ID, etc.
6. Database for Teacher records with Teacher ID, Password, Contact details, etc.
7. Database for Forum List, Categories, Topics, etc.



This is maybe or may not be complete.
If found something new will add later.

Sunday, September 09, 2012

Employee database


It can be a windows based i.e. VB.NET or C#.NET project or web based i.e. ASP.NET project.

Front end: - VB.NET, C#.NET or ASP.NET
Back end: - MS Access or any database language

For Windows based it is only accessible from company & for web based it can be accessible from anywhere.

In this what you have to do is:
1. Employee can register & login by entering his/her employee id & password(maybe given by admin or created by himself).
2. It will contain database of Employees with unique employee id for each employee with their address, phone no. or mobile no., email id, post of employee, department name, etc.
3. It will contain database of Employee attendance as per their employee id, name, monthly attendance in company, etc.(For added difficulty you can cut salary if employee's attendance is less than 75%)
4. It will contain database of Employee salary database with their join date, current salary, no. of promotions, salary increase over time.
5. It will contain database of student fees with roll no., balance fees, fees paid, etc
6. In this user can check his/her attendance record, check salary he/she paid, change his/her information.

It is enough information for thinking this project & it is available in both ASP.NET or VB.NET or C#.NET so you have four choices to choose for this project.
1) VB.NET
2) C#.NET
3) ASP.NET with C#
4) ASP.NET with VB