Ex. 2.2 (1-6) [15 points] A vehicle database contains information about cars (identified by Vehicle Identification Number, or VIN) and Drivers (identified by Civil Ids). Drivers own vehicles; each situation concerns the Owns relationship set. For each situation, draw an EER diagram that describes it (assuming no further constraints hold). 1. (3 points) Drivers can own vehicles for an extended period, and each owned vehicle must be recorded, including when it was added to their possession and when it left their possession. 2. (3 points) Driver can own several vehicles simultaneously, and only what the driver currently owns is recorded. (Assume this condition applies in all subsequent questions.) 3. ( 2 points) Every driver must own at least one vehicle. 4. (2 points) Every driver owns exactly one vehicle (no more, no less). 5. (2 points) Every driver teaches exactly one vehicle (no more, no less), and every vehicle must be owned by some driver. Note: In (5), 'some driver' refers to 'one driver'! 1 6. (3 points) Rephrase (6) as follows: Suppose that a certain vehicle can be owned by a team of drivers jointly. Model this situation by introducing additional entity sets and relationship sets if necessary. Here, we assume that only the latest owners of a vehicle need to be recorded