erd diagram for college admission system ppt

[Guest]

Admission procedure in a University is as follows:
An advertisement is issued giving essential qualifications for the course, the last date for receipt of application, and the fee to be enclosed with the application. A clerk in the Registrar's office checks the received applications to see if mark-sheet and fee are enclosed and sends valid applications to the concerned academic department. The department checks the application in detail and decides the applicants to be admitted, those to be put in the waiting list, and those rejected. Appropriate letters are sent to the Registrar's office which intimates the applicant.
For the following word statement, obtain E-R diagram and relations. Use any reasonable assumptions.