Database for Jobs Posting and Internships Opportunities Exercise
Imagine that you have to design a database that would match information about job postings and internship opportunities etc. to candidate graduating students? (So, instead of matching patrons to books as in the class case-study, you are matching students to jobs for this HW)
Assume that you currently have separate sets of information (data) about:
-Typical student information such as their identities, their grades, their courses taken, etc.
-Typical information about job postings and/or internships, such as role, requirements, location, paid/unpaid, etc.
1) You would like to bring all of this information together in a relational database system. Consider what data elements or variables do you think are necessary?
2) How would you structure distinct tables? (i.e. what would constitute a row in your table(s)?)
3) How would you ensure information is stored efficiently?
4) What keys would you use to relate tables to each other? (i.e. Describe how information in one table would link with information in another table)
5) If you wanted to add the capability of ‘automatically’ matching students to jobs and vice versa, explain via an illustrative example, how this automatic matching might work for your design.
Your HW submission should show sample tables and relationships — so that I can understand your design, and how your design would work to solve the task at hand.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
