Please help me with this assignment 1. Open and examine the following ERR design file people.mwb (https://acconline.austincc.edu/bbcswebdav/pid-18686108-dt-content-rid-70255490_1/xid-70255490_1) 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 (have to modify the data to match the design) people.txt 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 4. Execute the following commands and save the results. a. SHOW TABLES b. Execute DESCRIBE for each table in the database c. Export the database using MySQL Workbench https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-management.html Have to updated design file, saved results file, and the exported database file. YourLastName_people.mwb YourLastName_p2.txt

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

Please help me with this assignment

1. Open and examine the following ERR design file people.mwb (https://acconline.austincc.edu/bbcswebdav/pid-18686108-dt-content-rid-70255490_1/xid-70255490_1)

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 (have to modify the data to match the design)

people.txt

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

4. Execute the following commands and save the results.
a. SHOW TABLES
b. Execute DESCRIBE for each table in the database
c. Export the database using MySQL Workbench
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-management.html

Have to updated design file, saved results file, and the exported database file.
YourLastName_people.mwb
YourLastName_p2.txt
YourLastName_database.txt

MYSQL Workbench
合
MYSQL Model (people.mwb)
EER Diagram x
File
Edit
View Arrange Model
Database
Tools Scripting Help
Bird's Eye
Diagram
Modeling Additions
Zoom: 100% - Q Q
timestamps
MWB
create_time, update_time
user
MWB
username, email, password, create.
category
O People
MWB
Registration
category_id, name
P idPeople INT
idRegistration INT
Catalog Tree
O name VARCHAR(45)
O Country 1 VARCHAR(45)
O email VARCHAR(45)
O Country2 VARCHAR(45)
vA mydb
Indexes
O Country3 VARCHAR(45)
Tables
O Registered1 DATETIME
Views
A Routine Groups
ORegistered2 DATETIME
O Registered3 DATETIME
1:1
Indexes
Catalog Layers User Types
1:n
Description Editor
1:1
No Selection
1:n
n:m
1:n
Description Properties
H
Templates
Ready
目
10:39 PM
P Type here to search
71°F Cloudy ^ o O 4x ENG
12/5/2021
| ロ a圈■ 圆

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,0zella Feil,Brazil,2005-12-30 18:24:59
Ozella_Feil@prudence.ca,0zella Feil, Sweden, 2009-06-19 10:32:55

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 3 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