Week 15: Final Jobs

22/5/13

(WEDNESDAY)

                   Hooray !! Today is our last lesson with Sir Abd Razak.  We are so happy because we have go through 15 weeks in UTM. Besides, this is also my last semester here.  I had gone through the 4 semester here as part time students and drive for 40 minutes to reached UTM. 

                  The tiredness and difficulties I had gone through and feel satisfy with everything I achieved at UTM. Today, I had completed the data cataloging and I had sent the data to my group members to merge it together to become 200 cataloging.

 Thanks , Mr Abd Razak . 

Week 14: Data Management & Designing Databases

15/5/13 

(WEDNESDAY)

Today we had learn about data management.  The purpose of data management of resources is to have a systematic , no duplication and easy to retrieve information.  Well manage, carefully arranged files make it easy to obtain data.  Meanwhile, poorly managed files lead to chaos in information processing , high costs, poor performance.


Problems With Traditional File Environment
1) Data redundancy & confusion
2) program data dependence
3) Lack of flexibility
4) poor security
5) lack data sharing and availability


DBMS  
DBMS = database management system (database software)
is the type of program used to create , maintain, and organise data in a database, as well as to retrieve information from it.

a) advantages of DBMS
1) Complexity of system can be reduce
2) Data redundancy & inconsistency can be reduced
3) Data confusion can be eliminated
4) program development & maintenance can radically reduced
5) flexibility  of information system can be greatly enhanced
6) Access and availability of information can be increased
7) reduction of duplication
8) improved data integrity
9) programs are independent of the data format
10) sharing of data resources

Disadvantages of DBMS
1) Added expense
2) More hardware may be needed
3) additional training
4) security critical
5) sophisticated design and programming required


 Designing Databases

Logical databases modes for keeping track of entities, attributes and relationships.  There are three principal logical databases models are Hierarchical, network and relational.  

Hierarchical data model

Network Data Model

Relational data model

Week 13: Designing Database

8/5/2013

Wednesday

                 Today, we still learning about designing database based on Microsoft Office Access. I had completed the total of 50 catalogs materials from books, CD ROMS and videocassetes.  Today lesson, we just edit the table for the data we missed up.  Besides, we also learn about the relationship between two tables.  Since, we are new learner ...we still not familiar with the Microsoft Office Access. Therefore, we need to explore more about the Microsoft Office Access. So, this is my self study about Microsoft access.

a) Tables  - organized into vertical columns and horizontal rows

b) Forms - entering, modifying, and viewing records

c) Queries - a way of searching for and compiling data from one or more tables

d) Reports -  ability to present your data in print. (output)

 

Other than that, Mr Abdul Razak also remind us:
"Don't forget to do the Online teaching evaluation (e-PPP)."

Week 12: Public Holiday (Labour day)

1/5/2013

Today is public holiday. No class ... I am happy plus worries, because my cataloging of materials not yet complete. Therefore,  I continue to do my cataloging, which had mentioned by Mr Razak to complete the first assignment before we continue with second assignment, database by using microsoft office access.