Week 7b~ Database OpenOffice Base

Assignment 9~Student Management Database

Now!!! For the last task, assignment number 9!!! We have to plan, create and edit a simple database..well not so ‘simple’ actually.. for student management information using OpenOffice Base in a creative, innovative and ethical ways. To do so, you need to:

 Plan the data structure for Student management information for each table (only use student name in Student Table, but not others):

 Tables: Create table in Design view (4 separate tables

·         student table(use student ID as a Primary key)

·         parent table (use student ID as a Primary key)

·         curriculum table (use student ID as a Primary key)

·         co-curriculum table(use student ID as a Primary key)

 Tool->Relationship: Create relationships between tables by linking the student ID (That is why not to create student name for other tables except Student Table!)

 Use Wizard to Create Form:

·         Student Form

·         Parent Form

·         Curriculum Form

·         Co-curriculum Form

 Data entry using Form (Note: do not use table for data entry)

 Create several queries from the database

 Create reports based on the queries

Reflection:This is an individual task and it IS quite easy..if you understand the instruction carefully. Using the Open Office Base, it makes our information organized, neat and simple. But to do it still quite challenging. Also!!! It can be used when we be the ‘real’ teacher. When the times come, it will just a piece of nuts for us since we already learnt it. Overall this subject was fun, challenging  and tricky to do but we learnt from experiences guys! This subject really helps me a lot and as a teacher, of course, I need to learn more about it without waiting for the time to come for me. Because we don’t want to suffer on the last day right..Nice meeting you all..the Open Office and company!haha..and special 'Thank You' to our lecturer and coordinator..Mr. YM Tg. Norazlan & Dr. Siti Fatimah..lastly, happy holiday guys and Happy Eid to all muslim..=D