Question: Please write SQL queries based on given relational schema Minimum total 15 queries, including ALL of the below: I. INSERT - at least 3 queries

Please write SQL queries based on given relational schema Minimum total 15 queries, including ALL of the below: I. INSERT - at least 3 queries ii. UPDATE, DELETE- at least 3 queries iii. SELECT (single table) - at least 5 queries iv.JOIN (multiple tables) at least 4 queries Student (student_ID, student_fName, student_IName, student_password, student_adress, student_phonenum, student_email, city, country, postcode, state, street_name, street_number, Course_name, course_code Primary key: student_ID Project (student_ID, project_title, presentation, prototype) Foreign key: student_ID REFERENCES Student(student_id) Evaluation form (Ind_ID, Uni_ID, Exam_ID, project_title, student_ID, presentation_evaluation, prototype_evaluation, comment) Foreign key 1: Ind_ID Foreign key 2: Uni_ID Foreign key 3: Exam ID Industry_coach (Ind_ID, IndCoach_fName, IndCoach_IName, IndCoach_password, IndCoach_phonenum, IndCoach_email) Primary key: Ind_ID University_coach (Uni_ID, UniCoach_fName, UniCoachiName, UniCoach_password, UniCoach_phonenum, UniCoach_email) Primary key: Uni_ld Examiner (Exam_ID, Exam_fName, Exam_IName, Exam_password, Exam_phonenum, Exam_email) Primary key: Exam_ID FYPI_committee (committee_ID, committee_userName, committee_password, committee_phonenum, committee_email) Primary key: committee_ID
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
