create database CTU__YourICASNo GO USE CTU__YourICASNo; GO CREATE TABLE Course(     CourseID int PRIMARY KEY,     CourseName varchar(255),     CourseDesc varchar(255), ); insert into Course(CourseID,CourseName,CourseDesc) values(11334,'Foundation','Basic1') insert into Course(CourseID,CourseName,CourseDesc) values(11335,'MCSD','Basic2'); insert into Course(CourseID,CourseName,CourseDesc) values(11336,'MCSE','Basic3'); insert into Course(CourseID,CourseName,CourseDesc) values(11337,'MCSA','Basic4'); insert into Course(CourseID,CourseName,CourseDesc) values(11338,'CAD','Basic5'); CREATE TABLE Students(     ICASNo int Primary Key,     StudentName varchar (255),     StudentSurname varchar (255),     StudentContact varchar (255),     StudentEmail varchar(255),     HighSchoolAttended varchar(255),     courseID varchar (255), ); insert into Students(ICASNo,StudentName,StudentSurname,StudentContact,StudentEmail,HighSchoolAttended,courseID) values(11189,'Fiona','Battle','1-657-624-8476','sapien.imperdiet.ornare@veliteu.co.uk','Grey High-School',11334); insert into Students(ICASNo,StudentName,StudentSurname,StudentContact,StudentEmail,HighSchoolAttended,courseID) values(11190,'Ryan','Avery','(267) 835-3606','velit.justo@utodiovel.net','Boys High Kimberley',11335); insert into Students(ICASNo,StudentName,StudentSurname,StudentContact,StudentEmail,HighSchoolAttended,courseID) values(11191,'Angelica','Moon','(427) 885-6026','integer.vulputate@justonecante.com','Oranje Meisies High-School',11334); insert into Students(ICASNo,StudentName,StudentSurname,StudentContact,StudentEmail,HighSchoolAttended,courseID) values(11192,'Lester','Fernandez','(703) 939-2798','curabitur.consequat.lectus@porttitoreros.edu','Fichardtpark',11337); insert into Students(ICASNo,StudentName,StudentSurname,StudentContact,StudentEmail,HighSchoolAttended,courseID) values(11193,'Priscilla','Rasmussen','1-747-549-7171','congue@tacitisociosqu.co.uk','Diamantveld High-School',11334); CREATE TABLE Semester(     SemesterID int Primary Key,     SemesterStartDate varchar(255),     SemesterEndDate varchar(255),     ICASNo varchar(255), ); insert into Semester(SemesterID,SemesterStartDate,SemesterEndDate,ICASNo) values(34567,'Aug 1, 2021','May 27,2022',11190) insert into Semester(SemesterID,SemesterStartDate,SemesterEndDate,ICASNo) values(98709,'Dec 13, 2021','18 Nov, 2022',11192) insert into Semester(SemesterID,SemesterStartDate,SemesterEndDate,ICASNo) values(76345,'Jul 16, 2021','Jun 21, 2022',11189) insert into Semester(SemesterID,SemesterStartDate,SemesterEndDate,ICASNo) values(42900,'Oct 24, 2021','Oct 27, 2022',11193) insert into Semester(SemesterID,SemesterStartDate,SemesterEndDate,ICASNo) values(67234,'Jan 20, 2021','Feb 18, 2022',11191) CREATE TABLE Facilitator(     FacilitatorID int Primary Key,     FacilitatorName varchar(255) ,     FacilitatorContact varchar(255),     FacilitatorEmail varchar(255),     ICASNo varchar(255),     );     insert into Facilitator(FacilitatorID,FacilitatorName,FacilitatorContact,FacilitatorEmail,ICASNo)     values(9009127,'Kelsie Lewis','(328) 114-3041','mollis.lectus.pede@fuscealiquam.net',11110)     insert into Facilitator(FacilitatorID,FacilitatorName,FacilitatorContact,FacilitatorEmail,ICASNo)     values(9808139,'Charity Mcfarland','(572) 501-4782','sapien.cras@integeridmagna.com',11111)     insert into Facilitator(FacilitatorID,FacilitatorName,FacilitatorContact,FacilitatorEmail,ICASNo)     values(8802190,'Hilary Nixon','1-710-696-7666','varius@sollicitudinamalesuada.ca',11112)     insert into Facilitator(FacilitatorID,FacilitatorName,FacilitatorContact,FacilitatorEmail,ICASNo)     values(9012109,'Deirdre Terrell','1-491-662-4421','elit.fermentum.risus@ipsumsodales.edu',11113)     insert into Facilitator(FacilitatorID,FacilitatorName,FacilitatorContact,FacilitatorEmail,ICASNo)     values(7809179,'Tyrone Erickson','1-831-287-2701','dictum.eu@cras.com',11114)      CREATE TABLE Module(     ModuleID int Primary Key,     ModuelName varchar(255),     ModuleDuration varchar(255),     FacilitatorID varchar(255), ); insert into Module(ModuleID,ModuelName,ModuleDuration,FacilitatorID) values(101,'Foundation','3years',9808139) insert into Module(ModuleID,ModuelName,ModuleDuration,FacilitatorID) values(102,'CAD','2years',8802190) insert into Module(ModuleID,ModuelName,ModuleDuration,FacilitatorID) values(103,'MCSA','3years',7809179) insert into Module(ModuleID,ModuelName,ModuleDuration,FacilitatorID) values(104,'MCSD','1year',9012109) insert into Module(ModuleID,ModuelName,ModuleDuration,FacilitatorID) values(105,'MCSE','2years',9009127) Create a query that retrieve information from Table Facilitator and Table Module. The result should be join using the facilitatorID how do i do this in SQL Server

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

create database CTU__YourICASNo
GO
USE CTU__YourICASNo;
GO
CREATE TABLE Course(
    CourseID int PRIMARY KEY,
    CourseName varchar(255),
    CourseDesc varchar(255),
);
insert into Course(CourseID,CourseName,CourseDesc)
values(11334,'Foundation','Basic1')
insert into Course(CourseID,CourseName,CourseDesc)
values(11335,'MCSD','Basic2');
insert into Course(CourseID,CourseName,CourseDesc)
values(11336,'MCSE','Basic3');
insert into Course(CourseID,CourseName,CourseDesc)
values(11337,'MCSA','Basic4');
insert into Course(CourseID,CourseName,CourseDesc)
values(11338,'CAD','Basic5');

CREATE TABLE Students(
    ICASNo int Primary Key,
    StudentName varchar (255),
    StudentSurname varchar (255),
    StudentContact varchar (255),
    StudentEmail varchar(255),
    HighSchoolAttended varchar(255),
    courseID varchar (255),
);
insert into Students(ICASNo,StudentName,StudentSurname,StudentContact,StudentEmail,HighSchoolAttended,courseID)
values(11189,'Fiona','Battle','1-657-624-8476','sapien.imperdiet.ornare@veliteu.co.uk','Grey High-School',11334);
insert into Students(ICASNo,StudentName,StudentSurname,StudentContact,StudentEmail,HighSchoolAttended,courseID)
values(11190,'Ryan','Avery','(267) 835-3606','velit.justo@utodiovel.net','Boys High Kimberley',11335);
insert into Students(ICASNo,StudentName,StudentSurname,StudentContact,StudentEmail,HighSchoolAttended,courseID)
values(11191,'Angelica','Moon','(427) 885-6026','integer.vulputate@justonecante.com','Oranje Meisies High-School',11334);
insert into Students(ICASNo,StudentName,StudentSurname,StudentContact,StudentEmail,HighSchoolAttended,courseID)
values(11192,'Lester','Fernandez','(703) 939-2798','curabitur.consequat.lectus@porttitoreros.edu','Fichardtpark',11337);
insert into Students(ICASNo,StudentName,StudentSurname,StudentContact,StudentEmail,HighSchoolAttended,courseID)
values(11193,'Priscilla','Rasmussen','1-747-549-7171','congue@tacitisociosqu.co.uk','Diamantveld High-School',11334);


CREATE TABLE Semester(
    SemesterID int Primary Key,
    SemesterStartDate varchar(255),
    SemesterEndDate varchar(255),
    ICASNo varchar(255),
);
insert into Semester(SemesterID,SemesterStartDate,SemesterEndDate,ICASNo)
values(34567,'Aug 1, 2021','May 27,2022',11190)
insert into Semester(SemesterID,SemesterStartDate,SemesterEndDate,ICASNo)
values(98709,'Dec 13, 2021','18 Nov, 2022',11192)
insert into Semester(SemesterID,SemesterStartDate,SemesterEndDate,ICASNo)
values(76345,'Jul 16, 2021','Jun 21, 2022',11189)
insert into Semester(SemesterID,SemesterStartDate,SemesterEndDate,ICASNo)
values(42900,'Oct 24, 2021','Oct 27, 2022',11193)
insert into Semester(SemesterID,SemesterStartDate,SemesterEndDate,ICASNo)
values(67234,'Jan 20, 2021','Feb 18, 2022',11191)

CREATE TABLE Facilitator(
    FacilitatorID int Primary Key,
    FacilitatorName varchar(255) ,
    FacilitatorContact varchar(255),
    FacilitatorEmail varchar(255),
    ICASNo varchar(255),
    );
    insert into Facilitator(FacilitatorID,FacilitatorName,FacilitatorContact,FacilitatorEmail,ICASNo)
    values(9009127,'Kelsie Lewis','(328) 114-3041','mollis.lectus.pede@fuscealiquam.net',11110)
    insert into Facilitator(FacilitatorID,FacilitatorName,FacilitatorContact,FacilitatorEmail,ICASNo)
    values(9808139,'Charity Mcfarland','(572) 501-4782','sapien.cras@integeridmagna.com',11111)
    insert into Facilitator(FacilitatorID,FacilitatorName,FacilitatorContact,FacilitatorEmail,ICASNo)
    values(8802190,'Hilary Nixon','1-710-696-7666','varius@sollicitudinamalesuada.ca',11112)
    insert into Facilitator(FacilitatorID,FacilitatorName,FacilitatorContact,FacilitatorEmail,ICASNo)
    values(9012109,'Deirdre Terrell','1-491-662-4421','elit.fermentum.risus@ipsumsodales.edu',11113)
    insert into Facilitator(FacilitatorID,FacilitatorName,FacilitatorContact,FacilitatorEmail,ICASNo)
    values(7809179,'Tyrone Erickson','1-831-287-2701','dictum.eu@cras.com',11114)

    
CREATE TABLE Module(
    ModuleID int Primary Key,
    ModuelName varchar(255),
    ModuleDuration varchar(255),
    FacilitatorID varchar(255),
);
insert into Module(ModuleID,ModuelName,ModuleDuration,FacilitatorID)
values(101,'Foundation','3years',9808139)
insert into Module(ModuleID,ModuelName,ModuleDuration,FacilitatorID)
values(102,'CAD','2years',8802190)
insert into Module(ModuleID,ModuelName,ModuleDuration,FacilitatorID)
values(103,'MCSA','3years',7809179)
insert into Module(ModuleID,ModuelName,ModuleDuration,FacilitatorID)
values(104,'MCSD','1year',9012109)
insert into Module(ModuleID,ModuelName,ModuleDuration,FacilitatorID)
values(105,'MCSE','2years',9009127)

Create a query that retrieve information from Table Facilitator and Table Module. The result should be join using the facilitatorID

how do i do this in SQL Server

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 7 steps with 6 images

Blurred answer
Knowledge Booster
Fundamentals of Datawarehouse
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education