During the technical interview, work on the problem below using a whiteboard app.
I have an idea for a startup and I need your help to design the database that will power this system. First, imagine that DVDs are still popular. The application is essentially Netflix in its early days. We're going to send DVDs to people.
Please create a database architecture that supports the initial set of requirements, which are:
* Customers should be able to see the DVDs we have [simple list, no filtering, sorting or out-of-stock]
* System should track which customers have which DVDs
* System should track when customers have returned a DVD
Given your schema, can you write me a query that gets all the DVDs for a single customer with the email Jane@smith.com
Given your schema, can you write me a query that reports on our on-hand vs rented out stock?