Creating tables
Budget: $8 – $15 USD
Develop the SQL scripts that will create the tables and enforce all the appropriate constraints
• Develop sample SQL scripts that will insert the data to the database (enough rows in each table to test their funtionality)
• Convert at least 2 entities to MongoDB Collections. Write the scripts that will Create the collection(s). Discuss your rationale for your choices.
• Create queries (SQL or MongoDB) that will:
1. Return all the information displayed on the Locations tab (wireframe 1)
2. Return all the information displayed on the Midtown Location tab (wireframe 2)
Create queries (SQL or MongoDB) that will:
1. Return all the information displayed on the Locations tab (wireframe 1)
2. Return all the information displayed on the Midtown Location tab (wireframe 2)
3. Return all the information displayed on the Coaches tab (wireframe 3)
4. Return all the information displayed on the Coach Sally tab (wireframe 4)
• Develop sample SQL scripts that will insert the data to the database (enough rows in each table to test their funtionality)
• Convert at least 2 entities to MongoDB Collections. Write the scripts that will Create the collection(s). Discuss your rationale for your choices.
• Create queries (SQL or MongoDB) that will:
1. Return all the information displayed on the Locations tab (wireframe 1)
2. Return all the information displayed on the Midtown Location tab (wireframe 2)
Create queries (SQL or MongoDB) that will:
1. Return all the information displayed on the Locations tab (wireframe 1)
2. Return all the information displayed on the Midtown Location tab (wireframe 2)
3. Return all the information displayed on the Coaches tab (wireframe 3)
4. Return all the information displayed on the Coach Sally tab (wireframe 4)