Week 7(b) : Student Database

In this last Week of task division, we are required to plan the data structure for Student management information for each table. We are required to only use the student name in Student Table, and  not others.

The data structure's specification is as follows, we are required to create table in design view and it need to be separated into four different tables. The name of the tables should be student table, parent table, curriculum table and co-curriculum table all using student ID as a Primary key. The next step is to create relationships between tables by linking the student ID. This is why not to create student name for other tables except Student Table.

We need to use the Wizard to Create Form of:

o Student Form

o Parent Form

o Curriculum Form

o Co-curriculum Form

The steps after all above is to enter data using Form and we are not encouraged to use table for data entry. 

The last step will be to create several queries from the database and create reports based on the queries.

I find that the database system is very interesting and will come handy if there are activities to be done with students personal details and achievements. The database system makes a very good companion for teachers who need to enter details on their students. It could help save time and be statistically be more organised.