Author Question: When making any change to the database structure, we may need to check for effects of the change on ... (Read 95 times)

NguyenJ · **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?

chevyboi1976 · **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.