This topic contains a solution. Click here to go to the answer

Author Question: When making any change to the database structure, we may need to check for effects of the change on ... (Read 42 times)

NguyenJ

  • Hero Member
  • *****
  • Posts: 516
When making any change to the database structure, we may need to check for effects of the change on any of the following except ________.
 
  A) data
  B) foreign keys
  C) ad-hoc SQL queries
  D) triggers

Question 2

Briefly describe the process of converting an extended E-R model into a relational database design.
 
  What will be an ideal response?



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

chevyboi1976

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

C

Answer to Question 2

To convert an extended E-R model into a relational database design, first tables and columns must be defined for each entity attribute. The attributes of the entity are represented as the columns of the table. Primary keys are then selected for each table, after which the relationships between the entities are represented through the creation of foreign keys. Next, constraints are specified. Finally the normalization is verified.




NguyenJ

  • Member
  • Posts: 516
Reply 2 on: Jul 7, 2018
:D TYSM


JCABRERA33

  • Member
  • Posts: 344
Reply 3 on: Yesterday
Great answer, keep it coming :)

 

Did you know?

Approximately 70% of expectant mothers report experiencing some symptoms of morning sickness during the first trimester of pregnancy.

Did you know?

Sildenafil (Viagra®) has two actions that may be of consequence in patients with heart disease. It can lower the blood pressure, and it can interact with nitrates. It should never be used in patients who are taking nitrates.

Did you know?

More than 150,000 Americans killed by cardiovascular disease are younger than the age of 65 years.

Did you know?

Illicit drug use costs the United States approximately $181 billion every year.

Did you know?

Human neurons are so small that they require a microscope in order to be seen. However, some neurons can be up to 3 feet long, such as those that extend from the spinal cord to the toes.

For a complete list of videos, visit our video library