Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am working on an assignment for Java Programing but having a hard time with it, here are the guidlines: 1. Create an employee database

I am working on an assignment for Java Programing but having a hard time with it, here are the guidlines:

1. Create an employee database for a company (define it as someting: an engineering firm, supermarket, call center...) using a class containing information about the employees. At least 5 employees.

2. Employee information should include : employee id, first name, last name, m/f, start date, address, telephone number, social security number, position at the company, and date of birth (which should return an age).

3. Include a query for any piece of information associated with each employee. (EX: searching for employees with last names starting with "D")

4. Include a final option to display all the information about a specific employee.

Here is a database to be used:

Employee Id First Name Last Name Adress Phone # Sex Birth Date Soc Sec No Salary Start Date
102 Alex Ruppert 205 Silver Hawk Ln, Lancaster 98541 NC 658-845-4852 M 07/15/1985 785-28-6985 $52,000 02/14/2015
154 Laurie Jackson 785 Tactcher St, Lemonville 98789 NC 658-854-7854 F 08/08/1980 895-14-5287 $60,000 01/23/2013
132 Daniel Gilker 1258 Straigh Line Av, Sturn 98856 NC 658-874-8523 M 02/29/1970 146-87-2310 $65,000 11/17/2005
187 Robert Paris 235 Blue Apple st Apt#12, Lancaster 98541 NC 120-20-2357 M 03/08/1985 895-45-2541 $50,000 12/02/2016
120 Sylvia Demenoli 123 Leaning Fawn Ln, Smalltown 98854 NC 149-28-9875 F 09/07/1978 258-78-1456 $45,000 07/08/2017

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database Foundations Technology Fundamentals For IT Success

Authors: Bob Bryla

1st Edition

0782143725, 9780782143720

More Books

Students also viewed these Databases questions

Question

Define connectivity.

Answered: 1 week ago