Database Modeling After reading this week’s article, “Modeling for the Future,”

Question

Database Modeling After reading this week’s article, “Modeling for the Future,” expand on the subject of Database Modeling. There are several tools listed and reviewed in the article. Research these tools further (or identify other commercially available modeling tools), compare three tools, and apply your findings as if you were selecting one of the tools for use at your place of employment. Be sure to include comparative detail information on implementation scenarios, target industries, company types most suited for the tool, costs, software type, the type of operating system required, and the target user population. Select one of the tools previously compared, and discuss the benefits and the shortcomings. Discuss how this tool will help meet the data modeling requirements for your employer’s database development needs. Be sure to integrate vocabulary from the text to demonstrate your understanding of concepts. In addition to the article, include a website reference for each of the three tools you research. The website references must come from the software vendor or other credible source.

Explanation / Answer

comparing CA ERwin , Database Workbench , ER/Studio

       CA ERwin

Platform Support

          Windows

database environments

CA ERwin Data Modeler

(ERwin) is a software tool for data modeling (data requirements analysis, database design etc.) of custom developed information systems, including databases of transactional systems and data marts.

Distinguishing features

Limitations

Versions prior to CA ERwin Data Modeler 9.2 had only been certified on the 32-bit versions of the Windows operating systems.

       CA ERwin

Database   Workbench      ER/Studio

Platform Support

          Windows

Windows, Linux and FreeBSD (both through Wine)      Windows

database environments

Access, IBM DB2, Informix, Ingres, MySQL, Oracle, Progress, MS SQL Server, Sybase, Teradata MS SQL Server, MySQL, Oracle, Firebird, InterBase, SQL Anywhere, NexusDB, MariaDB Access, IBM DB2, Informix, Hitachi HiRDB, Firebird, Interbase, MySQL, MS SQL Server, Netezza, Oracle, PostgreSQL, Sybase, Teradata, Visual Foxpro and others via ODBC/ANSI SQL target bussiness size SMBs and enterprises SMBs and enterprises SMBs and enterprises creator CA Technologies Upscene Productions Embarcadero supported data models Conceptual, logical, physical Conceptual, logical, physical Conceptual, logical, physical, ETL forward engineering yes yes yes reverse engineering yes yes yes

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.