week 7

Q1: What were the most important concepts you learnt this week?

This week we learned Entity relationship diagram and normalization of the table structure. Entity relationship diagram is another way to graphically represent the system. This will help to identify all the possible data storages needed for the system. Normalization is a technique to design a proper database structure. This will provide facilities such as easy search and eliminate the data redundancies.

Q2: Why do you think those concepts are important?

For any Information System, data storage is an important part. If the database design is done properly then most of the run time or maintenance time errors can be avoided. If we can identify all the key fields at all the table involved then the programming also become easy, data retrieval and data search can be done in less amount of time. So these entity relationships and normalization are very important concepts.

Q3: What concepts from this week are causing you the greatest problems?

I have experiences in analysis and design and I have learnt these technics earlier in my bachelor’s degree as well, only difference I can see is the notations we use in Entity Relationship Diagram is slightly different. Other than that hope everything is under control.

Q4: How might the problems you are having be solved?

Hopefully refer the textbook and follow the lecture will solve this miner problem I have at the moment.