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 72 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
Excellent

Laurenleakan

  • Member
  • Posts: 309
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

There are over 65,000 known species of protozoa. About 10,000 species are parasitic.

Did you know?

Addicts to opiates often avoid treatment because they are afraid of withdrawal. Though unpleasant, with proper management, withdrawal is rarely fatal and passes relatively quickly.

Did you know?

Looking at the sun may not only cause headache and distort your vision temporarily, but it can also cause permanent eye damage. Any exposure to sunlight adds to the cumulative effects of ultraviolet (UV) radiation on your eyes. UV exposure has been linked to eye disorders such as macular degeneration, solar retinitis, and corneal dystrophies.

Did you know?

Limit intake of red meat and dairy products made with whole milk. Choose skim milk, low-fat or fat-free dairy products. Limit fried food. Use healthy oils when cooking.

Detailed aquaporin structure. Detailed aquaporin structure.
Motifs of protein secondary structure Motifs of protein secondary structure
Touch the test light to the negative (–) terminal of the battery or a good engine ground to check ... Touch the test light to the negative (–) terminal of the battery or a good engine ground to check ...
Accounting (Making Entries) Accounting (Making Entries)
The effects of a single crossover in a paracentric inversion heterozygote The effects of a single crossover in a paracentric inversion heterozygote
Structure of the small intestine. Structure of the small intestine.
Video: Simple Diffusion - gases and nonpolar compounds transport

For a complete list of videos, visit our video library