Question

After completing assignment 2. You have now created models and databases using two different modelling approaches (REA model and Logical or physical model).

What have you learned?

How would you summarize your experiences?

What is the value of this knowledge when related to activities in your workplace?

Answer 1

What have you learned?

I learned the methods to create a model which is like the building block that helps in planning the initial model and the reation between the data for data that needs to be stored in the database. Making data models will help me to represent data objects and the association between the data. It also helps in maintaining consistency in creating and naming variables and also ensure semantics and security of data. It also helped me understand the types of data models and the various rules that must be followed by constructing them. The logical model aims to define the structure of data and the relationship between them. Whereas the REA model focuses on establishing entities and attributes of the table and establish a relationship between them.

How would you summarize your experiences?

The overall experience can be summarized as the assignment and course were very informative and helped me a lot in understanding the semantics of the data models which will help me create an effective association between the data while making data models.

What is the value of this knowledge when related to activities in your workplace?

Using the data models, we can construct effective model for storing large amount of data in the workplace. The data stored can be made more consistent and secure and the quality of data an be ensured. Following the structure of the data model will help us ensure a robust model that will prevent loss of data and ensure the security of data. It will also make modifications in the model more agile for further development and changes. This will also make the communication within the organization effective.