Use the preamble below to answer QUESTIONS I and QUESTIONS 2 A university SOG is made up of employees who belongs to the various departments and are characterized by their staff ID, first name, last...


Use the preamble below to answer QUESTIONS I and QUESTIONS 2<br>A university SOG is made up of employees who belongs to the various departments and<br>are characterized by their staff ID, first name, last name and date of birth. Also students<br>are part of the university and can also be characterized by student ID, first ame, last<br>name, date of admission. Every employee and student belongs to a particular department<br>which can be characterized by the department ID and the department name. Again all<br>students offer a particular program which can be identified by the program ID and<br>program name and also a course that is offered by the students that can be identified by<br>the course ID and the course name.<br>a. Create SOG University database using SQL Data Definition Language.<br>b. Create two (2) tables in the SOG University database from the schemas in<br>QUESTION Ie using SQL. Data Definition Language.<br>c. List the student ID of all students who do not belong to a department with<br>departmentID7 in the SOG University database using SQL. Data Manipulation<br>Language<br>

Extracted text: Use the preamble below to answer QUESTIONS I and QUESTIONS 2 A university SOG is made up of employees who belongs to the various departments and are characterized by their staff ID, first name, last name and date of birth. Also students are part of the university and can also be characterized by student ID, first ame, last name, date of admission. Every employee and student belongs to a particular department which can be characterized by the department ID and the department name. Again all students offer a particular program which can be identified by the program ID and program name and also a course that is offered by the students that can be identified by the course ID and the course name. a. Create SOG University database using SQL Data Definition Language. b. Create two (2) tables in the SOG University database from the schemas in QUESTION Ie using SQL. Data Definition Language. c. List the student ID of all students who do not belong to a department with departmentID7 in the SOG University database using SQL. Data Manipulation Language

Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here