(Solved) : Database Concepts Find Names Ids Students Taken Exactly One Course Spring 2010 Semester Da Q35607066 . . . .

Database concepts

Find the names and ids of the students who have takenexactly one course in the Spring 2010semester.

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 < 2100),

    building       varchar(15),

    room_number        varchar(7),

    time_slot_id       varchar(4),

     primary key (course_id, sec_id,semester, year),

     foreign key (course_id) referencescourse

        on deletecascade,

     foreign key (building, room_number)references classroom

        on delete setnull

    );

create table teaches

    (ID         varchar(5),

    course_id      varchar(8),

    sec_id         varchar(8),

    semester       varchar(6),

    year           numeric(4,0),

     primary key (ID,