Database

Hi,

Not sure if this is possible, but have a project to work on. Basically, we are trying to create a lightweight student information system for specific purpose.

Students need to see their own data and only their data
Students need to update some of their data
Staff need to update some data
Staff need to see all the data

(I know, I should be using a relational database, but please bear with me. Moodle is what I have.)

Something like this:

Database Activity 1 has fields like this, and I think if each user is in their own unique group they can only see their own entry.

Firstname
Lastname
StudentID
Gender
EmailAddress
PhoneNumber
Placement CASEC Score
GPA
Current CASEC score
TOEFL iBT Score
IELTS Score

But then each semester update these fields from a single file
GPA
Current CASEC score

I don't think I can Import just those fields to the database activity in an additive way.
So, If I create Database Activity 2 with Student ID,GPA,Current CASEC score, I could delete all entries each term and import the fresh data from csv. Can Database Activity 1 fields pull in the data for GPA and Current CASEC Score from Database Activity 2? If so, how would I do this?

Thanks!