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
[email protected],Carley Bahringer,Brazil,1987-10-03 22:09:54
[email protected],Patricia Fadel,Chile,2012-05-10 11:07:49
[email protected],Sedrick Kuphal,Chile,2007-11-12 00:09:53
[email protected],Briana Berge,Iceland,2006-03-26 15:32:08
[email protected],Lucy Lockman,Iceland,2014-02-13 10:26:57
[email protected],Lucy Lockman,France,1999-02-12 00:14:54
[email protected],Ayden Flatley,France,1987-01-23 21:43:22
[email protected],Alec Boyle,Brazil,2007-08-23 13:42:41
[email protected],Ozella Feil,Brazil,2005-12-30 18:24:59
[email protected],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
Extracted text: 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圈■ 圆
Extracted text: Email, Full Name, Country, Date Registered
[email protected], Carley Bahringer, Brazil,1987-10-03 22:09:54
[email protected],Patricia Fadel, Chile, 2012-05-10 11:07:49
[email protected],Sedrick Kuphal,Chile, 2007-11-12 00:09:53
[email protected],Briana Berge, Iceland, 2006-03-26 15:32:08
[email protected], Lucy Lockman, Iceland, 2014-02-13 10:26:57
[email protected], Lucy Lockman, France, 1999-02-12 00:14:54
[email protected],Ayden Flatley, France, 1987-01-23 21:43:22
[email protected],Alec Boyle, Brazil, 2007-08-23 13:42:41
[email protected],0zella Feil,Brazil,2005-12-30 18:24:59
[email protected],0zella Feil, Sweden, 2009-06-19 10:32:55