Project Highlights (VB Application)
N-Tiered Architecture
The project was implemented using an N-tiered architecture. A graphical view of this architecture is as follows:
The User-Interface Tier included the Visual Basic application for administrative data-entry and support forms. It also
included a set of web pages for browsing job openings and submitting requests for interviews.
The Services Tier consisted of components for managing the business rules. This tier also contained Active Server Pages
for dynamically creating the web pages shown in the User-Interface Tier. The Services tier allows changes to be made to the
business rules and web pages without affecting the User Interface or the database.
The Data Tier was consisted of an Access 97 relational database. ActiveX Data Objects (ADO) and SQL statements were used
to access the database.
Companies Form
The Companies Form displayed to the user the names of existing client companies in the agency's database. When a particular
company was selected the user was presented with all of the information pertaining to that company. This form also provided
the user with the opportunity to edit or delete existing company information, or to enter new company information.
Positions Form
The Positions Form was the most intricate form in the application, displaying to the user both the client companies and
their associated position opportunities. When a company was selected, the corresponding positions for the company were displayed
to the user. Once the user made a selection from the positions list, the corresponding information was displayed on the form.
The user was then given the option of editing or deleting existing position information.
Applicants Form
The development of the Applicants Form exceeded the requirements put forth by the agency for the application. It displayed
to the user a list of applicants along with their corresponding skills. When the user selected an applicant from the applicant
list, personal information for the applicant was displayed on the form. The user was also given the option of deleting an
applicant from the list.
Skills Form
The Skills Form displayed to the user
the list of industry skills in the database. The user was also given the option of adding a skill to the list.
Web Site
The placement agency's web site basically consisted of a set of Active Server Pages that enabled job seekers to view available
positions and request interviews on-line. The initial web page provided the user with a list containing company names and
the employment opportunities each had to offer. Once a particular position had been selected the user was given the option
of viewing the information for that job. Authorized users were also given the option of viewing company information regarding
a particular employment opportunity
.
ERD
The design phase required a completed and fully resolved ERD which was to be created in Access
97. This ERD describes all the relationships between the entities of the database.
