Looks like a Job for a Database side with a Join in the applicatoin side
Some Question i found are
What are different levels of normalization?
How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Difference between a primary key and a unique key?
What are user defined datatypes and when you should go for them?
Explain different isolation levels
Explain Active/Active and Active/Passive cluster configurations
Explain the architecture of SQL Server
What is lock escalation?
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
What is a deadlock and what is a live lock? How will you go about
resolving deadlocks?
What are the different ways of moving data/databases between servers and databases in SQL Server?
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is a join and explain different types of joins.
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
Triggers are special kind of stored procedures that get executed automatically when an INSERT, UPDATE or DELETE operation takes place on a table.
.png)
