Plz help me ...Its very urgent

[Sunil Kumar Gupta]

Hi all group members

Plz help me to solve the problem.It's very urgent....

I got a call from a company...They gave me the assignment to complete.. But

i am confued, how to start the solution of this problem......


The problem is


Overview

Our ideal interview process involves working as a pair on some real programming task, but barring that we have come up with a long-distance challenge. This is something new for us, so part of the challenge will be how gracefully we can deal with any surprises. Please give us any feedback you may have.

You are not expected to complete all parts of the challenge described below. We haven't given you a chance to estimate the cost of the various pieces, and we will be looking as much at the style of your program as at its satisfaction of the specification. In particular, we will be looking for simplicity of design, how well the code communicates your
intention, and how complete and coherent your unit tests are.

The only strict requirements are that the code you submit compiles, that the program does have unit tests, and that the all the unit tests are passing.

Please note what development tools and versions you use, and any external dependencies your program requires.


Challenge


Your challenge is to begin development of a back-end system for the Galactic Census. You will be designing and implementing a Java API; you will not be building the user interface.

The specifications have been written on a stack of white index cards. Each card has a title at the top and a few sentences describing what is desired. Your customer, the Galactic Government, has also communicated to you some idea of the value of each card.

Card Title Description Value
Person Data Entry Several persons may be entered into the system. Each person has a full name, date of birth, planet of residence, local address (on that planet), and annual income. Being able to enter this data is critical to the Census.

Person Data Report All the person data in the system may be retrieved at once. The data should be grouped by planet, and ordered alphabetically by full name within each planet. This report will be needed in the future, but is less immediately valuable than the various statistics.

Statistic: Galactic Total The total number of persons in the Galaxy may be retrieved from the system. This statistic is one of the primary goals of the Census.

Statistic: Planetary Total The total number of persons on any given planet may be retrieved from the system. This statistic is one of the primary goals of the Census.

Statistic: Galactic Per Capita Income The average income per person in the Galaxy may be retrieved from the system. This statistic is required by Government economists.

Statistic: Planetary Per Capita Income The average income per person on any given planet may be retrieved from the system. Some university researchers have asked for this statistic.



Plz help me to solve this problem , its a chance for me to explore my career
with this company.....and i dont want to loose this one....


Thanks u people

[David O'Meara]

This sounds too much like a homework assignmnet. I don't like your chances.

[Sunil Kumar Gupta]

Sorry david , i am not clear , what you said

I have to send the Java interfaces, and a brief write-up with assumptions and class-design.

If you can help me to do that..

[Bear Bibeault]

David's point is that this smells a lot like a homework assignment and that we don't do people's homework for them here. We will certainly bend over backwards to help you do your homework, but you must do the work.

Similarly, if this is a test to get a work position... same concept. We won't help you cheat and do the assignment for you -- you've got to put the effort into it.

So why not let us know what you've already come up with? A skeleton of some code that you are having problems with, perhaps?

[Sunil Kumar Gupta]

I am just trying to know from all you experience peoples that , from where i should start to solve this problem....
I dont want a single line of code from all of you... and i m not trying to cheat .


But i am little confused to start with it....

if u can advise me how to move with the solution....

Thanks

[Michael Ernest]

We'll move this to Jobs Discussion.

For what it's worth, I don't like your chances, either, if you're first question is how to get started...

[Sunil Kumar Gupta]

Any one of you have any idea ,how to move towards the solution
of this problem


Thanks

[Sunil Kumar Gupta]

This topic was not related with job discussion.....It is related somehow with the programming challenges.....

Any way

Any one help me to complete this

[Sunil Kumar Gupta]

I think no body is intersted to help to develop a new system.

[Jogi Poonawala]

Read Craig Larman's book on UML and patterns. (Applying UML and Patterns: An Introduction to Object-Oriented Analysis and Design and the Unified Process ) That will give you a good starting point.

HTH

[Kj Reddy]

Originally posted by Sunil Kumar Gupta:
I think no body is intersted to help to develop a new system.

It seems some interview assignment so may be many may not interested to help you directly. If you put your ideas first then people may start correcting you or giving you suggestions.

Good Luck

[Sunil Kumar Gupta]

Hi KJ

I started working on this problem...

I created some classes like person , i am treating it as an object....

But i am confused with this paragraph...

The specifications have been written on a stack of white index cards.
Each card has a title at the top and a few sentences describing what is desired.
Your customer, the Galactic Government,
has also communicated to you some idea of the value of each card.


can u explain me , what exactlly is this paragraph
Once i am able to understand this .. I can proceed next

U gave me valuable sugestions many times

Thanks

[Sunil Kumar Gupta]

I am waiting for ur reply

[Roger Chung-Wee]

Perhaps each card describes something which would map to a class or classes.

[Henry Wong]

Originally posted by Sunil Kumar Gupta:

The specifications have been written on a stack of white index cards.
Each card has a title at the top and a few sentences describing what is desired.
Your customer, the Galactic Government,
has also communicated to you some idea of the value of each card.

can u explain me , what exactlly is this paragraph
Once i am able to understand this .. I can proceed next

The paragraph following the paragraph that you have in question, explains what they want.

Henry

[Sunil Kumar Gupta]

Hi Henry

is it sounds like a JDBC Application?

Should i use JDBC to store information of person and the card
having field like title, description and value.

[p anish]

The specifications have been written on a stack of white index cards. Each card has a title at the top and a few sentences describing what is desired. Your customer, the Galactic Government, has also communicated to you some idea of the value of each card....

This paragraph is describing what the following paragraphs are.It is describing the structure of the following paragraphs.

U can start by creating a person table,planet table,galaxy table then a table relating the galaxy and the planet.
Write some queries to retrieve the data matching the criterias.
Then do the java coding.

[Sunil Kumar Gupta]

Thanks anish

I have already created tables like perosn, planet and Galaxy..

The fields in Person table -name, dob, planetID( reference of Planet table), localaddr, annualIncome

The fields in planet table- planetID, planetName, totalPersons

The fields in Galaxy table are - totalPlanets ( only one)

Is it a right structure to move ahead to work with the solution

Thanks

[p anish]

U check what all problems u can solve using the table structure and what all u cannot.If u r sure u can solve all the problems then proceed, otherwise change the table structure to include that changes also.

[Dino Velvet]

Originally posted by Sunil Kumar Gupta:
Hi all group members

Plz help me to solve the problem.It's very urgent....

I got a call from a company...They gave me the assignment to complete.. But

i am confued, how to start the solution of this problem......

1) It's urgent for you, not for us.
2) If you're "confued" now, what will you be like as a full-time employee? You'll be "confued" even more (and annoy the hell out of your colleagues with constant spoon feeding). My advice? Quit while you're ahead.
3) You have posted 5 times with the same "plz help me thx!" theme over the past few days - with 4 of those in the past 24 hours. Many ranchers find you very annoying.
4) There are better people than you without jobs - remember that.
5) As it happens, I think the exercise is quite easy. Just for fun, I came up with a clean solution with some diagrams and wrote the interfaces. You seem to have totally misunderstood it by going down the JDBC route. If you find this difficult, I think you may struggle career-wise.

Good luck - it looks like you will really need it.

[Mark Herschberg]

"Dino Velvet",

Welcome to JavarRanch.

Please look carefully at official naming policy at Javaranch & reregister yourself with proper first & last name, with a space between them. Obviously fictitious names are not allowed. Please adhere to official naming policy & help maintain the decorum of the forum. The naming policy can be found at http://www.javaranch.com/name.jsp

--Mark