MySQL Workbench Help:

1) Examine the following ERR design file people.mwb that is shown above.

Please adjust and make changes to the design file according the requirements below.

-Each person is described by their name and email.

-Each person can be registered in multiple countries.

-Ensure it is in 3^rd normal form.

-Ensure the relationships and primary and foreign keys are correct.

2) Create a database from the design.

3) Import the following data into the database people.txt

people.txt is shown below:

Email,Full Name,Country,Date Registered Carley_Bahringer@destiny.com,Carley Bahringer,Papua New Guinea,1987-10-03 22:09:54 Patricia_Fadel@avis.com,Patricia Fadel,Saint Lucia,2012-05-10 11:07:49 Sedrick@godfrey.ca,Sedrick Kuphal,Chile,2007-11-12 00:09:53 Briana_Berge@axel.ca,Briana Berge,Nicaragua,2006-03-26 15:32:08 Lucy_Lockman@abby.org,Lucy Lockman,Iceland,2014-02-13 10:26:57 Lucy_Lockman@abby.org,Lucy Lockman,Germany,1999-02-12 00:14:54 Ayden_Flatley@colin.biz,Ayden Flatley,France,1987-01-23 21:43:22 Alec.Boyle@aurore.co.uk,Alec Boyle,Brazil,2007-08-23 13:42:41 Ozella_Feil@prudence.ca,Ozella Feil,Lesotho,2005-12-30 18:24:59 Ozella_Feil@prudence.ca,Ozella Feil,Sweden,2009-06-19 10:32:55 

You may have to modify the data to match your design

4) Execute the following commands and save the results.

-SHOW TABLES

-Execute DESCRIBE for each table in the database

-Export the database using MySQL Workbench