- Open and examine the following ERR design file people.mwb
- 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 people.txt
- 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 Workbench
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-management.html
- Each part; the correct design, correct database, imported data, and execute commands is each worth 25% of the homework grade.
- Submit the updated design file, saved results file, and the exported database file.
YourLastName_people.mwb
YourLastName_p2.txt
YourLastName_database.txt