Database Answers Student Data  Management (Click for Wikipedia Web Site)

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Student Internships   
Back to the Data Model.
The Area being Modelled is :-
Subject: Student Internships Tracking System

Question: • Student Internships Tracking System: 
You are asked to design a data management system for automating the tracking of summer 
internships in a university at a particular year (see Bilkent Internship Web site as an example). 

The system should keep track of secretaries, faculties, departments, students, companies, quotas, assignments, announcements, etc. 

A secretary has a name and password to login to the system. 

There are several faculties, each with a unique acronym (e.g., ENG for engineering) and a name. 

Each faculty has several departments, again with a unique acronym (e.g., CS, IE) and a name. 
Each faculty has a secretary and a secretary works for only one faculty. 
A secretary may provide announcements, which has a unique id, date and announcement text. 
A student has a unique id, name, year, CGPA, etc. and is associated with a single department. 
A company has a unique name, as well as an address and a city. 
A company may be either a “registered company” or a “self-found company”, which means it is found by the student. 

For a self-found company, the contact person name and title must be stored, as well. 
Each registered company have one or more units, which again have a name (i.e., there is at least 
the “main” unit, if no other units exist). 

A unit of a registered company opens a quota for possible student interns to be accepted. 

A quota has a unique id, capacity, contact person, an application deadline and an internship period. 

A quota may be associated with a department or faculty, if it is restricted to students in particular faculties or departments. 

Students apply for quotas (until the application deadline). 
Of course, a student may apply several different quotas, and vice versa. 
After the application deadline, the secretary decides (or runs a random assignment) of students to quotas.
A student may be assigned to only one quota whereas several students may be assigned to the same quota. 
An assignment has approval deadline, until which a student can accept or reject the quota, and a status. 
If (s)he accepts, the status of the assignment is changed to “ACCEPT”. 
If rejected (either directly by student or automatically once the approval deadline passes), the secretary
can see this “open” quota and assign it to another student. 
Instead of applying for a quota, the student may have found a company for his/her internship 
(i.e., self-found company). 
If this is the case, the system directly assigns the found company to this particular student. 
Again, a student may be assigned only one such company, whereas the company may hire several students. 

Barry has identified the 'Things of Interest' as follows :-
1. Announcements
2. Assignments
3. Companies
4. Company Units
5. Departments
6. Faculties
7. Internships
8. Quotas
9. Secretaries
10. Students
11. Universities

© DataBase Answers Ltd. 2010
About Us Contact Us