Milan: A New (Dark) Era?

June 11th, 2009 by ghozan

Next season will be a very tough challenge for AC Milan. They will have to face three major changes. Paolo Maldini, whom has been a Milan player for 25 years and was considered as the flag bearer of Milan, has decided that it is his time to retire from football. Whether this is a temporary retirement from football with a chance of a comeback in a different role or a permanent one is still unknown. Maldini hasn’t decided yet what he is going to do next. This is the first and most important challenge that Milan have to overcome, that is to find not only a captain but a person who can be the symbol of Milan itself. Read the rest of this entry »

Normalization: An Exercise

April 27th, 2009 by ghozan

As I have explained earlier, database normalization is really important to ensure your daily operations such as deletion, update and etc will be successful. It can also make your database free from certain anomalies. Thus every database designer must have this knowledge. It is not something that you can learn easily but it has to be trained over and over again. So to make you familiarize with database normalization I have made and ER-Diagram which is not in normal form yet. Your task is to normalize the ER-Diagram and provide the representation of the physical table. Click here to see the ER-Diagram.

Database Normalization

April 20th, 2009 by ghozan

According to Wikipedia, database normalization refers to a systematic way of ensuring that a database structure is suitable for general-purpose querying and free of certain undesirable characteristics—insertion, update, and deletion anomalies—that could lead to a loss of data integrity. One should know that there are many types of normal form including 1NF, 2NF, 3NF. Higher degree of normal forms includes BCNF, 4NF, 5NF and 6NF. A database table is often thought as “normalized” if it is in the third normal form (3NF). In this normal form most tables are free insertion, deletion and update anomalies. Database normalization is very important in designing a good information system because normalizing all tables would really affect the performance of the system.

ER-Diagram

April 13th, 2009 by ghozan

ER-Diagram, which is the abbreviation of Entity-Relationship Diagram, is the most used tool to represent data. It is an abstract and conceptual method of representing data to describe the requirement of the user. In the requirement analysis stage the output is user requirements. Those requirements are then mapped to an ER-Diagram. This diagram then can be used to develop the physical model of the system. So understanding how to draw an ER-Diagram from user requirements is also a key point in analysis and design of information system.

This Site Will Be Closed!

April 1st, 2009 by ghozan

For my current reader, I have an announcement to make. Regretfully it will be a sad one. Due to the fact that I am very busy at campus and because of my anger of seeing my blog thrown to the sandbox by Google, I am sadly to inform you that I am going to close this blog shortly. I don’t know if this is going to be a permanent one or just a temporary thing, but one thing for sure that it will be closed. So for all of you out there, my dearest and loyal readers, thank you for coming to my blog and share a little bit of time in your busy day to read my posts and give comments. See you in another time and place where I have my desire of writing posts flamed up again. Read the rest of this entry »

DFD Quiz

March 30th, 2009 by ghozan

The first step in system information life cycle is requirement analysis. In this step an analyst has to capture all of the requirements needed by the user. The requirement analysis is the most important step of all because if you fail to identify some requirements then the system you develop will not be sufficient for all users. The end product of this step is a list of requirements which you need for the next step which is the design part. In the design part those requirements you identified before have to be presented in a way which is understandable for the user as well as the programmer. This step usually involves designing tools such as Data Flow Diagram (DFD). So for the fifth quiz, you need to explain what is a DFD, how to draw them and what are the naming conventions for each of the symbols in DFD.

Fourth Quiz

March 23rd, 2009 by ghozan

Not so many people came to my lecture today. From about 80 students in total, there were only a quarter who showed up. This is understandable as Hindu of Balinese will have Nyepi day in three days time. So I think that many of them who were absent went to their hometown to prepare the ceremony. As the class were not full I only gave them my lecture material and gave them their fourth quiz. This quiz is about requirement analysis which is the first step on the information development life cycle.

Yet Another Slump

March 6th, 2009 by ghozan

My blog has experienced another set back. A year ago when I started this blog, I managed to write at least a post each day for the first three months. My idea was to get a high page rank as soon as possible by writing as many posts as you can in English. This plan worked like a charm because on the first update of Google’s page rank, my blog was rewarded a PR4. It was after that I started to write reviews from various paid review brokers such as ReviewMe, Blogsvertise, SponsoredReviews, etc. Review offers poured in and I was a bit overwhelmed to finish all the tasks given to me. This was because some of those review brokers obliged you to write a review which is preceded and followed by actual post. It was hard you know to write something without having an idea of what you are going to write. Ask a reporter and you will notice that it needs something more than just an idea to write a good post. Read the rest of this entry »