(Solved) : Database Concepts Find Names Ids Students Taken One Course Spring 2010 Semester Notice One Q35607077 . . . .

Database concepts

Find the names and ids of the students who have taken atmost one course in the Spring 2010 semester. Notice, atmost one means one or zero. So, the answer should include studentswho did not take any course during that semester

The data:

create table classroom

    (building       varchar(15),

    room_number        varchar(7),

    capacity       numeric(4,0),

     primary key (building, room_number)

    );

create table department

    (dept_name      varchar(20),

    building       varchar(15),

     budget     numeric(12,2) check (budget > 0),

     primary key (dept_name)

    );

create table course

    (course_id      varchar(8),

    title          varchar(50),

    dept_name      varchar(20),

    credits        numeric(2,0)check (credits > 0),

     primary key (course_id),

     foreign key (dept_name) referencesdepartment

        on delete setnull

    );

create table instructor

    (ID         varchar(5),

    name           varchar(20)not null,

    dept_name      varchar(20),

    salary         numeric(8,2)check (salary > 29000),

     primary key (ID),

     foreign key (dept_name) referencesdepartment

        on delete setnull

    );

create table section

    (course_id      varchar(8),

sec_id         varchar(8),

    semester       varchar(6)

        check (semesterin (‘Fall’, ‘Winter’, ‘Spring’, ‘Summer’)),

    year           numeric(4,0)check (year > 1701 and year <