Deck 20: Getting Started With MySQL Workbench Data Modeling Tools

Question 1

In the MySQL Table Editor,the abbreviation PK stands for partial key.

Answer 1

False

Question 2

The MySQL Workbench EER models are data models.

Answer 2

False

Question 3

To create a new MySQL Workbench EER model,you can use the File | New Model command.

Answer 3

True

Question 4

Table names are edited in the MySQL EER Component Editor.

Question 5

The MySQL Installer for Windows can be used to install the MySQL Workbench.

Question 6

In the MySQL Table Editor,the abbreviation NN stands for NOT NULL.

Question 7

The installation of the MySQL Community Edition 5.5 always includes the installation of the MySQL Workbench.

Question 8

Users should create a MySQL Workspace folder to hold documents created with the MySQL Workbench.

Question 9

Table column data is edited in the MySQL Table Editor.

Question 10

In the MySQL Workbench,a 1:N non-identifying relationship between two tables that already contain the needed primary and foreign keys is created using the Place a Relationship Using Existing Columns button.

Question 11

Users should create a Data Models folder to hold EER models created with the MySQL Workbench.

Question 12

To create a new MySQL Workbench EER model,you can use the Create new EER Model link on the Home page.

Question 13

In order to create MySQL ERR diagrams,users must log into MySQL using the Connect to Database and the Connect to MySQL Server dialog boxes.

Question 14

The MySQL Installer for Linux can be used to install the MySQL Workbench.

Question 15

In the MySQL Table Editor,the abbreviation AI stands for AUTO_INCREMENT.

Question 16

The MySQL Installer for Windows should be used to install MySQL Community Edition components on computers running which operating systems?

A)Microsoft Windows
B)Unix
C)Linux
D)Either B or C.
E)Any of the above.

Question 17

The authors recommend using which of the following folder structures with the MySQL Workbench?

A)..\MyDocumnets\MySQL Workbench.
B)..\MyDocumnets\MySQL Workbench\Schemas.
C)..\MyDocumnets\MySQL Workbench\EER Models.
D)Both A and B.
E)All of the above.

Question 18

In the MySQL Workbench,a 1:N non-identifying relationship between two tables that already contain the needed primary and foreign keys is created using the 1:N Non-identifying Relationship button.

Question 19

In the Windows OS,to start working with the MySQL Workbench use the command Start | All Programs | MySQL | MySQL Workbench 5.2 CE.

Question 20

To add a table to a database design,click the Place a New Table button,move the cursor to the diagram area and click the left mouse button.

Question 21

Describe the MySQL Connector/ODBC and how to install it.

Question 22

In the MySQL Table Editor,the abbreviation for Primary Key is:

A)PK.
B)NN.
C)UQ.
D)BIN.
E)AI.

Question 23

Describe how to create a new database design in the MySQL Workbench.

Question 24

In the MySQL Workbench,a 1:N identifying relationship between two tables that already contain the needed primary and foreign keys is created using:

A)the 1:N Identifying Relationship button.
B)the 1:N Non-identifying Relationship button.
C)the N:M Identifying Relationship button.
D)the Place a Relationship Using Existing Columns button.
E)None of the above is correct.

Question 25

In order to use MySQL Workbench to create database designs,you must log into MySQL using:

A)the Connect to Database dialog box.
B)the Connect to MySQL Server dialog box.
C)the MySQL | Connect to Server command.
D)Both A and B are used together.
E)None of the above is correct - no login is required.

Question 26

Describe how to add a table object to a MySQL Workbench database design.

Question 27

The MySQL Workbench can be used to create:

A)data models.
B)data designs.
C)database models.
D)database designs.
E)database diagrams.

Question 28

By default,the E-R diagrams created in the MySQL Workbench use:

A)IE Crow's Foot notation.
B)IDEF1X notation.
C)UML notation.
D)Microsoft Visio 2010 Arrow notation.
E)None of the above is correct.

Question 29

In the MySQL Workbench,a 1:N non-identifying relationship between two tables that already contain the needed primary and foreign keys is created using:

A)the 1:N Identifying Relationship button.
B)the 1:N Non-identifying Relationship button.
C)the N:M Identifying Relationship button.
D)the Place a Relationship Using Existing Columns button.
E)None of the above is correct.

Question 30

To place a table in a MySQL database design,start by clicking the:

A)Table button.
B)Entity button.
C)Place a New Table button.
D)Place a New Entity button.
E)None of the above.

Question 31

In the MySQL Table Editor,the abbreviation for AUTO_INCREMENT is:

A)PK.
B)NN.
C)UQ.
D)BIN.
E)AI.

Question 32

Describe how to create relationships in a MySQL Workbench database design.

Question 33

In the MySQL Table Editor,the abbreviation for NOT NULL is:

A)PK.
B)NN.
C)UQ.
D)BIN.
E)AI.

Question 34

To create a new MySQL Workbench EER model,you can use:

A)the Create new EER Model link on the Home page.
B)the File | New Model command.
C)the Start new EER command.
D)A or B
E)All of the above.

Question 35

In the MySQL Workbench,a 1:N non-identifying relationship between two tables that do not contain the needed primary and foreign keys is created using:

A)the 1:N Identifying Relationship button.
B)the 1:N Non-identifying Relationship button.
C)the N:M Identifying Relationship button.
D)the Place a Relationship Using Existing Columns button.
E)None of the above is correct.

Question 36

In the MySQL Workbench,a 1:N identifying relationship between two tables that do not contain the needed primary and foreign keys is created using:

A)the 1:N Identifying Relationship button.
B)the 1:N Non-identifying Relationship button.
C)the N:M Identifying Relationship button.
D)the Place a Relationship Using Existing Columns button.
E)None of the above is correct.

Question 37

Describe how to set table properties in a MySQL Workbench database design.