DATABASE DESIGN: Normalization. Assignment 6.

PURPOSE: Normalize the Database from students projects.

1. Firstly, you will need to use knowledge from past lectures and lessons to enter data into your all 15 tables.(min 20 rows).
2. You will normalize these tables from your project to 3NF. You need to parse each table against each normal form (1NF, 2NF, 3NF). The analysis must be described and justified.

CREATE TABLE `myTable` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `name` varchar(255) default NULL, `phone` varchar(100) default NULL, `email` varchar(255) default NULL, `address` varchar(255) default NULL, `region` varchar(50) default NULL, `country` varchar(100) default NULL, PRIMARY KEY (`id`) ) AUTO_INCREMENT=1;

INSERT INTO `myTable` (`name`,`phone`,`email`,`address`,`region`,`country`) VALUES ("Kuame Evans","1-960-718-8565","curabitur.dictum@icloud.ca","P.O. Box 632, 6106 Odio Avenue","Oyo","Netherlands"), ("Dolan Christian","(636) 741-2674","ut@hotmail.edu","Ap #612-9486 Eget St.","Khyber Pakhtoonkhwa","South Korea"), ("Sylvia Bond","1-601-458-6831","gravida.mauris.ut@protonmail.edu","975-6469 Tristique Av.","South Island","United States"), ("Laith Juarez","1-254-775-6787","orci.sem@hotmail.org","829-3649 Sed Street","North Island","France"), ("Kelly Osborne","1-516-942-6767","adipiscing@outlook.com","525-7527 Adipiscing Rd.","Jalisco","Russian Federation"), ("Owen Holt","1-433-445-7486","nisi.cum@protonmail.com","866-3371 Molestie Road","Haryana","France"), ("Medge Stokes","1-172-966-6511","libero.donec.consectetuer@aol.org","P.O. Box 562, 2079 Eu Avenue","Lagos","South Korea"), ("Chandler Schultz","1-723-473-5263","feugiat.metus@google.couk","6740 Pellentesque Avenue","Lazio","Sweden"), ("Britanney Terrell","1-816-281-0187","condimentum.eget@aol.net","641-398 Consequat, Rd.","Dngbi","Canada"), ("Geoffrey Flowers","(807) 693-9254","est@outlook.edu","Ap #342-8061 Quis, Street","Slskie","Belgium"); INSERT INTO `myTable` (`name`,`phone`,`email`,`address`,`region`,`country`) VALUES ("Arthur Burns","(484) 714-8767","lobortis.quis.pede@hotmail.couk","2908 Ultricies Road","Pernambuco","Colombia"), ("Wendy Lester","(468) 154-2818","vel.est@outlook.edu","871-2451 Sem Av.","San Jos","Turkey"), ("Noelani Valenzuela","1-682-266-3364","est.congue.a@google.net","105-2055 Et Ave","Calabria","Vietnam"), ("Genevieve Spencer","1-292-323-8611","et@aol.couk","678-4581 Aliquam Street","Utah","United Kingdom"), ("Karina Riggs","(236) 364-0658","magna@icloud.couk","207-2632 Sodales Avenue","Haryana","Mexico"), ("Leila Olsen","1-663-371-3666","enim.mauris@yahoo.edu","P.O. Box 687, 765 Montes, Avenue","Bc Ninh","Chile"), ("Aretha Gardner","1-869-877-7186","eu.augue.porttitor@icloud.couk","Ap #363-2683 Felis. Road","North Island","Poland"), ("Florence Townsend","(860) 434-5024","lobortis@aol.net","Ap #534-2680 A, Road","Umbria","France"), ("Bryar Robbins","(687) 587-2867","elit@hotmail.couk","P.O. Box 465, 7911 Nisi. St.","Araucana","Costa Rica"), ("Callum Pickett","1-512-831-2770","feugiat.lorem@google.com","1246 Vitae St.","Trentino-Alto Adige","United States");