Exam 17: Getting Started With MySQL Workbench Data Modeling Tools

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

The MySQL Workbench can be used to create:

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

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:

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

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

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

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:

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

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

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

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

Table names are edited in the MySQL EER Component Editor.

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

Table column data is edited in the MySQL Table Editor.

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

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.