Author Question: The SQL keyword MODIFY is used to change the structure, properties or constraints of a table. ... (Read 42 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?

The modern decimal position system was the invention of the Hindus (around 800 AD), involving the placing of numerals to indicate their value (units, tens, hundreds, and so on).

Did you know?

There are 20 feet of blood vessels in each square inch of human skin.

Did you know?

Between 1999 and 2012, American adults with high total cholesterol decreased from 18.3% to 12.9%

Did you know?

By definition, when a medication is administered intravenously, its bioavailability is 100%.

Did you know?

The shortest mature adult human of whom there is independent evidence was Gul Mohammed in India. In 1990, he was measured in New Delhi and stood 22.5 inches tall.

For a complete list of videos, visit our video library