Database assignment Example | Topics and Well Written Essays - 2500 words

Database - Assignment ExampleThis whole function has brought a breakthrough in the fields of re- plan, cast and construction. Considering a selective information model, it is a flowchart or draw that brings out the ad hoc relationships present within information values. Effective info management requires that relationships between information be accurately determined and represented. It is therefore a process that should not be ignored. Data models which atomic number 18 efficiently designed allow for identification of errors and misconceptions that might be present in a entropy range. Data moulding has been given different approaches due to its importance. According to Burbank, these approaches include the following Physical data modeling This type of modeling makes use of the current facilities and specific constraints of a particular database management system. It departs database specific kind of representation of a data model. Conceptual data modeling This kind of da ta modeling makes use of concepts and their specific relationships applicable to databases. It explains the nature of a database using a series of assumptions and semantics. Logical data modeling This is a type of data modeling whereby specific data representations of a given caller are explained using relationships and entities. More over, it is not dependent of any specific technology of data management. Enterprise data modeling In this modeling, graphical models are used to represent data in a company. This implies that outputs the likes of XML Schemas (XSD) and Entity Relationship Diagrams (ERDs) are used to provide data model outputs. (Burbank, 2011) In an attempt to make data modeling more efficient and realistic, several(prenominal) data modeling software contain been developed over the past few years. For instance, CA Erwin Data Modeler and Oracle Data Modeler are several(prenominal) of the modeling software that are now widely used all over the world. These two programs have made data modeling more efficient, faster and cheaper than using the conventional methods. This paper will provide deeper insight on both Erwin and Oracle data modeler shots. The two programs will also be compared and their key features and functionalities outlined. Overview of CA Erwin Data Modeler Erwin data modeler is a data modeling tool used to perform the same function by several companies and organizations. There are also several other companies that uses the same data modeler throughout the globe. This program was initially developed by a renowned software developer known as Logic Works. Platinum Technology later purchased it in 1998. In 1999, Computer Associates purchased Platinum and is the same company that directly markets it. As a modern data modeling software, Erwin control a wide variety of database design functions that encompasses the following Data modeling Forward engineering (This involves the process of creating a specific physical database and database s chema model while relying on the grounds of data model) Reverse engineering(Where data models are created in regards to a pre-existing model of data) These functions are applicable in Erwin for various relational database hierarchical structures that cover a wide variety of used databases (Burbank, 2011). Erwin can be used to perform data modeling for different types of databases like information systems, database transactional systems, data marts and several others. Erwin support various displays of diagrams drawn or structured from different perspectives. For instance, it allows for viewing and manipulation of