database management system how would you do this?

Question

Need help from database management pros!!!!?
You are assigned to develop an application that will manage students results at the Faculty of
Computing and Information Technology of a university. It has been observed that
(a) Students are fed up with lining up and view their results on notice boards. They should therefore
view the results using a computerized system
(b) Lecturers who teach courses always get complaints and they end up searching for students work
in hard copy files. They want to use the computerized system to view the results and whenever
necessary make updates
(c) The examinations office have problems with students choosing their own seats. They may copy
in the process. The system should automatically assign seats to all students registered for a
certain paper (test and exam)
The following tables are to be used
Department(DeptId, name, hod*)
Staff(staffId, name, rank, dateofBirth, gender, deptId*)
Student(studentNo, registrationNo, name, dateOfBirth, gender, nationality)
CourseUnit(code, name, creditUnits, homeDept*)
Results(studentNo, code, courseWork, exam)
Room(roomId, roomName, capacity)
RoomAllocation(roomId, courseUnit, date, startTime)
Ensure that the following stakeholders are satisfied
A) Student:
the student should be able to
● view his/her results
● view his/her test/exam timetable
● submit a complaint about his/her test results to the concerned lecturer
B) Head of Department:
The head of department should be able to
● view the timetable of all course units in his/her department
● view the timetables and room allocation for the courses 9and students) in the
department
C) Staff:
Staff should be able to
● view all results of the papers they teach
● edit results of the papers they teach
● view exam/test timetables of the faculty
●
NB: another access right should be included to cater for the system administrator who enters the
dataIt is expected that it will take you (I) one week to work on access rights and administrator page
(ii) one week to cater for student module (iii) one week to cater for HoD module and (iv) 1 week to
cater for Staff module


it is a discussion question that we where given and we were asked to have a n open discussion on the web I thought yahoo answers would be a great place for knowledge
thanks

Answer 1

since just about every campus offers online class options, I would create a web application that accessed the underlying data. Depending on the dbms available, I would either create the needed user groups within the dbms or add an additional series of tables to manage the roles and security.



Based on the roles the individual user would be able to perform only the tasks available to that role and would code the pages to match the appropriate behavior available to each role

Answer 2

The database holds the archives, fields, cells ..with archives. The DBMS is the "procedures" used to manage the advice in the database. An occasion of a DBMS is sq. Server. The DBMS is the database engine itself. it extremely is the middle, the easily application that incorporates the best judgment to execute your sq. statements. performs that easily archives get admission to based upon those instructions (relationaly). while DS is suitable with convalescing the fee of traversing and looking out the advice in considerable reminiscence. As all of us understand that the processor can in basic terms technique the advice it extremely is supplied in considerable reminiscence. hence different fashions used to administration archives in considerable reminiscence are at the same time referred as DS.

Answer 3

add an additional series of tables to manage the roles and security.