Database System Design

Running head: DATABASE SYSTEM DESIGN
Database System Design
Name of the Student
Name of the University
Author’s Note:

1DATABASE SYSTEM DESIGN
My experience while developing the ER Diagram was very good. I was able to
implement the ERD as per the conventional standard. I did not have good idea about database
models when I started designing the Entity Relationship Diagram. I later found out that there are
two types of ER Diagrams. The first one that I came across is crow's foot database notation and
the other one is chen's database notation. I learned about designing both kind of database models.
However, the crow's foot database notation, I think, is more effective in terms of reading and
understanding. This is because, a lot of attributes can be included in the crow's foot database
notation in a structured way. The overall space required for designing the database reduces
significantly when attribute space reduces.
After I learned about basic about the data models, then I came across the concept of
normalization. In the normalization process, I learned that most of the database can fulfill the
system requirements if all the entities are in third normal form. There is no need to normalize the
database up to BCNF. At the time when I started understanding second normal form, I realized
that having the proper knowledge about dependency is essential for normalization. Then I
learned about fully functional, partial and transitive dependency. Various books and tutorials
provided different types of examples on transitive dependency. The real life scenario of each of
those examples were different so I had issues in learning transitive dependency. However, I
learned about the transitive dependency after I started designing the ER diagram of the
AutoSeller database.
The last things that I learn during the ER Diagram designing is that having proper idea of
database management system only can allow a designer to perfectly design the ERD. There is
always room for errors in ER diagram design. However, an experienced designer would have