- Driver Id Pk Lint Lastname Varchar 50 Firstname Varchar 50 Dateofbirth Date Gender Varchar 10 Policy Policyholder O 1 (34.9 KiB) Viewed 41 times
below. Or, explain why a CQL query using the given column families
cannot be written using only the column families
provided.
DRIVER id (PK) LINT lastName VARCHAR(50) firstName VARCHAR(50) dateOfBirth DATE gender VARCHAR(10) POLICY_POLICYHOLDER O policyholderID (PK, FK) INT policyID (PK, FK) INT purchases is covered on POLICYHOLDER id (PK) INT lastName VARCHAR(50) firstName VARCHAR(50) phone CHAR(10) email VARCHAR(100) DRIVER POLICY policyID (PK, FK) INT Odriverid (PK, FK) INT id (PK) type limit COVERAGE INT VARCHAR(50) H DECIMAL(10,2) id (PK) lastName firstName AGENT INT VARCHAR(50) sells VARCHAR(50) CHAR(10) VARCHAR(100) POLICY id (PK) INT < type VARCHAR(50) effective Date DATE expirationDate DATE agentiD (FK) INT deductible DECIMAL + COVERAGE_POLICY coveragel (PK, FK) INT policyID (PK, FK) INT phone is on email talls under is filed on + As for CLAIM id (PK) INT incident_desc text incident date date at_fault bool status text EXPENSE id (PK) INT date_requested date date disbursed date amount double pay to text purpose text status text