Author Question: To run an SQL script or SQL command in MySQL Server Community Edition: A) click the Execute ... (Read 80 times)

stephzh · **on:** Jul 7, 2018

To run an SQL script or SQL command in MySQL Server Community Edition:

A) click the Execute button on the Query Toolbar.
B) click the Execute button on the Browser Toolbar.
C) click the Run button on the Query Toolbar.
D) click the Run button on the Browser Toolbar.
E) click the Execute SQL Script button on the Toolbar.

Question 2

Why do databases need redesigning?

What will be an ideal response?

jessicaduplan · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

E

Answer to Question 2

Databases need redesigning for two reasons. First, it is not always easy to build a database correctly the first time, and changes in an organization's business process may create the need for a change. With regards to the first reason, even if the data modeling process captured all the users' requirements, translating the requirements into a correct data model and database design can be difficult. Almost inevitably, there will be errors that need to be corrected. With regards to the second reason, information systems and the organizations that use them influence each other to the point where they can be said to create each other. As the organization changes so will the user requirements, which will necessitate database redesign.