Slip 13 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Driver (driver_id, driver_name, address) Car (license_no, model, year) Relation between Driver and Car is Many to Many with date and time as descriptive attribute. Constraint: Primary key, driver_name should not be null. Consider the above tables and execute the following queries: 1. Display the name of driver whose license no is “DPU123”. 2. Delete the details of car whose model is “swift”.
0 Comments