PPT Slide
The second stage of the project was to design a system that would satisfy the specifications. A well thought database schema was created. The database was designed to answer both present and future expectations from the system.
Basically there are three main entities in the database:
- Student: Student relevant info.
- Employer: Info. about companies, their contacts and locations.
All the rest of the data revolves around these three entities and the various relationships between them.
For the purpose of creating the working model Microsoft Access was sufficient. Access can be relatively easily upgraded to a higher level relational database management system when implementing a final production level system.