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 84 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
:D TYSM

miss.ashley

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

« previous next »
 

Did you know?

Most strokes are caused when blood clots move to a blood vessel in the brain and block blood flow to that area. Thrombolytic therapy can be used to dissolve the clot quickly. If given within 3 hours of the first stroke symptoms, this therapy can help limit stroke damage and disability.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

Persons who overdose with cardiac glycosides have a better chance of overall survival if they can survive the first 24 hours after the overdose.

Did you know?

The term pharmacology is derived from the Greek words pharmakon("claim, medicine, poison, or remedy") and logos ("study").

Did you know?

Chronic necrotizing aspergillosis has a slowly progressive process that, unlike invasive aspergillosis, does not spread to other organ systems or the blood vessels. It most often affects middle-aged and elderly individuals, spreading to surrounding tissue in the lungs. The disease often does not respond to conventionally successful treatments, and requires individualized therapies in order to keep it from becoming life-threatening.

Structure of fish gills. Structure of fish gills.
Structure of a hair and its associated sebaceous gland. Structure of a hair and its associated sebaceous gland.
Structure of collagen Structure of collagen
The effects of aging can be seen in the decline in function of many physiological systems. The effects of aging can be seen in the decline in function of many physiological systems.
Levels of protein structure. Levels of protein structure.
Climate Change Climate Change
Video: Adolescent Diabetes

For a complete list of videos, visit our video library