Home » SQL & PL/SQL » SQL & PL/SQL » Employee database programme (10.2.0.3.0)
Employee database programme [message #401656] Wed, 06 May 2009 00:06 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member


Hi,
Pleas find the following requirement and give me your ideas.

The following information about each employee must be maintained in an employee database (i.e. a
collection class).
firstName A String.
lastName A String
SSN A String.
job Enumerated type with values: programmer, mechanic, secretary, clerk.
hourlyRate A double.
years An int that represents the years with the company.
deleteFlag A boolean.
Your program should provide the user with the following options.
ADD: The program should allow the user to enter a new employee record. By default the deleteFlag is set to false and the years field is set to 1.
DELETE: The program should allow the user to select an employee record to be deleted.
Records are deleted by setting the deleteFlag to true.
LIST: The program should allow the user to list all the employees, including the deleted
employees. However, the program should indicate in some way which records are deleted.
EDIT: The program should allow the user to select a record and edit any of the fields of the record.
This program needs to have some type of graphical user interface (GUI). What features the GUI
has, how it is designed, and how many classes the program uses is your decision.

Thank you
Re: Employee database programme [message #401657 is a reply to message #401656] Wed, 06 May 2009 00:07 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
user71408 wrote on Wed, 06 May 2009 07:06


Hi,
Pleas find the following requirement and give me your ideas.


My ideas?

For the zillionth time: do your own work!
Do you really expect us to design this for you?
Re: Employee database programme [message #401659 is a reply to message #401656] Wed, 06 May 2009 00:12 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Messages: 492
You choose to ignore Posting Guidelines, we choose to ignore your post.
Re: Employee database programme [message #401662 is a reply to message #401656] Wed, 06 May 2009 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Frank wrote on Wed, 06 May 2009 07:07
user71408 wrote on Wed, 06 May 2009 07:06


Hi,
Pleas find the following requirement and give me your ideas.


My ideas?

For the zillionth time: do your own work!
Do you really expect us to design this for you?

BlackSwan wrote on Wed, 06 May 2009 07:12
>Messages: 492
You choose to ignore Posting Guidelines, we choose to ignore your post.

I concur and add my vote to both posts.

Regards
Michel
Re: Employee database programme [message #401729 is a reply to message #401656] Wed, 06 May 2009 04:50 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
In addition to agreeing with the previous posts, I'd add two design comments:

1) Make Job a Fk link to either a JOBS table or to a reference data table, rather than an Enum - that way you don't need to change the app to add another job.

2) Replace Years with and Employment_Start - that way you don't need to update the reccord every year to keep the value correct.
Re: Employee database programme [message #401752 is a reply to message #401656] Wed, 06 May 2009 06:16 Go to previous messageGo to next message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
Also plus one from me, it would also appear that you are back doing homework assignments. Did one of your previous posts not say that you have found 'gainful' employment? hmmm...
Re: Employee database programme [message #401799 is a reply to message #401752] Wed, 06 May 2009 08:09 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
When they found out he didn't know how to do anything on his own, they immediately fired him.
Previous Topic: How to fast insert table
Next Topic: ROWID differences
Goto Forum:
  


Current Time: Fri Dec 06 23:07:56 CST 2024