Please Use Microsoft SQL Server Thank you

Provide the script used to create a table named Doctor in the schema Labassignment3 with columns DoctorID (Primary key), LicenceNo, State, DoctorName, DoctorYearOfGraduation. DoctorID is the primary key (add the constraint at the table level) -Doctor ID is also an identity column with values starting from 10000 and incrementing by 1 -LicenceNo and State form the composite unique key ( add the unique constraint at the table level) -All columns must be not null columns -Include a check constraint at the table level for the year of graduation to be greater than 1985

Provide the script used to insert at least 4 records

The ER and relational diagram for the tables are given as below

LicenseNo State Doctor DoctorID Name LicenceNO (Ugroup1) Satet (Ugroup1) Year of Graduation (DoctorLicense) DoctorID DoctorName Doctor Year of MDGraduation DOCTOR