
Before I start studying Database
Design I did not realize that actually I already had contact with database
every day. In the first days of class, I was impressed with the importance that
database has on our daily life, especially because it can help how to better
organize data for a sustainable project for example. In the last 10 meetings I
acquired a lot of knowledge, which makes me feel really good about our class.
Even though sometimes I get confused with some exercises, I understand that
this class is a differential for my professional career. The most important
concepts that I learned was the difference between an actual database and a
dataset. I could see the reason why Excel can not be so efficient as Access to
manipulate data. In Excel there is no way to establish relationships between
tables (entities), and because of this, it is necessary to repeat the data in
many places. In addition, we spend much more time to update information and we
are vulnerable to make mistakes. It leads to anomalies and a very inconsistent
dataset.
The second concept that I learned is
that there is a Logical Design and a Physical Design. In the Logical Design we
built a model, where it is possible to have many-to-many relationships. But,
when we translate to the database (physical) there is no longer the possibility of a
many-to-many relationship exist. So, we have to break in two one-to-many
relationships.
Another perception that I had, is
that there are different languages for modeling a database. The most populars
are the ER Diagram and UML Diagram. During the classes we worked with both
languages, so I could understand the vocabulary used in those models. This is a
very good perspective that the students can have of models.
All these approaches have a very
important meaning for me, because now I am able to understand how to develop a
good database, eliminating anomalies. Even though I am not a Business major
person, I plan to open my own business in the future, so this class provides me
tools to better manage my future company's database.
No comments:
Post a Comment