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