about basis data

Student registration case studies

Student registration at the Computer College is as follows: a. Acceptance of prospective student registration data: The marketing department collects data on new students who are interested in registering. b. Registration process: Students who pass the selection for new admissions tests, then register by filling in the registration data and paying the registration fee in the finance department. c. Registration of registration data: In this process the finance department records the data of students who have registered. d. Making student ID numbers: Students who have registered will then be processed in the academic section to get student ID numbers.

Based on the case study above, make a sequence of processes and related parts, then describe the ERD by determining the entities, attributes, relations and cardinality mapping therein.