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