java - How to design a storage system for this? -

i stuck @ designing database this.

this own cs project. means entire code idea. anyways, know efficient way store of information shown in picture.

i thought using arraylist, questioned myself repetitively whether arraylist work. use database haven't learned yet.

the picture should pretty self-explainatory. of these information belong 1 student. so, how can designed best data storage system store @ least 20 students' information?

since can't post image, please click link: http://j.stack.imr.com/0q.png

thanks help.

looks case 1 database table 1 row per student, , database table row per assignment. either have database create index each student record stored (the current fashion in relational databases), or use student id number assuming unique , permanent (i consider weaker choice). every student record , every assignment record has index in it, every assignment associated 1 , 1 student, can have many assignments associated 1 student.

there number of free databases available; have used , liked derby; if accessing program, can use "embedded" database, saving headache running database server program connect with.

good luck.