Modifying a database desing in visio

Intro to relational Database Management Systems

10/19/2018

Discussion on the Degree to which my Visio Diagram reflects the Database Design

Diagrammatic representation of a system under development is a very crucial part in software development and design. System design involves communicating and analyzing the system to be developed so as to understand the different interacting activities and features that make up the particular system. When developing a database system, it is very important to analyze the different entities, their attributes, and the relationships between the entities of the database system. This allows the database designer to have a more clear view of the database system.

A popular tool for diagrammatic representing a database system is Microsoft Visio which allows a database designer to deliver Entity Relationship Diagrams (ERPs) which depicts a blueprint for the database system under development. Microsoft Visio allows even the non-technical team to understand the aspects of the database. The database designer is therefore able to ascertain whether the entities, their attributes, and the relationship between the entities are appropriate, sufficient, and represent the actual database system (Rob, Coronel, & Crockett, 2011)

Therefore, through the Microsoft Visio diagram the database designer can communicate effectively to other stakeholders of the database system, the MS Visio diagram also serves the purpose of being a guideline during the phases of implementation and deployment of the database system. This decreases the workload and reduces the complexity towards realizing the complete database system.

References

Rob, P., Coronel, C., & Crockett, K. (2011). Database systems: Design, implementation & management. Australia [etc.: Course Technology.