All the queries should be executed in MySQL and Screen Shot has to be attached for each question. 20.5. Drop both Check and Default constraint (Qn 3 & 4) of the "Student" table.6. Write a query to...

All the queries should be executed in MySQL and Screen Shot has to be attached for each question.

20. 5. Drop both Check and Default constraint (Qn 3 & 4) of the "Student" table. 6. Write a query to create a table "Course", with columns Course ID, Course Title and Course offering Dept (CoD). The Course ID, and Course Title must be unique for each and every record. 7. Write a query to alter the CoD of "Course" table by including the value as "SCOPE" automatically when no value inserted. 8. Write a query to alter the "Course" table by naming a foreign key constraint on SID column of "Student" table. 9. Write a query to create an index with the name "C_index" for the "Course" table which stores the Course name. 10. Write a query to delete the index form the "Course" table. "/>
Extracted text: 1. Write a query to create the "Student" table (SID, Sname, SAge, SDept, SCity), where the Student ID and Student Name cannot be NULL. 2. Write a query to alter the above "Student" table, where a new column of Date of Birth (DOB) must be added, and it should not have any NULL values. 3. Write a query to alter the "Student" table, where a CHECK constraint must be added to the "SCity" column and it must be "Vellore". 4. Write a query to alter the "Student" table, by setting the default value of Age > 20. 5. Drop both Check and Default constraint (Qn 3 & 4) of the "Student" table. 6. Write a query to create a table "Course", with columns Course ID, Course Title and Course offering Dept (CoD). The Course ID, and Course Title must be unique for each and every record. 7. Write a query to alter the CoD of "Course" table by including the value as "SCOPE" automatically when no value inserted. 8. Write a query to alter the "Course" table by naming a foreign key constraint on SID column of "Student" table. 9. Write a query to create an index with the name "C_index" for the "Course" table which stores the Course name. 10. Write a query to delete the index form the "Course" table.