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

ryansturges

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

« previous next »
 

Did you know?

ACTH levels are normally highest in the early morning (between 6 and 8 A.M.) and lowest in the evening (between 6 and 11 P.M.). Therefore, a doctor who suspects abnormal levels looks for low ACTH in the morning and high ACTH in the evening.

Did you know?

Sperm cells are so tiny that 400 to 500 million (400,000,000–500,000,000) of them fit onto 1 tsp.

Did you know?

Everyone has one nostril that is larger than the other.

Did you know?

During the twentieth century, a variant of the metric system was used in Russia and France in which the base unit of mass was the tonne. Instead of kilograms, this system used millitonnes (mt).

Did you know?

On average, the stomach produces 2 L of hydrochloric acid per day.

Evolutionary change in the tetrapod lineage, showing a transitional form. Evolutionary change in the tetrapod lineage, showing a transitional form.
Structure of collagen Structure of collagen
Natural Causes of Climate Change Natural Causes of Climate Change
Structure of the bacterial flagellar motor from Salmonella enterica Structure of the bacterial flagellar motor from Salmonella enterica
The secondary structure of amylose The secondary structure of amylose
Binding change model for ATP synthase Binding change model for ATP synthase
Video: Types of Shock (Part 2 of 2)

For a complete list of videos, visit our video library