Answer:
See below
Explanation:
1. Data type
- S.No = integer (because its a number of sequence)
- Fees Paid = varchar (usually we use varchar to store currency, and process the number for UI, by adding dot or comma)
2. Reg No should be unique for each students and department. I only use the Table 1 for reference, more data would be helpful
3. Reg. No consist of 2 digits of initial department, and 3-4 digits of sequence number that identifies student's no.
