Open and examine the following ERR design that is provided in the image attached to the question. Each person is described by their name and email. Each person can be registered in multiple countries. Ensure it is in 3rd normal form. Ensure the relationships and primary and foreign keys are correct. Create a database from the design. Import the following data into the database : Email,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 a.You may have to modify the data to match your design Execute the following commands and save the results. SHOW TABLES Execute DESCRIBE for each table in the database Export the database using MySQL

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Open and examine the following ERR design that is provided in the image attached to the question.
1. Each person is described by their name and email.
2. Each person can be registered in multiple countries.
3. Ensure it is in 3^rd normal form.
4. Ensure the relationships and primary and foreign keys are correct.
Create a database from the design.
Import the following data into the database : Email,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 a.You may have to modify the data to match your design
Execute the following commands and save the results.
1. SHOW TABLES
2. Execute DESCRIBE for each table in the database
3. Export the database using MySQL Workbench using the following link https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-management.html

MySQL Workbench
Local instance MySQL80 X
File Edit View Arrange Model
Bird's Eye *********
Zoom: 100%
Catalog Tree ******
mydb
2
Tables
Views
Routine Groups
#
Catalog Layers User Types
Description Editor ***********************
No Selection
Type here to search
MySQL Model (people (3).mwb) X
Database Tools
Diagram *************
4
4
[
N
■ 喵喵
E
IF Y³ | Y³ X² XE
Scripting Help
&
EER Diagram x
People
?idPeople INT
name VARCHAR(45)
email VARCHAR(45)
Indexes
015
De
1'
2
W
Registration
idRegistration INT
Country 1 VARCHAR(45)
Country2 VARCHAR(45)
Country3 VARCHAR(45)
Registered 1 DATETIME
>Registered2 DATETIME
Registered 3 DATETIME
Indexes
+
*
PDF
A
MWB
MWB
Modeling Additions s
MWB
I G
10
timestamps
create_time, update_time
user
username, email, passwor...
category
category_id, name
ENG
X
10:59 PM
■

Expert Solution

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions