Author Question: To start working with MySQL Community Edition in Windows, use the command Start All Programs MySQL ... (Read 133 times)

wrbasek0 · **on:** Jul 7, 2018

To start working with MySQL Community Edition in Windows, use the command Start All Programs MySQL MySQL Workbench CE 6.2. (or the version number you have installed).

Indicate whether the statement is true or false

Question 2

When transforming an ID-dependent E-R data model relationship into a relational database design and the parent entity has a surrogate primary key and the child entity has a data identifier, then the primary key of the child table should be ________.

A) the parent's surrogate key + the child's data key
B) the parent's surrogate key + a surrogate key in the child
C) either A or B will work, but method A is preferable
D) either A or B will work, but method B is preferable