The Driver Relationship team requested to ensure that there will be no duplicates in the active drivers tables in terms of first name, last name and driving license ID. You need to provide constraint in the ACTIVE_DRIVERS table, called DuplicateCheck, to ensure the first name, last name, and the driving license ID are unique.

  

Transcribed Image Text:

B Chrome File Edit View History Bookmarks Profiles Tab Window Help 75% Mon 10:45 PM a Search Results | Course HEX Courses - valenciacollege. X Chapter 01 Use It MindTap - Cengage Learnii X cc Convert Case | Convert up x + ng.cengage.com/static/nb/ui/evo/index.html?deploymentId=6094832335509691384341050163&elSBN 9780357673126&id=16885010... Update Q Search this course ? CENGAGE MINDTAP Chapter 08 Activity 01 Instructions Page 4 of 4 Task 5: The Driver Relationship team requested to ensure that there will be no duplicates in the active drivers tables in terms of first name, last name and driving license ID. You need to create a constraint in the ACTIVE_DRIVERS table, called DuplicateCheck, to ensure the first name, last name, and the driving license ID are unique. Task Create a constraint on the ACTIVE DRIVERS table Task 6: < 4/4 FEB 127 query.sql + 1 SQL Viewer X + ERROR 1061 (42000) at line 1: Duplicate key name 'NameSearch' InstantRide D A Run A-Z B Chrome File Edit View History Bookmarks Profiles Tab Window Help 75% Mon 10:45 PM a Search Results | Course HEX Courses - valenciacollege. X Chapter 01 Use It MindTap - Cengage Learnii X cc Convert Case | Convert up x + ng.cengage.com/static/nb/ui/evo/index.html?deploymentId=6094832335509691384341050163&elSBN 9780357673126&id=16885010... Update Q Search this course ? CENGAGE MINDTAP Chapter 08 Activity 01 Instructions Page 4 of 4 Task 5: The Driver Relationship team requested to ensure that there will be no duplicates in the active drivers tables in terms of first name, last name and driving license ID. You need to create a constraint in the ACTIVE_DRIVERS table, called DuplicateCheck, to ensure the first name, last name, and the driving license ID are unique. Task Create a constraint on the ACTIVE DRIVERS table Task 6: < 4/4 FEB 127 query.sql + 1 SQL Viewer X + ERROR 1061 (42000) at line 1: Duplicate key name 'NameSearch' InstantRide D A Run A-Z