Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 TourTracker userID INTEGER, userEmail VARCHAR(30), firstName VARCHAR(20), lastName VARCHAR(20), userCity VARCHAR(20), userState VARCHAR(20), userZIP VARCHAR(5), userZIP addon VARCHAR(4), /* the 4 digits after the ZIP */ bandName VARCHAR(50), band TourCity VARCHAR(20), bandTourState VARCHAR(20), band TourZIP 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. Don't copy and paste another Chegg answer into this one please
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started