Hypothesis: College ABC wants to implement a college management software to centralize their following keys operations, student record management and related transactions: 1. Admissions to manage new international as well as Domestic admission applications. 2. Program Registration for admitted students. For all offered programs. Group allocation. 3. Fee Management Semester wise fees payment and status. Payment modes Online only through Debit, Credit Card, or online banking. Fees receipt generation. 4. Semester Management to manage registered courses, attendance, class schedules. 5. Student Profile Personal Information such as current address, date of birth, nationality etc. 6. Assessment portal course-wise marks, online transcripts, Group assignment students list. 7. Instructor portal Semester and courses assignment, schedule assignment.

Question: To implement database, use data techniques to propose the data design for above steps.

Tip: a. You can assume data fields. Minimum 3 data fields in each data block