Certification Reynold Guitar Shop

This is to certify that the requirement as expected from Abhitosh Daw for Reynold Guitar Shop has been met upto satisfactory standards.

ZOHO APP FOR REYNOLD GUITAR SHOP

TO : 12BM60078

HI ABHITOSH,
I AM POSTING THE REQUIREMENT OF AN APP BELOW. PLEASE REVERT BACK ACCORDINGLY.
THANK YOU.

ZOHO APP REQUIRED FOR THE GUITAR SHOP

SHOP NAME :  Reynold Guitar Shop

DESCRIPTION: Reynold Guitar Shop is a national level guitar dealer, primarily acting as retail units for world-known guitar makers like Fender, Ibanez, Pluto, Hobner etc.

REQUIREMENTS : With rapid rise of users preferring online shopping, Reynold is planning to introduce a similar online guitar ordering platform wherein the customers will be provided with facilities like Cash On Delivery and Feedback trackers.

MODULES :

(1) Purchasing new guitar : 
The customer must be provided with options between Electric and Acoustic guitars. Under Electric guitar category there should be 2 options, Fender and Ibanez/Pluto and Hobner. On selecting any of the options, the model name and price must apprear. Customer must be given a form to enter basic details ( name, shipping address, email, phone number ) and after the customer clicks on the BUY button, an email notification must reach the customer.

(2) Feedback Form :
The customer must be given the option of giving feedback on the delivery service, the quality of the guitar, need for servicing the guitar etc. In case customer wants Reynold to keep stock of some other guitar makes, there is also provision for providing the same. All these feedback data will be tracked and based on the research for demand of new products, Reynold will also consider keeping stack of the products in demand.

IMPORTANT POINTS TO BE TAKEN CARE OF :

1. The app must be user friendly with an easy GUI.
2. Mandatory fields should be set carefully so that user related data can be tracked, for example, shipment address, customer name etc.
3. On selecting guitar type ( Electric / Acoustic ) and then the guitar make ( eg. Fender ), the Model and Price fields should get auto-populate.
4. There must be a valid user verification implemented in the buy new guitar form.
5. In the buy guitar mail notification, the help desk contact number must be mentioned along with other product details so that the customer can track the order placed.

ZOHO APP FOR 'VGSOM CLUBS AND COMMITTEES'

MY CLIENT : 12BM60072
ANSWERING AS PER THE CLIENT REQUIREMENT.

ZOHO APP FOR VGSOM CLUBS AND COMMITTEES

Client :  

VGSOM STUDENT CLUBS AND COMMITTEES 

Client Description: 

Clubs and Committees in VGSOM (Vinod Gupta School Of Management) are student run bodies which are responsible for various academic, non academic, cultural, corporate & media interaction, social responsibility and voluntary activities and events. 

Client Requirement: 

An application supporting collection(registration) of data of the students interested in various clubs and committees must be created. It should be incorporated with the basic introduction/information of all the clubs and committees. Also, an option of presenting the preferences should be incorporated (in case of applying to more than one club or committee).

Modules :

1. HOME 
   A basic introduction about VGSOM (Vinod Gupta School Of Management) IIT Kharagpur.
2. CLUBS AND COMMITTEES
   A basic introduction about various student run clubs and committees in VGSOM along with enlisting all of them.
3.  REGISTRATION & PREFERENCE FORM
   -A basic input form containing input fields named : NAME, ROLL NO. EMAIL ID.
   -Present options of selecting multiple clubs and committees. On selection of a particular club/committee, present an option for input of preference ranking and another option for SOP/ 'Why joining ?' for that particular club or committee.
4. UPLOAD RESUMEA link to upload the applicant's resume either from local computer or from google docs. 

Once submitting the form these data should be available to the administrator and a successful registration mail must be sent to the applicant.

Points to be noted :

1. The app must be user friendly with an easy  GUI.
2. Mandatory fields should be set carefully so that user related data can be tracked, for example, name, roll no, email id and resume.
3. On selecting a club/committee an input option for SOP(statement of purpose) should get auto-populated.

PREPARED A ZOHO APP AS PER THE CLIENT REQUIREMENT

SUBMITTED BY : HITARTH SAINI

ROLL NO    : 12BM60077

LINK TO THE APPLICATION

To access the zoho app please click here :
' VGSOM CLUBS AND COMMITTEES '

USER MANUAL GUIDE

1. A simple self explanatory form to be filled according to one's preference and interests. Once submitted an auto generated mail is send to the applicant's mailbox (address submitted during form completion).
2. A snapshot series of the whole process has been provided below.

STEP 1 
(STEP 1-5 FOR TARGET GROUP.) 

HOME PAGE OF THE APP

STEP 2

INTRODUCTION TO VARIOUS CLUBS AND COMMITTEES

STEP 3

REGISTRATION PAGE

STEP 4

FILLING THE FORM

STEP 5

UPLOADING THE RESUME AND SUBMITTING


STEP 6
(STEP 6-10 FOR CLIENT/ADMIN)

LOGIN TO ZOHO APP (USERNAME-PASSWORD WITH CLIENT)

STEP 7

ACCESS THE TAB 'REGISTERED' TO GET DATA

STEP 8

LIST OF DATA COLLECTED FROM FILLED FORMS

STEP 9

DETAILS OF FILLED FORMS IN DIFFERENT VIEWS

STEP 10

FROM THE LINK IN RESUME FIELD DOWNLOAD THE FILE

AUTOMATED REPONSE

EVERY REGISTERING STUDENT GETS AN EMAIL RESPONSE LIKE THIS IN HIS/HER MAILBOX.

A Weekend of Pure EXUBERANCE..!! :)

7.50 pm, Friday
With excitement pumping in our veins & imaginations flashing in our minds, we pedalled harder towards VGSOM building and reached just in time. Our seniors had called us for the orientation meet. With around 150 people in a single room, the uproar seemed to reach a new level of craziness. All of us were divided into 7 groups of 10 people & finally the games began. A selected person from the group had to dance and others had to imitate the same and it was mesmerizingly entertaining. Then again a selected person from each group was called to pick up a chit in which name of a celebrity was written. The person was supposed to imitate the personality and act likewise while others guessed the name and then asked whatever questions came to their minds. It was a very hilarious event as we were joyously lucky to have personalities like Sachin Tendulkar, ACP Praduman, Sunny Leone and Dr Sheldon Cooper. After that a girl from each group was decorated using many straws and then made to ramp walk on the track 'womaniya'. With lots of other exciting events, the session ended at around 2 am and we were asked to come tomorrow morning at 9 am being prepared with our cycles and our strengths.

10.00 am, Saturday
Each team was assigned a coordinator and we were given a sheet of paper with 10 riddles. We had to decipher the code (name of some places inside kgp campus) and together as a team visit the place and snap a photograph of our group there. We had a time limit and the team to complete this challenge first would be the winner. It was the most adventurous event since we discovered & visited many places after a lot of brainstorming & a great team participation. Then after we were introduced to activities of various clubs each of which kept us engaged throughout the day. We played dumb charades, we had to act out a given situation, we had to promote an imaginary product in an advertisement and solve many quizzes & case studies. To sum up, it was a great day to test our abilities but not in conventional ways, rather tremendously fun filled and superbly exciting events.
We had presentations of various clubs and committees the next day with many more fun filled events. We thank our seniors from the depths of our heart for such a wonderful orientation session.
 
 It was a weekend which left a legacy of beautiful memories in many minds. Maybe two years, or five or even ten years from its occurance it will surely be remembered by students of VGSOM, (batch 2013 & 2014) and would definitely bring a smile on their faces. It would be the topic when in future, two CEO's of big corporates would meet in some party and remember about the time they were introduced to the family VGSOM. It would be a flash of a memory for someone far off in a distant land, fixing deals with big clients, and would make him/her wonder how life has changed in its complexity & pace and would definitely make him/her go back in time and repeat it from the very same weekend.

THE KHARAGPUR DIARIES..!! :)

After the tiresome day of attending various lectures and sudden surprise meetings from seniors about various clubs and committees I was literally dragging myself on my cycle. Every muscle in my body was shouting and cursing me -why the hell you got accustomed to an easy life with lots of comfort, enjoyment, an AC and a motorcycle...!! After almost eight years of being in the comfort zone, thanks to the vast expanse of IIT-Kgp campus, I had no choice but to ride a bicycle. All my old buddies whom I told about this mocked me saying : You would wear a suit and ride a cycle..!! chhh chhh..!! POOR YOU..!! But this is how it is here in Kharagpur. I pedaled harder convincing myself that with all the sultry environment, sticky-itchy-humidity and every kind of insect and a hybrid-alienated-specialized horde of mosquitoes, with all its struggles and all the tests of patience, still this is the place which will give thrusts to my wings, which will be the beacon of light on a dark night. After parking my cycle, I ran to the MMM hall mess for the whatever quality food I was about to eat in dinner. As usual, I had to stand in the line for some time to get my plate filled in and then sat down to dine. Even with the whole family of Einstein's cats scurrying here and there, nibbling at the drop overs of our food, students manage to somehow like and adapt to this mess environment soon.
Fininshing my dinner soon, I headed to my room at fourth floor. Again my legs screamed, 'what kind of slavery is this ??', but there was no option to complaint. Though my mom had adviced me to complete my assignments on the day it was allotted, but being a proud 'jugaadu' engineer by heart, I postponed this for tomorrow (and yeah, of course, tomorrow comes when the deadline is very close.).
After the daily shower, I had just a few mails to check and of course the 'daily calls' to make and I dropped dead in my bed being exhasted with the whole day's schedule.

"KNOCK KNOCK"

"KNOCK KNOCK"

"KNOCK KNOCK"

Who is banging the damn door..!!

Let him bang like a mad man, I wont go and answer it.

"KNOCK KNOCK"
"KNOCK KNOCK"

The noise seemed to be like war drums in a battlefield. It reverberated in my head causing me peak of irritation and with cursing the person creating it, I stood up and opened the door.


To my surprise there was an old man in his late 50's, standing there with a pleasant smile below his white moustache and a sparkle in his eyes . Wait a minute; I have seen him somewhere; Who is he ?; He seems familiar; Where have I seen him; Oho..why do I forget people so soon..??

He replied in a composed and a gentle voice "Sorry to disturb you at this time son, but I have something important to tell you. May I come in ? "

"Yes please, never mind. But I am really sorry to say this, I dont recognize you. May I know who you are ??"

"Thank you for letting me in. We met today in the afternoon, in the MIS class or as I say the BIS class and a day before that in the orientation session. I am your professor and the T&P head, Prithwis Mukerjee."

To my surprize, I was dumbstruck for a moment, I really could'nt make any sense of what was happening. I looked for time in my mobile phone and again to my utmost surprise the screen displayed : complete your assignment 1 of Business Information Systems on Systems Architecture. I thought what the hell has happened to me ? Was there something* mixed in today's food or did the water cooler filled my bottle with something* else..!! 

Again with a very pleasant smile, Sir said : "No need to worry, Even I was a student like you in the very same place many years ago. The same thing happened to me when I was a student like you. This is a sign of your mind adapting to the pressure that every student experiences here. I am here just to help you remember what you have already studied today. Everything is stored in your brain cells, we just need to organize them and logically connect them so that you can learn this permanently. "

Then it struck to me, OMG and before I could imagine, Sir transformed into 'Morpheus' from Matrix, 

and held out both of his hands,one containing the BLUE PILL and the other the RED PILL and smiled : "Feeling like Alice..?? Tumbling down the rabbit hole ?? This is your last chance. You take the blue pill, the story ends, you wake up in your bed believing whatever you want. You take the red pill, you stay in wonderland, and I ll show you how deep the rabbit hole goes. We complete your assignment right here, right now..!!" 

I thought what the heck..!! I ll go for the red pill and get my assignment done without much effort..!! I picked up the pill and swalloed it. The very next moment, I was teleported to the VGSOM main building, room no E 101. I am the only student sitting and Prithwis sir started the slideshow. "I started my career handling data. Basically I am a programmer by heart and as a future manager Hitarth, you need to learn about various methods and systems how data is managed since you are going to deal with a lot of data in future.
The first thing that you should remember is : that data needs to be logically distinct from applications. Data is arranged and stored in a database and it describes what one measures or deals with. Application is a program, which is a method specifying how to use the data.

Now today's class is about integrated systems which are different computing systems and software applications linked together physically or functionally to perform in a coordinated manner.

 

Now the first kind of system is a SINGLE TIER INTEGRATED SYSTEM : in which the data and the application(PL-Presentation logic & BL-Business logic) are on the same physical hardware. For example : laptops, desktops, servers etc."

 

 "As the name is suggesting there must be double tier or triple tier systems sir ...?? "

" Very well thought Hitarth. But I ll correct you here.The second kind is called the TWO TIER CLIENT SERVER ARCHITECTURE : in which data is stored in a different location and the applications to access it in another. They are connected by various LAN cables.Client-server architecture offers both operational and performance advantages. First, it better accommodates the decentralized business environment; business logic resides and executes where it is more appropriate: on the end-users' desktops. Enterprise-wide data is integrated and managed by the server. Second, it offers a cost effective solution that allows for increased performance due to load balancing and better resource utilization on both desktop and server computers, and scalability and growth to more clients and new client application software.But the demerits are its high bandwidth requirements and maintainance/version control of the software. 

The two-tier client-server architecture evolved into the THREE TIER ARCHITECTURE when the need arose to support more complex applications. The three tiers run only the user interface on the end-user computer, an application server that runs the business logic and processes the data is differently located, and it accesses the database server."

"Then there are MULTI TIER ARCHITECTURE : This means splitting a system into more than just a client layer and a database layer. Instead, we have the clients, and they only deal with presenting data to the user and sending changes back to the server. The server then takes care of the business logic, and gets and returns the raw data to one or more database servers. The advantages are better maintainability (business logic can be changed without updating every client machine)."

 "Okay sir, so now all the system architectures have been completed, is there anything else I need to know.??"

"Now we'll talk about RDBMS. RDBMS stands for Relational Database Management System. RDBMS data is structured in database tables, fields and records. Each RDBMS table consists of database table rows. Each database table row consists of one or more database table fields.

RDBMS store the data into collection of tables, which might be related by common fields (database table columns). RDBMS also provide relational operators to manipulate the data stored into the database tables. Most RDBMS use SQL as database query language.

Another important aspect which is vital in most business systems today is the ERP systems. Enterprise resource planning (ERP) systems integrate internal and external management information across an entire organization, embracing finance/accounting, manufacturing, sales and service, customer relationship management, etc. ERP systems automate this activity with an integrated software application. The purpose of ERP is to facilitate the flow of information between all business functions inside the boundaries of the organization and manage the connections to outside stakeholdersERP systems can run on a variety of computer hardware and network configurations, typically employing a database as a repository for information The transformation of ERP into a cloud-based model has been relatively slow, but as cloud computing makes other inroads into the enterprise environment some functionality is being moved to the cloud.

A Wide Area Network (WAN) is a telecommunication network that covers a broad area (i.e., any network that links across metropolitan, regional, or national boundaries). Business and government entities utilize WANs to relay data among employees, clients, buyers, and suppliers from various geographical locations. In essence this mode of telecommunication allows a business to effectively carry out its daily function regardless of location. "

 "That was a great session sir, I wish these red pills are available in wholesale so that it becomes quiet easy for students to learn and understand topics like these. I would like to ask sir, is there some other coloured pill which can be taken in exam time to perform better ??"

"Ha ha ha, I am sorry Hitarth, I cant tell you that. But since you have been with me throughout the session so patiently, I appreciate this and as a bonus would tell you something that would help you in forthcoming examination."

And just when Sir was about to take off the curtains from the suspense, guess what..?? MY ALARM WENT ON RINGING LIKE ITS ARMAGEDDON..!! Though my body was aching from head to toe, I started my day with a wonderful smile, remembering what kind of strange dream I had last night.

DISCLAIMER : If unknowingly I have hurt someone's feelings, I am truly sorry and assure you that I wrote down this post with due respect to my teacher,my institute and the God Almighty.

HAPPY INDEPENDENCE DAY..!!!

Some 400 years ago, a group of traders came to the land of the most ancient civilization, the land of the Dravidans, conquered by the Aryans, ruled by the Mughals, loved by the Marathas, 'karma-bhoomi' of the Sikhs & refuge for many others. The land famous for its wealth & prosperity better known as The Golden Sparrow.!!     The traders were disguised & due to our morals & principles of 'atithi devo bhava' we did'nt see the darkness they carried within.  They ruled us for 200 years; they made the brothren fight amongst themselves by their policies like 'divide & rule'. They looted the riches of our motherland, caged The Sparrow that once soared high in the skies.!!      Our innumerable sacrifices, our struggles & because of our martyrs, we made The Mother India free. Although we learned a bitter lesson but our wounds were still open.      Let it be known to all that The Sparrow has now transformed into a fierce Eagle, soaring again.!! To rule the skies; to measure the heights not yet imagined ; to be entitled as ''The Golden Eagle''.!!      After about 60 years of independence, an entrepreneur, an Indian belonging to the land of 'Shri Dwarkadheesh' (gujarat), decided to prove the world our might, our power, our determination.     'Mr. Sanjiv Mehta' bought the infamous East India Company & relaunched the same in 2010. He's recreated history, to show that our principles of ''forgive & forget'' have changed to ''forgive, but dont let the forgiven forget''.     Hats off to Mr. Sanjiv Mehta to create another success story for entrepreneurs, for revolutionaries, for our countrymen & for the generations yet to come.

MR. MOHIT SARDANA

This is the most auspicious way i thought to start writing my blog.
By writing about nobody else than my idol MR. MOHIT SARDANA JI.

To describe him, i am very sure i ll face scarcity even if all of the adjectives ever used to describe a LEADER, a PERSONA UNBELIEVABLE, an ENTREPRENEUR, & moreover a GREAT HUMAN, are used by me all at once.

He is the one who's responsible to change lives of lacs of youth in INDIA.
He's the one who commands respect & love for having touched hearts of millions of people across globe.
One of the biggest source of inspiration ever i have witnessed till date.

He completed his engineering like millions of other students in our country do, and found himself standing on a financial crossroad where he could have opted for a very good job or continued his family business.
but as they say:
"Two roads diverged in a wood, and I-
I took the one less traveled by,
And that has all made the difference."

He also chose a path less treaded, and plunged into deep ocean of Entrepreneurship. He knew and always believed that some difference has ought to be created to change the existent scenario of 'job madness'(i will elaborate it later.) if we want our nation to develop.
He knew that entrepreneurship is not too much supported generally by our society but someone had to take the lead.
He started his mission of creating leaders & entrepreneurs & business people all across the nation, spreading his message to the youths as : "DONT BE A JOB SEEKER, BE A JOB CREATOR."
The journey till he accomplished his few dreams had been no doubt very adventurous (as they say..if it's a success story its never smooth) but today this gem of a person is known as a few who have reached to heights ever imagined.(and believe me friends, he's enjoying the vistas from there).
He got nominated as 'THE YOUTH ICON'(by an sms poll by Navbharat times),
got the award 'BHARTIYA UDYOG RATNA'
and the legacy continues.
He is responsible for creating leaders who have brought laurels to our society & their families by achieving those things which others dont even dare to dream.
Well as i said..it will never be enough and i'll never get tired of writing about him but to know more about him,
search google, youtube or visit his website:www.mohitsardana.co.in
I will always be thankful to God for blessing me an idol like him.