SQLProject

تاریخ : اکتوبر ۲۰۲۰ - دسمبر ۲۰۲۰

<div><p>For LD, we attempted every query but ran into difficulties with the last few. The queries being asked for in the project were becoming more and more like functions one would expect to write in something like Java, not SQL. We could get part of the query sometimes and hit a wall as to how to take these single query statments, which were becoming paragraphs of unto themselves, into even further steps of further computation.With LD another thing we attempted but decided to not go through with, was using live data from the internet. At first we were looking into fetching data from apis from sites monster to use live data in our sql database, but to use such api's cost at the least $300. That kind of data is mainly used by large scale employers and headhunters whom massively search thousands of applicants at a time.  We could have maybe done web scraping, but in the end we decided against it. We instead built a dummy data sql generator using c#.These are very loaded queries being asked for on the LD database, wanting a lot of personal data from people's resumes such as what courses they've taken as well as their job histories. And on top of that, we're supposed to look at live job openings and assess their skill levels and even college classes required?  </p></div>