1. Open and examine the following ERR design file people.mwb a. Each person is described by their name and email. b. Each person can be registered in multiple countries. c. Ensure it is in 3rd normal form. d. 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 a. You may have to modify the data to match your design
SQL: need help with importing txt file into
file contents:
mail,Full Name,Country,Date Registered Carley_Bahringer@destiny.com,Carley Bahringer,Brazil,1987-10-03 22:09:54 Patricia_Fadel@avis.com,Patricia Fadel,Chile,2012-05-10 11:07:49 Sedrick@godfrey.ca,Sedrick Kuphal,Chile,2007-11-12 00:09:53 Briana_Berge@axel.ca,Briana Berge,Iceland,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,France,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,Brazil,2005-12-30 18:24:59 Ozella_Feil@prudence.ca,Ozella Feil,Sweden,2009-06-19 10:32:55
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
