Database Processing, 15e (Kroenke)
Appendix E: Getting Started with MySQL Workbench Data Modeling
1) The installation of the MySQL 5.7 Community Server always includes the installation of the
MySQL Workbench.
2) The MySQL Installer for Windows can be used to install the MySQL Workbench.
3) The MySQL Installer for Linux can be used to install the MySQL Workbench.
4) In Windows 10, to start working with the MySQL Workbench use the command Start | All
Programs | MySQL | MySQL Workbench 6.3 CE.
5) In order to create MySQL EER diagrams, users must log into MySQL using the Connect to
Database and the Connect to MySQL Server dialog boxes.
6) Users should create a MySQL Workbench folder to hold documents created with the MySQL
Workbench.
7) Users should create a folder to hold EER models created with the MySQL Workbench.
8) The MySQL Workbench EER models are data models.
9) To create a new MySQL Workbench EER model, you can click the New Model button from
the MySQL Workbench.
10) In the MySQL Table Editor, the abbreviation AI stands for Artificial Intelligence.
11) To add a table to a database design, click the Place a New Table button, move the cursor
over the blank diagram area and click the left mouse button.
12) Table names are edited in the MySQL EER Component Editor.
13) Table column characteristics can be edited in the MySQL Table Editor.
14) In the MySQL Table Editor, the abbreviation PK stands for partial key.
15) In the MySQL Table Editor, the abbreviation NN stands for NOT NULL.
16) In the MySQL Table Editor, the abbreviation AI stands for AUTO_INCREMENT.
17) 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.
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 Place a Relationship
Using Existing Columns button.
19) The MySQL Installer for Windows should be used to install MySQL Connector/ODBC
components on computers running which operating system(s)?
A) Microsoft Windows
B) Unix
C) Linux
D) Both B and C are correct
20) The authors recommend using which of the following folder structures with the MySQL
Workbench?
A) ..\MyDocuments\MySQL Workbench\EER Models
B) ..\MyDocuments\MySQL Workbench\Schemas
C) ..\MyDocuments\MySQL Workbench\Databases
D) Both A and B are correct.
21) In Windows, 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) No login is required
22) To create a new MySQL Workbench EER model, you can ________.
A) click the New Model button in the Models window
B) use the File | New Model command
C) the Start new EER command
D) Both A or B are correct
23) 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
24) In the MySQL Table Editor, the abbreviation for NOT NULL is ________.
A) PK
B) NN
C) UQ
D) BIN
25) In the MySQL Table Editor, the abbreviation for Primary Key is ________.
A) PK
B) NN
C) UQ
D) AI
26) In the MySQL Table Editor, the abbreviation for AUTO_INCREMENT is ________.
A) PK
B) NN
C) UQ
D) AI
27) 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
28) 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
29) 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
30) 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
31) The MySQL Workbench can be used to create ________.
A) data models
B) data designs
C) database models
D) database designs
32) 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 2013 Arrow notation
33) Describe how to get started creating a new database design in the MySQL Workbench.
34) Describe how to add a table object to a MySQL Workbench database design.
35) Describe how to create the columns in a table in a MySQL Workbench database design.
36) Describe how to create relationships in a MySQL Workbench database design.
37) Describe the MySQL Connector/ODBC and how to install it.