Database

Good morning everyone!

After we did spreadsheet this week, we also had to create a database. This database is for student management information using OpenOffice Base. This was my first time creating a database because I have not done anything related to database before. Despite such unfamiliarity, instructions on how to create a database given by our lecturer is comprehensible. I owe my work this time around to our one and only, Mr. Mohammad Fariduddin. He endlessly given support to us and I truly appreciate it from the bottom of my heart.

Included in the weekly instructions, we are supposed to:

1. 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)

2. 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!)

3. Use Wizard to Create Form:

• Student Form
• Parent Form
• Curriculum Form
• Co-curriculum Form

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

5. Create several queries from the database

6. Create reports based on the queries

Using these outline to create a database is already sufficient for myself. Though I must say, there has been countless trial and errors in creating reports based on the queries. As the tables were supposed to be separate, I couldn't find a way to merge the data entry into one single table in the report. That means I have four reports based on four queries. Therefore, Azrul made another attempt with a different way, that is combining the tables into one during the table creation. There were only query so, one report was created with all the data on different column. This method differs with the first method of separating the table. 

I've uploaded a copy of the report on my Yahoo! group. 

Link: http://bit.ly/q4QkHS 

In short, creating a database isn't as easy as expected. There were many shortcomings throughout the process but I believe that with efforts, anything is possible. When a certain something is new to us, is is essential that when we try and fail, we should try again until we succeed. It all comes with hard work. 

As of importance in creating database, we possess prior knowledge to it before we move on to something harder in the near future. I'm sure I'll be encountering it again, harder and more complicated. Having basic knowledge on how to create a simple database prepares us for the next challenge.

To conclude, this is our last assignment of this course. But it isn't the last for this blog.

A "Thank You" post is coming right up :)

B. Ed TESL IPGKS-UKM
IPG Kampus Sarawak
Jalan Bakam 98009
Miri

E-mail: barbarakath108@gmail.com
http://groups.yahoo.com/group/barbara_kath
http://www.facebook.com/barbarakath