Question: Part Il: Attributes versus Entities Questions 6-9 all concern a TriMet driver entity (with driver license number, name, and age). Each driver drives a specific


Part Il: Attributes versus Entities Questions 6-9 all concern a TriMet driver entity (with driver license number, name, and age). Each driver drives a specific vehicle type (e.g., bus, streetcar, or max). The vehicle information includes type and maximum speed. The driver can drive the vehicle for a specific line, The line has a name, description, and length in miles. For example, the driver Jack Stewart (license number: 12345 and age: 45) can only drive a bus (max speed: 50 mph) on only line 12 (description: Parkrose to Tigard, and length: 19 miles) Question 6 (5 points): Give an ER diagram that represents a driver's vehicle and line information only using attributes (use only one entity) Question 7 (5 points): Give an ER diagram that represents the information using two entities, one relationship, and relationship attributes. Question 8 (5 points): Give an ER diagram that represents the information
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
