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 28 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

anyusername12131

  • Member
  • Posts: 327
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

Certain chemicals, after ingestion, can be converted by the body into cyanide. Most of these chemicals have been removed from the market, but some old nail polish remover, solvents, and plastics manufacturing solutions can contain these substances.

Did you know?

Patients who have been on total parenteral nutrition for more than a few days may need to have foods gradually reintroduced to give the digestive tract time to start working again.

Did you know?

Dogs have been used in studies to detect various cancers in human subjects. They have been trained to sniff breath samples from humans that were collected by having them breathe into special tubes. These people included 55 lung cancer patients, 31 breast cancer patients, and 83 cancer-free patients. The dogs detected 54 of the 55 lung cancer patients as having cancer, detected 28 of the 31 breast cancer patients, and gave only three false-positive results (detecting cancer in people who didn't have it).

Did you know?

In the United States, congenital cytomegalovirus causes one child to become disabled almost every hour. CMV is the leading preventable viral cause of development disability in newborns. These disabilities include hearing or vision loss, and cerebral palsy.

Did you know?

Adolescents often feel clumsy during puberty because during this time of development, their hands and feet grow faster than their arms and legs do. The body is therefore out of proportion. One out of five adolescents actually experiences growing pains during this period.

Eudicot leaf development and structure. Eudicot leaf development and structure.
Female reproductive structure and function in humans. Female reproductive structure and function in humans.
Levels of protein structure: Tertiary structure Levels of protein structure: Tertiary structure
Neurotransmitter regulation and dysregulation effects. Neurotransmitter regulation and dysregulation effects.
Hurricane Structure Hurricane Structure
Structure of the retina Structure of the retina
Video: Interview with Person who has Panic Attacks

For a complete list of videos, visit our video library