Building stand-alone and online e-pharma product

So hello there!

Hope you have at-least begun to think that you can program if you want to.

Now, honestly I will not cover the basic basics on my blogs, reason being there are many resources available online, fool-proof and have been published with much research. Get hold of them.

Google as many materials you can.

But what I am trying to do is to build practical applications with you using those basics. What i will do is give you a road-map on how to go through the basics.  

How to go about Basics:

Do you read novels? Like when I was reading The Bible for the first time, i couldnt understand much. So  I read it abstractly for the 1^st time and did not try to understand it deeply. But the 2^nd time it made more sense because I knew what was coming. Now it makes more sense each time. 

Likewise, in any subject, go through the basics and their examples abstractly – 1 full cycle of contents. Then get deeper on your 2^nd read and so forth.

PRODUCT GOAL: We are going to make “e-pharma” system . This system will capture all vital business transactions of an independent pharmacy. When I say independent pharmacy, I am talking about a  pharmacy which is not a sub-unit of any hospital and where you don’t need to register yourself as any patient to get medicines but you can simply buy them on legitimate medical prescriptions.

PRODUCT TYPES:

1.      Stand-alone e-pharma

2.      Online e-pharma

Stand-alone e-pharma: 

In Stand-alone applications you have database on your own personal system, your system acts like server and client. (Please see my post on simple java app, to understand server and client architecture, also google other resources too to understand it).

In standalone system, your database (tables, information) , is stored in your own system. All the Screens to store information are run on your personal PC without internet.

We will use Swing, JDBC and MySQL to build standalone.

Web/Online e-pharma: Here all your information is not necessarily stored on your personal system, it could be stored on a remote server and you could be calling them through your personal system, like online booking.

We will use Servlets, JDBC, java, JSP, Spring, Hibernate to build online e-pharma.

Helpful links to learn the basics of these languages:

JAVA:

http://docs.oracle.com/javase/tutorial/

http://www.freejavaguide.com/corejava.htm

http://goo.gl/yvNI31

Apart from them, I personally really like Java for Students by Ajay Pherwani. You don’t have to be a student to buy this book neither feel that you are too old to read it. I personally used this book to start with java and now use it time and again to brush up my basics.

MySQL and RDBMS

http://www.mysqltutorial.org/

Google and download different PDFs and PPTs to understand RDBMS, (Relational Database Management System).

Like wise google as many. I  personally use the book “The Complete Reference MySQL” .

JSP (Java Server Pages)

Google as many links as you can.

Book - Complete Reference, TATA McGraw Hill.

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

Make a plan and go through them abstractly for 1^st time. Don’t get discouraged if you don’t understand. I personally did not understand them for first time even though I am an IT graduate. So don’t get discouraged, but practice and get deeper each time you read and practice them.

ROAD MAP to building e-pharma:

Database Designing is common for stand-alone and web e-pharma, so we will use 1 database for both the systems.

So our 1^st step would be to design Database for e-pharma.

And the second step, would be to create screens for both – stand-alone and web e-pharma.

So get yourself prepared to build a real system. My next blog is on e-pharma database designing. We will be creating an RDBMS (which you will find out if you go through the tutorials I have recommended or else google it).

Following database design, will be designing transaction and Master screens (I will explain the difference in upcoming blogs).

Thankyou.