This topic contains a solution. Click here to go to the answer
« previous next »

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

NguyenJ

  • Hero Member
  • *****
  • Posts: 516
on: Jul 7, 2018
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
Reply #1 on: Jul 7, 2018
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
Great answer, keep it coming :)

mcarey591

  • Member
  • Posts: 365
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

Thyroid conditions cause a higher risk of fibromyalgia and chronic fatigue syndrome.

Did you know?

Approximately 500,000 babies are born each year in the United States to teenage mothers.

Did you know?

A recent study has found that following a diet rich in berries may slow down the aging process of the brain. This diet apparently helps to keep dopamine levels much higher than are seen in normal individuals who do not eat berries as a regular part of their diet as they enter their later years.

Did you know?

About 80% of major fungal systemic infections are due to Candida albicans. Another form, Candida peritonitis, occurs most often in postoperative patients. A rare disease, Candida meningitis, may follow leukemia, kidney transplant, other immunosuppressed factors, or when suffering from Candida septicemia.

Did you know?

Cytomegalovirus affects nearly the same amount of newborns every year as Down syndrome.

The effects of germ-line versus somatic cell mutations. The effects of germ-line versus somatic cell mutations.
Structure of the enzyme chymotrypsin, a globular protein Structure of the enzyme chymotrypsin, a globular protein
Selected Neurotransmitters: Effects and Clinical Applications Selected Neurotransmitters: Effects and Clinical Applications
Pharmacologic effects and indications of adrenergic antagonists: (a) blockade of alpha1 receptors; ... Pharmacologic effects and indications of adrenergic antagonists: (a) blockade of alpha1 receptors; ...
Three-dimensional structure of citrate synthase Three-dimensional structure of citrate synthase
Which of the following is not a valid resonance structure for N3? Which of the following is not a valid resonance structure for N3?
Video: Brief Summary on Photosynthesis - Animation

For a complete list of videos, visit our video library