Exam 20: Getting Started With MySQL Workbench Data Modeling Tools

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

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

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

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

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

Table names are edited in the MySQL EER Component Editor.

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

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

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

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

Table column data is edited in the MySQL Table Editor.

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.

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

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

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 Windows OS,to start working with the MySQL Workbench use the command Start | All Programs | MySQL | MySQL Workbench 5.2 CE.