Data base

I have a small project in SQL database its like a case study I want to create two tables and link them with the database which already existing.

Also the candidate must have some info with NOSQL systems.

I had attached my database which existed please check the attachment very well and think if you can link new tables with it before apply.

Thank you