Identify the foreign key for STUDENT relation.STUDENT (stuID, stuLName, stuAddress)ENROLLMENT (enrID, subName, className, stuID)Choose one answer. a. enrID b. subName c. stuID d. className

Consider these following tables and only solve the query. Tables: 1) student: s_no (primary key), student_name, course_no (foreign key), age 2) courser-course-no (primary key), course-name.

Select the correct answerCourse(course_id,sec_id,semester)Here the course_id,sec_id and semester are __________ and course is a _________.OptionsAttributes, RelationRelations, AttributeTuples, SetTuples, AttributesFinish ClearPrev Next (1)

Student Relation Student_ID   Student_Name   Dept_Name 0000 AAAAA Computer Science1111 BBBBB Computer Science2222 CCCCC  Business Administration Question 13Select one:a.CREATE TABLE Student(   Student_ID int,   Student_Name char(20),   Dept_Name char(20),);b.CREATE TABLE Student(   Student_ID int,   Student_Name varchar(100),   Dept_Name varchar(100),);c.CREATE TABLE Student(   Student_ID int,   Student_Name char(100),   Dept_Name char(100),);d.CREATE TABLE Student(   Student_ID char(20),   Student_Name char(100),   Dept_Name char(100),);

Consider following schema and write SQL statements for given queries using subqueries.Faculty (f_id, f_name, address, city, state, age, salary, d_id)Department (dep_id, d_name, course, location, sub_code, subject)Student (enrl_no, s_name, s_address, s_city, s_state, s_age, course, f_id, hobby)Create tables with Primary Key, foreign key constraints in given schemas.1) Display name of faculties and students who are not living in the same city.2) Find out how much amount is spent on faculties as their salary who are working in 'IT Engineering' Department.3) Display department name, course, subject code and subject of person who have enrolled as a student.4) Display id and name of faculty who are working in 'IT Engineering' department and have a salary more than Rs. 60000

Course(course_id,sec_id,semester)Here the course_id,sec_id and semester are __________ and course is a _________.OptionsRelations, AttributeAttributes, RelationTuples, SetTuples, Attributes