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 TriMetdriver entity (with driver license number, name, and age). Each driver drives

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!