REFLECTION WEEK 16: FINAL EXAM, ASINGMENT SUBMITION AND HOOREYY!!!

Assalamualaikum WBT and Salam Sejahtera,

Alhamdulillah on 06/06/2013 I have completed the final exam for this subject and also completed and submitted our cataloging database group asignment to En. Abd Razak. Although the exam questions is quite tough, I still prays to Allah hope En. Abd Razak give A to me..hehe.

           Well, Allhamdulillah because ultimately this is my last semester and means I have completed 4 semesters at UTM. I hope Mr. Abd. Razak has given the best marks for this semester so can I ended successfully. For the last ... Hoorayyy!

Thanks a lot En. Abd Razak.

REFLECTION WEEK 15: PRODUCING FORM, QUERY AND REPORT

Assalamualaikum WBT and Salam Sejahtera,

For this 15th week, members of the group try to complete the tasks given by En. Abd. Razak to produce a database for cataloging materials. Proceed with construction assignments Form, Query and Report after learning and view sample database shown.

Step in producing Form:

1. Select the table you want to use as a form.
2. Choose Create - Forms - Form
3. Sort Field in the desired order by dragging to a specific part.
4. Column size can be changed at will.
5. Assign a name to the Form and Save.

Step in producing Query:

1. Choose Create - Query Wizard
2. Then select Simple Query Wizard - ok
3. Select fields that are involved in queries such as Title, Author, Publisher, Year Published, etc. to be displayed in the Query. Field also choose from different Table.
4. Click Next. Name Query created. Click Finish.
5. Query finished created for reference.

Step in creating Report:

1. Select Table to be used in the Report. Choose Create - Report.
2. Report can be formatted according to the requirements.

WEEK 10 : PERBEZAAN DDC DAN LCC

NAMA                 :HAFIZUDDIN BIN MD SHAKHIH

NO MATRIK      :MP111167

SUBJEK               :SISTEM PENGURUSAN SUMBER PENDIDIKAN

KOD                     :MPT1173

PENSYARAH      :EN ABDUL RAZAK BIN IDRIS

TAJUK                 :PERBEZAAN DDC (DEWEY DECIMAL CLASIFICATION) DAN

                                 LCC (LIBRARY OF CONGRESS CLASIFICATION)

DDC

          DDC telah dicipta untuk penggunaan semua perpustakaan awam dan perpustakaan sekolah sama ada besar atau  kecil dengan pelbagai koleksi sumber pengetahuan. DDC telah dibangunkan pada tahun 1876 sebagai satu cara untuk menyusun semua ilmu .

Sistem DDC ini  sesuai digunakan di perpustakaan awam dan perpustakaan di sekolah-sekolah kerana DDC adalah sistem pengkatalogan bergantung kepada rangka kerja mudah yang bermula dengan sepuluh kelas subjek.  Kelas-kelas ini dipecahkan kepada sepuluh bahagian, yang kemudiannya dipecahkan kepada sepuluh sub bahagian. Buku-buku ini diberikan nombor panggilan mengikut taksonomi ilmu.

DDC hanya menggunakan nombor sahaja  yang memudahkan pustakawan untuk mengkatalog buku dan memfailkannya di dalam komputer. Tetapi DDC hanya memberikan skop subjek bahan sahaja dan pustakawan perlu menambah sesuatu nombor untuk menjadikan sesuatu bahan khusus. Penambahan ini pastiknya akan berbeza bagi setiap perpustakaan.

DDC boleh dikatakan satu cubaan untuk untuk mengkategorikan mana-mana perkara yang mungkin boleh berlaku sahaja dengan cara menyimpan dan menambah angka seperti 625.72

LCC

        

         LCC digunakan di perpustakaan-perpustakaan besar seperti perpustakaan kongres, perpustakaan universiti dan perpustakaan akademik. Sistem ini mempunyai 21 kelas di peringkat tertinggi untuk menggabungkan perubahan dan penambahan ilmu pengetahuan baru, terutamanya dalam  bidang kejuruteraan dan sains komputer. Item-item yang terdapat di dalam 21 kelas tersebut sentiasa dikemaskini dari semasa ke semasa sesuai dengan persekitaran universiti.Hal ini kerana di perpustakaan  universiti mempunyai bahan sumber yang banyak dan pelbagai dan tidak sesuai diklasifikasikan menggunkan DDC kerana taksonomi ilmu DDC adalah terhad. 

            LCC menggunakan huruf dan nombor berbanding DCC yang hanya menggunakan nombor. Sictem LCC sangat sesuai untuk mengklasifikasikan bahan-bahan sumber secara khusus dan tepat dengan subjek bahan berbanding DDC.Tetapi pustakawan mengalami sedikit kesukaran untuk mengklasifikasikan LCC menggunakan komputer.

            Dengan LCC kita mampu untuk mendapatkan nombor panggilan yang lengkap kerana LCC adalah satu sistem rak yang mempunyai senarai klasifikasi yang lengkap. Contoh nombor panggilan LCC ialah H195f. Huruf H adalah huruf pertama nama akhir pengarang  dan f adalah huruf pertama tajuk  buku tersebut. Ini sedikit menyukarkan pengguna untuk mengenalpasti nama pengarang buku tersebut. Walaubagaimanapun klasifikasinya adalah tepat dengan bidang ilmunya.

REFLECTION WEEK 14 : DATA MANAGEMENT

Assalamualaikum and Salam Sejahtera,

This week En. Abd Razak teach us about data management. Data is very important to be stored and cared  properly. Losing data may cause we lose our  source of information. Too large data must be managed well. Using DBMS can help us simplify data management and reduce the cost of data storage.

Data Management Definition:

• Data Management is a broad field of study, but essentially is the process of managing data as a resource that is valuable to an organization or business.

• Administrative process by which the required data is acquired, validated, stored, protected, and processed, and by which its accessibility, reliability, and timeliness is ensured to satisfy the needs of the data users.

Problem With Traditional Files:

The traditional file system had suffered a number disadvantage as firms tended to grow day by day. The problems with traditional file environment include :

Data redundancy: 
Data redundancy is the presence of duplicate data in multiple data files

Program data dependence: 
Program data dependence is the tight relationship between data stored in files and the specific programs required to update and maintain those files.

Lack of flexibility: 
lack of flexibility is a traditional file system can deliver routine scheduled reports after extensive programming efforts but it can not deliver ad hoc reports or respond to unanticipated information requirement in a timely fashion.

Poor security: 
Because there is little control or management of data, access to information may be out of control.     

Lack data sharing and availability:
Lack of control in accessing data and not easy to retrieve the information


DBMS 

• A software system that facilitates the creation and maintenance and use of an electronic database. 
• A database management system (DBMS) is a software package with computer programs that control the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications by database administrators (DBAs) and other specialists.
• (DBMS) is computer software designed for the purpose of managing databases. Typical examples of DBMSs include Oracle, DB2, Microsoft Access, Microsoft SQL Server, Firebird, PostgreSQL, MySQL, SQLite, FileMaker and Sybase Adaptive Server Enterprise. DBMSs are typically used by Database administrators in the creation of Database systems. (Wikipedia, 2008) 

    

Advantages of DBMS 

The advantages of DBMS are as follows: 

• Controlling redundancy 
• Providing storage structure for efficient query processing. 
• Restricting unauthorized users. 
• Providing concurrency. 
• Providing backup and recovery. 
• Enforcing integrity constraints. 

Disadvantages of DMS

The disadvantages are as follows:

• Centralization:That is use of the same program at a time by many user sometimes lead to loss of some data.
• High cost of software.
• Technical experties are required

REFLECTION WEEK 13 : DESIGNING MS ACCESS

Assalmualaikum WBT and salam sejahtera,

This week, En. Abd. Razak shows examples of databases that have been built using MS Access. With detailed descriptions of how to make Field catalog database that will be produced by our group will be described. Then, some Table will be generated to separate the raw data for the material with the publisher for details.

Field to be involved in Material Table are:

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

Field to be involved in Publisher Table are:

1.PubID (code name publishers )
2.PubNAME (full name of the issue)
3.PubPLACE (Place published)

The two tables (materials and publisher) produced will be correlated with Relationship to facilitate data entry, especially for materials with the same issue may be associated with other materials.