Tuesday, June 4, 2013

WEEK 15: FORM, QUERY AND REPORT RELATIONSHIP

Assalamualaikum WBR...

Today we continued about the database that we had been created... En Abdul Razak has guided us to make a relationship between form, query and report..




We asked to combine the cataloging information between four members and burn it into a CD-ROM...

REFLECTION:

I wanted to thank to our beloved lecturer.. En Abdul Razak for teach us the whole semester in this course...
Also a many thanks to my friends...Hafiz, K Aza, Lily, Suok, Abg Man, Jai and Pog...
May Allah bless our life...
Good luck for this examination...







Saturday, March 9, 2013

WEEK 14: Database Management System (DBMS)

Assalamualaikum....

what i have learned today? DBMS....

What is a DBMS?
A database management system is the software system that allows users to define, create and maintain a database and provides controlled access to the data.


A Database Management System (DBMS) is basically a collection of programs that enables users to store, modify, and extract information from a database as per the requirements. DBMS is an intermediate layer between programs and the data. Programs access the DBMS, which then accesses the data. There are different types of DBMS ranging from small systems that run on personal computers to huge systems that run on mainframes. The following are main examples of database applications:

• Computerized library systems

• Automated teller machines

• Flight reservation systems

• Computerized parts inventory systems

A database management system is a piece of software that provides services for accessing a database, while maintaining all the required features of the data. Commercially available Database management systems in the market are dbase, FoxPro, IMS and Oracle, MySQL, SQL Servers and DB2 etc.

These systems allow users to create update, and extract information from their databases.

Compared to a manual filing system, the biggest advantages to a computerized database system are speed, accuracy, and' accessibility.


REFLECTION:
Although i had never been developing DBMS before this, i am very grateful and excited to do it..  i have gained a new knowledge about this...

WEEK 13: Relationships between tables in a Microsoft Access database

Types of Table Relationships

A relationship works by matching data in key columns, usually columns with the same name in both tables. In most cases, the relationship matches the primary key from one table, which provides a unique identifier for each row, with an entry in the foreign key in the other table.

There are three types of relationships between tables. The type of relationship that is created depends on how the related columns are defined.

One-To-Many Relationships

A one-to-many relationship is the most common type of relationship. In this type of relationship, a row in table A can have many matching rows in table B, but a row in table B can have only one matching row in table A. A one-to-many relationship is created if only one of the related columns is a primary key or has a unique constraint. In Access, the primary key side of a one-to-many relationship is denoted by a key symbol. The foreign key side of a relationship is denoted by an infinity symbol.

Many-To-Many Relationships

In a many-to-many relationship, a row in table A can have many matching rows in table B, and vice versa. You create such a relationship by defining a third table, called a junction table, whose primary key consists of the foreign keys from both table A and table B.

One-To-One Relationships

In a one-to-one relationship, a row in table A can have no more than one matching row in table B, and vice versa. A one-to-one relationship is created if both of the related columns are primary keys or have unique constraints.This type of relationship is not common because most information related in this way would be all in one table. You might use a one-to-one relationship to:

Divide a table with many columns.
Isolate part of a table for security reasons.
Store data that is short-lived and could be easily deleted by simply deleting the table.
Store information that applies only to a subset of the main table.

In Access, the primary key side of a one-to-one relationship is denoted by a key symbol. The foreign key side is also denoted by a key symbol.



REFLECTION:

We are going to key in all the cataloging information in the table by using these details:

Material Table:

1.Title
2.author
3.additional entries
4.edition
5.publisher
6.Publish year
7.ISBN /ISSN
8.call number
9.type of material
10.physical description
11.Subject 1 & 2
12.note

 Publisher Table:

1.Pub ID (code name publishers )
2.Pub NAME (full name of the issue)
3.Pub PLACE (Place published)


WEEK 12:PUBLIC HOLIDAY




Happy Labor Day Everyone...
However...we must keep on doing our task to complete the 50 materials in cataloging...
work smart and good luck, friends...(^_______^)

WEEK 11:INTRODUCTION OF MICROSOFT ACCESS

ASSALAMUALAIKUM WBR...


REFLECTION:

Alhamdulillah...all praise to Allah...our class today went very well...i am very excited because this is the first time i have learned about the Microsoft Access...

so...what is the use of MS Accsess?
here are some findings about it:






WHAT IS ACCESS?
Access is a database tool for gathering and understanding all your information—your phone numbers, inventory, guest lists, whatever you’re tracking—and providing a convenient way to enter, navigate, and report out your data. At school access is used in many application like Sistem Maklumat Murid (SMM), Aplikasi Pangkalan Data Murid (APDM), E-Mis, e-opreasi and so on.


today...we have learned how to create table, query and form...






WEEK 10: DEWEY DECIMAL CLASSIFICATION (DDC) AND LIBRARY OF CONGRESS CLASSIFICATION

ASSALAMUALAIKUM WBR...


This week, En. Abdul Razak has read our task on the differences between the DDC and LCC.

The following is a discussion of the results we have obtained:

DDC:
1. Use for School library, Public Library and the National Library
2. Use only number for call number.
3. Divide into 10 divisions and 10 subdivision of knowledges.
4. Easy to enter data in the computer system.
5. Contains simple user

LCC:
1. Use for Academic libray and University library.
2. Use of number and alphabet.
3. Divide into 21 divisions by alphabet.
4. Quite hard to enter data in the computer system.
5. Contains a complex user

After that, we headed to the Faculty Resource Center to find the classification numbers for the thesis.

The following are the results:



153.6     Aida Shakila binti Adnan @ Abdul Khair
AID                Gaya komunikasi interpersonal pengetua dan hubungannya dengan kepuasan kerja guru di
              empat buah sekolah menengah Zon Lapis, Johor/Aida Shakila binti Adnan @ Abdul Khair-Skudai,
              Johor : Universiti Teknologi Malaysia, 2012 [tesis tidak diterbitkan]

              xv, 132 m/s. :ill. : 30 cm
             Mengandungi bibliografi
             Tesis Sarjana Pendidikan (Pengurusan Pendidikan)

             1. Interpersonal Communication    2. Job Satisfaction               I. Judul


Reflection:

After successfully finding the classification number, I agree with Mr. Abdul Razak, claiming that the call numbers selected must be based on need. We must give them the convenience of users to easily find the desired material.




WEEK 9: SEMESTER BREAK