Question: Construct a clean and concise ER diagram for the following scenario. List your assumptions and clearly indicate the cardinality mappings in your ER diagram.
Construct a clean and concise ER diagram for the following scenario. List your assumptions and clearly indicate the cardinality mappings in your ER diagram. . A driver identified by driver Sin number, name, birthday, address, city, and postal code A driver takes a driving exam in a DriveTest center. The DriveTest center has address, postal code, center id, phone, name A DriveTest center issues two type of licenses: driver license and learner license. A learner's license may contain restrictions and a driver license records if the driver has completed driver's education Each license has a unique license number and expiry date A driver may have one license (either learner or driver)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
