About this document
SQL DDL and DML for Course Advising System by Shubham Devkate is a document available to read on EtoBox.
The document provides instructions for modifying database schemas and writing SQL queries. It asks to 1) extend tables to allow courses to have multiple teaching assistants, 2) alter the schema to allow students to have multiple advisors, 3) write queries to find students with more than 3 advisors or students co-advised by specific professors, and 4) write queries to delete old data or remove a course along with its prerequisites.
- Author
- Shubham Devkate
- Language
- EN