Draw a simple ERD diagram for each of the following examples. Include proper maximum and minimum cardinality. Include one attribute besides keys. 1. Sandy’s Car Lot has several salesmen who sell a variety of used automobiles to customers. When sold, each auto is credited (sold by) to only one salesperson. A customer may buy more than one automobile, but an automobile, if sold, is sold to only one customer.
2. The National Park Service has almost three hundred parks and monuments and other areas (like National Historical Sites, National Memorials, etc.). These areas are located and administered through twelve territories (each area is in one and only one territory). Each park service area has several staff that work there; a staff member may work in more than one area. Thus, staff employees who work at Arches National Park in Utah may also work at Canyonlands National Park nearby.
3. A zoo wants to keep track of animal types (bobcat, tiger, elephant, etc.) and where they are caged. This is a special zoo. Each animal type has its own cage by itself, and a cage may have only one animal type.