Refleksi Minggu Keempat belas

ADVANTAGES OF DBMS

The DBMS (Database Management System) is preferred ever the conventional file processing system due to the following advantages:

1.Controlling Data Redundance

Avoid duplication of same data in different files and wastage of storage space. Reduce the time to keep the same data.

2. Elimination of Inconsistency

Remove the duplication of data in multiple file to eliminate inconsistency.

3. Better service to the users

Centralizing the data in the database so that user can obtain new and combined information easily .

4. Flexibility of the System is Improved

Changes are made more easily in a centralized database

5. Integrity can be improved

DBMS used by a number of users at a time. It is essential to enforce integrity-constraints.

6. Standards can be enforced

Standardizing stored data formats is usually desirable for the purpose of data inter¬change or migration between systems.

7. Security can be improved

Different checks can be established for each type of access (retrieve, modify, delete etc.) to each piece of information in the database.

8. Organization's requirement can be identified

It is the responsibility of the DBA (Database Administrator) to structure the database system to provide the overall service that is best for an organization.

9. Overall cost of developing and maintaining systems is lower

It is much easier to re¬spond to unanticipated requests when data is centralized in a database . The cost of  developing and maintaining DBMS application programs to be far lower than for similar service using conventional systems.

10. Data Model must be developed

Perhaps the most important advantage of setting up of database system is the requirement that an overall data model for an organization be build.

11. Provides backup and Recovery

Centralizing a database provides the schemes such as recovery and backups from the failures including disk crash, power failures, software errors which may help the database to recover from the inconsistent state.

Reference:

http://dbmsbasics.blogspot.com/2008/05/advantages-of-dbms.html

This tutorial will show how we might plan and build a database from scratch, including how to set up tables, create and use forms to enhance data integrity, design and run meaningful queries, and produce useful and attractive reports.

Here are some videos to show how to use access :

1.Creating new database 
 http://www.youtube.com/watch?feature=player_detailpage&v=7rpduLYdHjY

2. Creating form
http://www.youtube.com/watch?v=FFUJpu7pX6o&feature=relmfu

3.  Creating table

http://www.youtube.com/watch?v=q0jAoX2-Eog

4. Create table and form

http://www.youtube.com/watch?v=AH3ilFm_C88

5. Creating access report

http://www.youtube.com/watch?v=RtATRFvBEMk&feature=related

6. Creating table and relationship

http://www.youtube.com/watch?v=IarzvwTijwk

http://www.youtube.com/watch?v=bBHewXpSgQQ

Refleksi Kuliah Minggu Ketiga belas

Pada minggu ini saya mempelajari bagaimana menggunakan Microsoft acces untuk menyediakan Database

  Langkah-langkah Membuat Database menggunakan  Microsoft Office Access 2007

1. Pilih Ms Access 2007

2. Setelah anda open Ms Access tadi, pilih Blank database

 

 

 

 

 

                

3. Kemudian buka file name tadi seperti gambar di atas, akan muncul form lagi buat folder kemudian pilih format file(mdb). karena nantinya kita akan menghubungkan access dengan Delphi(Postingan selanjutnya). setalah sudah di pilih tinggal klik ok

4. Pilih Create

5. Pilih table1, klik kanan pilih design view isi nama table: misalnya (club)

6. Kemudian isi table dengan berapa field yang anda inginkan, contoh :

Contoh : menggunakan 7 field (no, arsenal, Real Madrid, Chelsea, Barcalona, MU, Valencia). ganti field saiznya pada field Properties mengikut aksara yang sesuai

7.  Klik table (club) pilih open Isi Field dengan beberapa Record

Minggu kedua belas

 Kuliah diadakan dari pukul 2.30 hingga 6.30.

Minggu ini saya tidak dapat hadir ke kuliah kerana berada di Vietnam, menghadiri dan membentangkertas kerja dalam Seminar Pendidikan Antarabangsa di Universiti Hanoi... Doakan urusan saya dipermudahkan dan semoga selamat pergi dan selamat pulang...

Walaubagaimanapun, spada minggu ini rakan-rakan saya telah mempelajari Database.
Berikut adalah bahan yang saya perolehi tentang Database:

Database Management System (DBMS)

A set of programs that enables you to store, modify, and extract information from a database, it also provides users with tools to add, delete, access, modify, and analyze data stored in one location. A group can access the data by using query and reporting tools that are part of the DBMS or by using application programs specifically written to access the data. DBMS’s also provide the method for maintaining the integrity of stored data, running security and users access, and recovering information if the system fails. The information from a database can be presented in a variety of formats. Most DBMSs include a report writer program that enables you to output data in the form of a report. Many DBMSs also include a graphics component that enables you to output information in the form of graphs and charts. Database and database management system are essential to all areas of business, they must be carefully managed. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes. The following are examples of database applications: computerized library systems, flight reservation systems, and computerized parts inventory systems. It typically supports query languages, which are in fact high-level programming languages, dedicated database languages that considerably simplify writing database application programs. Database languages also simplify the database organization as well as retrieving and presenting information from it. A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, and recovering the database after failures and restoring it from backup files, as well as maintaining database security.

Reference:

http://en.wikipedia.org/wiki/Database_management_system

Minggu kesebelas

Cuti umum sempena Hari Keputeraan Sultan Johor....

Cuti lagi....emmmm

Minggu kesepuluh

                                                       Cuti pertengahan semester   - masa bersama keluarga....

Kuliah kesembilan

Kuliah ke sembilan masih berkisar tentang pengklasifikasian bahan dengan menggunakan Dewey decimal classification (DDC 22)

 








Hasil pembelajaran pada hari ini ialah :


Bahan A

 

  Cara membuat pengklasifian bahan A

a) Merujuk DDC 22 (indeks) - cari nama tajuk/subject heading/content bagi bahan tersebut
    - 328  merujuk no panggilan bagi 'Parliament'
b) Bahan etrsebut merujuk 'member and memberships.  Maka no panggilan bahan tersebut ialah :
   -  328.33
c) Bahan tersebut juga merujuk di kawasan (geographical) iaitu Malaysia. maka no panggilan tersebut ialah :
   - 328.33 09595
d)  Bahan tersebut juga merupakan Direktori.  Maka no panggilan tersebut  ialah
   - 328.33 0959 025
atau no panggilan bagi bahan tersebut hanya ditulis 328.33025

Bahan B
                                             

 

No. panggilan bagi bahan B ialah 728.09595 iaitu :

a) 728  (dirujuk dalam indeks)

b)      .09 ( Geographical)

c)          595  ( Malaysia )

Bahan C

No. panggilan bagi bahan C ialah 620.1103 

a) 620.11 merujuk kepada 'Engineering material'

b)            03 merujuk ' glosary '

Kuliah ke lapan

What we learned this week?

3 main areas in catalog
a) Classification
b) Description
c) Subject

eg:

   LB 1026. A36. 302.01

LB 1026 - library congress
A36        - subclasses
302.01    - Dewey

Library congress classification

eg :        Z    
            694
            B68   
            2003
             c.1
explanation :  Z 694    - call no.
                       B           - author name
                       2003      - year publication
                       c.1         - copy 1

eg.  Pengenalan sistem kejuruteraan kawalan

                    620.001 1  - is used for engineering system
                    HER   - author name
                    2004   - year publication

eg : Essentials of management

                    658     - is used for management
                    JOS     - author name
                   1987     - year publication

eg. Aljabar linear permulaan

                   512.5     - is used for Algebra
                   HOW     - author name
                   2001       - year publication

Kuliah ketujuh

Kuliah ketujuh

Cuti sempena  Hari Raya Aidil adha

Kuliah keenam

Library Catalog Research

Subject heading- control vocabulary

Subdivisions are terms that are placed after Library of Congress subject headings to identify a narrower category of information.

There are four main types of subdivisions:

a) Topical Archeology   - Methodology
b) Form Archeology      - Fiction
c) Chronological Archeology  - History-18th century
d) Geographic Archeology      - Egypt

Topical subdivisions
Topical subdivisions are used under all types of subject headings — personal, corporate, family, and geographic names, uniform titles, and topical headings — to represent a particular subtopic and narrow down the broader subject.  A topical subdivision may represent a concept, attribute, aspect, action or process, methodology or technique, a part of the whole, or another category of term.  Some examples include:

E.g.    $x Philosophy      [concept]

$x Density      [attribute, under types of chemicals]

$x Psychological aspects      [aspect]

$x Employee participation      [action or process]

$x Aging      [action or process]

$x Statistical methods       [methodology]

$x Respiratory organs      [part of the whole, under types of animals]

$x Museums      [part of the whole, under names of corporate bodies]

Form subdivision
Form subdivisions indicate the nature of the material rather than something about its content; in other words, they indicate what a work is, not what it is about.  Examples include:

E.g.    $v Bibliography

$v Catalogs

$v Dictionaries

$v Early works to 1800

[considered to be a form subdivision, not a chronological one, because the approach to the subject matter may not be chronologically based]

$v Exhibitions

$v Periodicals

$v Textbooks

Chronological subdivisions
Chronological subdivisions are applicable when the work covers the history, or an aspect of the history, of a given topic, corporate body, or place during a limited time period.

Modern history:  Century subdivisions may be used under “$x History” from “$y 16th century” through “$y 21st century,” as applicable.

E.g.    650  0  $a Iroquois Indians $x History $y 17th century.

650  0  $a Coal mines and mining $z Pennsylvania $x History $y 19th century.

610 20 $a Harvard University $x History $y 20th century.

 Geographic subdivisions
Geographic subdivisions may be used under topical subject headings and following topical subdivisions when they are specifically authorised, as indicated by:

• Subject Cataloging Manual:  Subject Headings:  The phrase “(May Subd Geog)” following a subdivision.
• The “red books” (printed LCSH list):  The phrase “(May Subd Geog)” following a subject heading. 

E.g.    Free floating subdivision in the Subject Cataloging Manual:  $x Government policy (May Subd Geog)

Therefore: 650  0  $a Wetland conservation $x Government policy $z Poland

is valid

 

Kuliah kelima

Tajuk : Subject Cataloging (Penyediaan tajuk perkara)

Alat yang digunakan adalah :

         Library of Congress Subject Headings (LCSH) –  senarai tajuk perkara yang disedia dan digunakan oleh Library of Congress

                                                                                                           

Contoh:

Technology and vocational technical education globalisation and future trends, Editor Noraishah Buang : Bangi : Universiti Kebangsaan Malaysia, 2001

         1 Technical education         2  Vocational Education

          ISBN 983-2446-25-2

          i Noraishah Buang             ii   International conference on technology and vocational-
                           technical education : Globalisation and future trends
                           ( Bangi;2001)

          Volume I &II

          Faculty of Education, UKM