Hi,
I am in the process of designing a database for a car sales company. The company sales cars and also buys cars back from its customers. How should I design my tables so that the database keeps track of each car as well as the sales and buy-backs of the car? (example: a customer purchased a Honda Civic in 2012 and sold the same car back to the company in 2013. I would like the database set up in a way that if I look up the Car ID, I will see the transaction history for the car)
Thank you for your help