I'm finding the context diagram for system's analysis and design a challenge.
I'm trying to draw a logical data structure for the scenario below. I can't get past level 0, I have one external entity....Please take a quick look, any suggestions would be most welcome.
LDS of Staff and Student Database.
The University of Chicago accepts students on to both undergraduate and postgraduate courses. The UOC records student details, personal and the qualifications they have gained at A-level(or equivalent) and above. Students are required to have qualifications of A-level or above in-order to undertake any of its undergraduate courses. For a postgraduate course, students must have at least a bachelor’s degree. However some exceptions are made for mature students for undergraduate and post graduate courses. The student records are kept for ten years after thy have left the course before being removed from the main database and archived. A student records will be reinstated if the student enrols on a new course.
All the courses are made up of modules. Some of the modules are taught to more than one course. Some courses allow electives, i.e. a student may choose to do some modules and not others, the student’s choice must be recorded.
All lectures at the university belong to a department, e.g. physics, fine art, admissions, etc. but not staff in a department are lectures, there will e administration staff and researchers. One lectures is assigned as the “course leader”, the individual will deal with all the academic matters arising from the course. A lecturer will not be the course leader of more than one course at anyone time. The course leader is always from the same department that has responsibility for the course. Lectures may teach a module on any course. Usually a module is taught by one and only lecturer but there are exceptions. Each module has a number of assessments. Typically this is two assignments and an exam, although there are some variations. The details of each assessment and marks for each individual student are recorded. Each member of staff has a line manager to whom they are directly responsible. The line manager is of course another member o staff. The line managers of lectures and researchers are always more senior academics. The line manager of administration staff will be another administer for at lower levels but will be a departmental head for the more senior administrators.
Each student is assigned a personal tutor from the lecturing staff. The lecturer concerned may change but only the current tutor is recorded on the database.