search

mikeizbicki / cmc-csci143

big data course materials
40 stars 77 forks source link

Final Exam Clarification #565

Open luisgomez214 opened 3 weeks ago

luisgomez214 commented 3 weeks ago

Hello,

Just wanted to ask for clarification. For non-graduating students, are we just writing indexes based on the SQL from our project?

On the final exam repo it says 

I will ask three SQL questions:

One without a JOIN
One with a JOIN (possibly more than 1 table)
One with a full text search (possibly with a JOIN)
I'm planning for ~10 minutes/question = 30 minutes in total

but on the project repo it says 


In order to implement the routes as specified above, you will have to implement at least one of each of the following:

a query without a JOIN
a query with a JOIN
a full text search query
I will select three of these queries for you, and then the final exam will proceed as it did for the graduating students. The final exam will be graded on a separate 64 point scale.
ains-arch commented 3 weeks ago

I'm also curious about this, especially given this comment:

The way the routes are written, you only really use 2 tables. The main purpose of the third table is only to give me more options during the final exam for joins.

https://github.com/mikeizbicki/cmc-csci143/issues/562#issuecomment-2095126725

How prepared should we be to write new queries and indexes on the spot?

mikeizbicki commented 3 weeks ago

@luisgomez214 I don't see a meaningful difference between the two sets of instructions you quoted. If there's something specific you're concerned about, then I'll need you to elaborate more.

@ains-arch You will have to write SQL queries on the spot, and you will have to create indexes for those queries on the spot.