Give a brief description of any real-world project that stores any kind of data (eg. a library that allows users to borrow/purchase books, a car dealership, etc.). Briefly state the operations that are involved in the project. For the scenario that you proposed, identify the following:

1. Tables to be created and a brief description on each (no more than 5 tables)

2. Primary Keys

3. Foreign keys

4. Candidate keys

5. Referential integrity constraints