Exam 19: Getting Started With Mysql Workbench Data Modeling Tools

In the MySQL Table Editor,the abbreviation for Primary Key is ________.

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 ________.

In Windows,to use MySQL Workbench to create database designs,you must log into MySQL using ________.

Describe how to get started creating a new database design in the MySQL Workbench.

The MySQL Workbench EER models are data models.

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.

In the MySQL Table Editor,the abbreviation for NOT NULL is ________.

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

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

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

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 ________.

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 the MySQL Table Editor,the abbreviation for AUTO_INCREMENT is ________.

The installation of the MySQL Community Edition 5.6 always includes the installation of 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 the Place a Relationship Using Existing Columns button.

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.

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