Question

In: Computer Science

Redesigning a database involves the process of reverse engineering a legacy database to create a data...

Redesigning a database involves the process of reverse engineering a legacy database to create a data model. There are a host of software tools available to assist with this process. Identify 2 separate tools that will reverse engineer an existing database. What database management systems (Microsoft SQL, Oracle, MySQL, DB2…) will this system work with (list all that apply)? Briefly describe how the tools work for reverse engineering an existing database and the output that the tool provides.

Solutions

Expert Solution

ANSWER Reverse Engineering of Database-

Reverse database engineering is the process by which the logical and conceptual schemas of an old database or set of files are reconstructed from various sources of information, such as DDL code, data dictionary content, database content, or the source code of the application programs that use the database.

· Separate tools that will reverse engineer an existing database are given below –

1. DATAEDO

2. dbFORGE

· Dataedo works for the following Database Management Systems-

SQL, Oracle, Azure Database, Amazon Redshift

· dbFORGE works for following Database Management Systems-

SQL server, Oracle

Other reverse engineering tools are SchemaSpy, Adminer, Navicat Data Modeler. But dataedo and dbforge are most popular tools.

Dataedo working-

1)To reverse engineer database, go to the Database menu and choose the Reverse Engineer option ...

2) Provide the database connection details and click Next. Wait for the connection and click Next again.

3) When you have successfully logged in, the wizard will show you the list of schemes available on the server. Select the ones you want to reverse.

4) Wait for the diagrams to be read and continue with Next. On the next screen, you have an option to select object types and filter specific objects. Ignore it and import all the objects. Click Execute>.

5) Wait for the reverse technique to occur when you're done with Next. The final screen shows you a summary of the import. Close with Finish.

dbForge working- It uses drag and drop for the reverse engineering process.

Drag and drop is done with the help of visual database representation.

All existing objects and connections will be perfectly reflected in the MySQL database diagram to simplify further analysis.

please give a thumbs up if you are satisfied with my answer. Thank you.


Related Solutions

Database design is the process of producing a detailed data model of database. This data model...
Database design is the process of producing a detailed data model of database. This data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a data definition language, which can then be used to create a database. (Wikipedia). Using a diagram/chart software, elaborate a database design Requirements: Define your database objective Explain your database's type of table relationship Explain and design your database elements and datatypes (tables, fields, etc,)....
What is the relationship between law, ethics, and reverse engineering? Why is reverse engineering a subject...
What is the relationship between law, ethics, and reverse engineering? Why is reverse engineering a subject for regulation or ethical questions?
What type of database software would be ideal for a clinical data warehouse that involves several...
What type of database software would be ideal for a clinical data warehouse that involves several organizations?
Database exercise: inpatient cases Create database using name RUMKIT Create tables below in that database patient(idPatient,...
Database exercise: inpatient cases Create database using name RUMKIT Create tables below in that database patient(idPatient, fullName, biologicalMother, birthdate, address) doctor(idDr, fullName, specialization, consulRates) inpatient(idPatient, entryTime, outTime, idDr, idRoom). Please make entryTime as column that is going to be filled automatically when care record is being add room(idRoom, roomName, cost) fill the data above to each table Create sql query and relational algebra expressions for the query Please give me detailed answer so I could learn from it. Thank you...
Evaluation of an engineering project involves the following constraints ?
Evaluation of an engineering project involves the following constraints ?A) financial, environmental, social and political constraints.B) technical and financial constraints.C) technological and social constraints.D) time and money constraints. E) budget and time constraints.
Engineering/ programming in MATLAB and it also involves a physics
Engineering/ programming in MATLAB and it also involves a physics
Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual...
Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual data model versus Physical data model. Illustrates with help of example to list down data (entities), relationship among data and constraints on data.
Create data for the purchase of an automobile.  There should be 10 automobiles in your database.  You can...
Create data for the purchase of an automobile.  There should be 10 automobiles in your database.  You can get this from the newspaper or go online and find a site that will give you some possible purchases. You should use the following fields:   Manufacturing, Model, Year, Doors, Cylinders and Sales Price. 1. Print the spreadsheet you created for your data. 2. Create and print 2 pivot tables to find some information you need to help you make your decision. 3. Do a VLOOKUP...
Is reverse engineering viewed as a legitimate or illegal act through the lens of the law?
Is reverse engineering viewed as a legitimate or illegal act through the lens of the law?
Debate the ethical issue(s) surrounding reverse engineering in the context of software.
Debate the ethical issue(s) surrounding reverse engineering in the context of software.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT