From arluty@cs.washington.edu Tue Nov 11 19:02:00 1997
Date: Mon, 10 Nov 1997 14:26:00 -0800 (PST)
From: Andrew Luty <arluty@cs.washington.edu>
To: dickey@cs.washington.edu
Subject: Project proposal: Job Search & Networking Database


Project Proposal: "Job Search & Networking Database"
Submitted by: Andrew Luty, arluty@cs.washington.edu

Job Search & Networking Database

OVERVIEW:
	Finding a suitable job can be a time consuming process.  What is
needed is a means of matching up companies and positions with students.
This project would consist of a database filled with information to help
students in finding jobs.  It will facilitate the task of gathering and
assimilating information from a variety of companies by organizing
information from various companies in one convenient place.  The intent of
this project is to provide students with a useful resource for finding
jobs.
	This project can be implemented for Windows 95 and NT using
Microsoft Access and may include a web based user interface.  When this
project is completed, it could be given to the UW engineering co-op
program for the benefit of students in this department.  (The UW
engineering co-op program does not currently have such a database - at
least not one available to students.)  Also, the project could be made to
fit on a floppy disk for distribution to the entire class.
	A user would be able to query the database to find out
information like:
* companies in a particular geographic area
* who has worked for a particular company (so you can ask them about their
work experience)
* a particular company's web page URL (so you can read up on a company
before an interview)
* high pay companies :)

SPECIFICS:

Entity-Relationship model for this database: These are the types of
information that might be in the final database.  This model is just meant
to be a suggestion, the final implementation may differ.

Entities in the database might include:
* COMPANY (name, location, phone, URL, size, work-environment, etc.) =
place to work
* CONTACT (name, position, phone, fax, e-mail, etc.) = who to get in touch
with at a company
* STUDENT (name, major, contact information, etc.) = who has worked or is
working at a company
* PRESENTATION (company, date, location, etc.) = where to go to find out
about company (job fairs)
* POSITION (title, description, available, deadline, etc.) = specific
opportunity at a company
* LOCATION (city, state, county, climate, etc.) = for use with geographic
preference queries
  Other information might include INTERVIEW - information about what to
expect and what is asked during interviews, BENEFITS - health plans,
vacation time, etc., and anything else someone might want to know about a
company.

Relations in the database might include:
* CONTACT-FOR relates a companies and contacts.
* WORKS-FOR relates students to companies (company, begin-date, end-date,
pay)
* HAS-POSITION relates a position to a company

Sources of information:  Initially, the developers of this database would
enter information into this database.  After the project is completed,
administration of the database could become the responsibility of the UW
engineering co-op program.
  The information that must be entered into this database and the sources
of this information include:
* COMPANY - initial information entered based on data in company brochures
from job fairs (which most of us have), and company web pages; new or
additional data could be entered by companies themselves via web page
forms.
* CONTACT - entered by the company or by students that have contacted the
company before
* STUDENT - personal data submitted by students in this class and maybe by
other students in the department via web page form (possibly anonymously)
* PRESENTATION - entered by the co-op program or whoever handles company
appearances on campus.
* POSITION - entered by companies or by the co-op program as positions
become available or filled.
* LOCATION - entered by database administrators; this may be qualitative.

Additional Notes: The database could also be adapted for personal use
(i.e. for a student to keep track of companies contacted or when and where
resumes were submitted.)