You'll need to familiarise yourself with relational databases. Once you get that, it's just logical.
The shop can have more than one copies of the same movie. The movie itself is unique, but the copies can be borrowed by different people. Similarly, each borrower is unique, but they can borrow...