Author Question: The SQL keyword MODIFY is used to change the structure, properties or constraints of a table. ... (Read 64 times)

rayancarla1

  • Hero Member
  • *****
  • Posts: 571
The SQL keyword MODIFY is used to change the structure, properties or constraints of a table.
 
  Indicate whether the statement is true or false

Question 2

What is reverse engineering and how well does it work?
 
  What will be an ideal response?



krakiolit

  • Sr. Member
  • ****
  • Posts: 318
Answer to Question 1

FALSE

Answer to Question 2

Reverse engineering (RE) is the process of reading the database schema of an existing database and using it to reconstruct a data model of the database. It works fairly well, but does have significant limitations. First, RE produces conceptual schema errors because it creates an entity for every table in the database including intersection tables in N:M relationships which would not be an entity in the original data model. Second, it does not generate internal schema information such as referential integrity constraints. Therefore, the result, which the authors call the RE data model, is a good starting point for analyzing an existing database but is not a complete solution.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Addicts to opiates often avoid treatment because they are afraid of withdrawal. Though unpleasant, with proper management, withdrawal is rarely fatal and passes relatively quickly.

Did you know?

The most common childhood diseases include croup, chickenpox, ear infections, flu, pneumonia, ringworm, respiratory syncytial virus, scabies, head lice, and asthma.

Did you know?

Approximately one in three babies in the United States is now delivered by cesarean section. The number of cesarean sections in the United States has risen 46% since 1996.

Did you know?

Always store hazardous household chemicals in their original containers out of reach of children. These include bleach, paint, strippers and products containing turpentine, garden chemicals, oven cleaners, fondue fuels, nail polish, and nail polish remover.

Did you know?

More than 2,500 barbiturates have been synthesized. At the height of their popularity, about 50 were marketed for human use.

For a complete list of videos, visit our video library