Week 7b (Database)

TASK !!

Plan, create and edit a simple database for student management information using OpenOffice.org Base in a creative, innovative and ethical ways

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)
o student table (use student ID as a Primary key)
o parent table (use student ID as a Primary key)
o curriculum table (use student ID as a Primary key)
o 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:
o Student Form
o Parent Form
o Curriculum Form
o 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

By doing Assignment 9, I have learnt how to create database using OpenOffice.org Base rather than using Microsoft Access. Before this, most of my friends told me that using OpenOffice.org is much easier. Thus after i finish this task, i mat claim that every program have their own pros and cons. The usage and rating of the prog depends on the users actually. But in my point of view, i do prefer OpenOffice.org.