license plate can have both letters and numbers; driverid and social security contain only numbers; maxliability is a real number; year, phone, capacity are integers; everything else are strings. (15 points) translate the diagram above by writing the sql create table statements to represent this e/r diagram. include all key constraints; you should specify both primary and foreign keys. make sure that your statements are syntactically correct (you might want to check them using sqlite / azure for instance).
