I'm trying to design an ER diagram in the relational database module of my course. We were given a scenario to draw a diagram for and then create a database within Access. I have the database covered, but want to be sure I'm on the right track for the diagram.
The model is for business functions within a car dealership. Minimum and maximum cardinalities must be indicated. Entities and processes to be considered include Customer; Cash Received; Cash; Salesperson; AR Clerk; Sell Vehicle; Inventory.
A few assumptions must be made about resources and the payment event. Assume the company only sells inventory that is in stock, thus customers will not be ordering vehicles and every sale is only for one vehicle. Inventory is categorized based on model information. Additionally, assume that the dealership has multiple cash accounts and that customer payments are always deposited in the same cash account. Since the dealership offers financing, customers can make monthly payments on their vehicles so customers can buy now and pay in installments later. Any other assumptions that need to be made should be consistent with the business processes in a typical auto dealership.
My answer (I don't believe I have a firm grasp on this at all -- I also don't have the ability to embed pictures yet):
Thank you in advance for your help!!