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 29 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 :)

ktidd

  • Member
  • Posts: 319
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

Never take aspirin without food because it is likely to irritate your stomach. Never give aspirin to children under age 12. Overdoses of aspirin have the potential to cause deafness.

Did you know?

Urine turns bright yellow if larger than normal amounts of certain substances are consumed; one of these substances is asparagus.

Did you know?

The National Institutes of Health have supported research into acupuncture. This has shown that acupuncture significantly reduced pain associated with osteoarthritis of the knee, when used as a complement to conventional therapies.

Did you know?

Asthma attacks and symptoms usually get started by specific triggers (such as viruses, allergies, gases, and air particles). You should talk to your doctor about these triggers and find ways to avoid or get rid of them.

Did you know?

More than 50% of American adults have oral herpes, which is commonly known as "cold sores" or "fever blisters." The herpes virus can be active on the skin surface without showing any signs or causing any symptoms.

Structure of a nucleosome Structure of a nucleosome
Levels of structure in proteins Levels of structure in proteins
11.2 The chemical structure of mescaline, derived from the peyote cactus 11.2 The chemical structure of mescaline, derived from the peyote cactus
Negative Effects of Chronic Stress Negative Effects of Chronic Stress
Rosalind Franklin, shown here on holiday, used X-ray diffraction to investigate the structure of DNA Rosalind Franklin, shown here on holiday, used X-ray diffraction to investigate the structure of DNA
Making recombinant DNA molecules Making recombinant DNA molecules
Video: Double Vacuum Process (Illustration No Audio)

For a complete list of videos, visit our video library