Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the requirements for the following University System, Perform the Architectural Design of this system University Department Information System: Various details regarding each student such

Given the requirements for the following University System, Perform the Architectural Design of this system
University Department Information System:
Various details regarding each student such as his name, address, course registered, etc. are entered at the time he/she takes admission.
At the beginning of every semester, students register for courses. The information system should allow the department secretary to enter data regarding student registrations. When the secretary enters the roll number of each student, the computer system should bring up a form for the corresponding student and should keep track of courses he has already completed and the courses he has back-log, etc.
At the end of the semester, the instructors leave their grading information at the office which the secretary enters into the computer. The information system should be able to compute the grade point average for each student for the semester and his cumulative grade point average (CGPA) and print the grade sheet for each student.
The information system should also keep track of inventories of the Department, such as equipments, their location, furnitures, etc.
The Department gets an yearly grant from the University and the Department spends it in buying equipments, books, stationery items, etc. Also, in addition to the annual grant that the Department gets from the University, it gets funds from different consultancy service it provides to different organizations. It is necessary that the Department information system keeps track of the Department accounts.
The information system should also keep track of information such as the research projects running in the Department, publications by the faculties, etc. These information are keyed in by the secretary of the Department.
The information system should support querying the up-to-date details about every student by inputting his roll number. It should also support querying the details of the cash book account. The output of this query should include the income, expenditure, and balance.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

10. Describe the relationship between communication and power.

Answered: 1 week ago