Decompose the table into BCNF

Specifications You will decompose a table into BCNF. We wish to create and app with the following specifications: I want to create an app that will let people find the closest concert location of their favorite band. I have access to all the bands and all their performance locations. I would like users to come to my site, create a login, and select their favorite (or favorites!) band(s). Then my app will send the users address, and the address of all the band's venues to Google Maps and Google Maps will find the closest venue! (NOTE: for this assignment, assume that you can talk to the Google API for all the calculations, I just want you to put the following table in BCNF). Here is the database table I have designed for the app. Can you improve it? CREATE TABLE Tour Tracker ( userID INTEGER, userEmail VARCHAR(30), firstName VARCHAR(20), lastName VARCHAR(20), userCity VARCHAR(20), userState VARCHAR(20), user ZIP VARCHAR(5), user ZIP addOn VARCHAR(4),/* the 4 digits after the ZIP */ bandName VARCHAR(50), band TourCity VARCHAR(20), band Tour State VARCHAR(20), band Tour ZIP VARCHAR(5), band Tour ZIP addOn VARCHAR(4) Deliverables You must submit a text file with your SQL "CREATE TABLE" statements. This is the final submission for this work. Specifications You will decompose a table into BCNF. We wish to create and app with the following specifications: I want to create an app that will let people find the closest concert location of their favorite band. I have access to all the bands and all their performance locations. I would like users to come to my site, create a login, and select their favorite (or favorites!) band(s). Then my app will send the users address, and the address of all the band's venues to Google Maps and Google Maps will find the closest venue! (NOTE: for this assignment, assume that you can talk to the Google API for all the calculations, I just want you to put the following table in BCNF). Here is the database table I have designed for the app. Can you improve it? CREATE TABLE Tour Tracker ( userID INTEGER, userEmail VARCHAR(30), firstName VARCHAR(20), lastName VARCHAR(20), userCity VARCHAR(20), userState VARCHAR(20), user ZIP VARCHAR(5), user ZIP addOn VARCHAR(4),/* the 4 digits after the ZIP */ bandName VARCHAR(50), band TourCity VARCHAR(20), band Tour State VARCHAR(20), band Tour ZIP VARCHAR(5), band Tour ZIP addOn VARCHAR(4) Deliverables You must submit a text file with your SQL "CREATE TABLE" statements. This is the final submission for this work