create Database CTU_YOURICASNO GO USE CTU_YOURICASNO; GO CREATE TABLE Course( CourseID int PRIMARY KEY, CourseName varchar(255), CourseDesc varchar(255), ); CREATE TABLE Students( ICASNo int Primary Key, StudentName varchar (255)NOT NULL, StudentSurname varchar (255)NOT NULL, StudentContact varchar (255)NOT NULL, StudentEmail varchar(255)NOT NULL, HighSchoolAttended varchar(255)NOT NULL, courseID int, ); CREATE TABLE Semester( SemesterID int Primary Key, SemesterStartDate varchar(255)NOT NULL, SemesterEndDate varchar(255)NOT NULL, ICASNo varchar(255), ); CREATE TABLE Facilitator( FacilitatorID int Primary Key, FacilitatorName varchar(255) Not Null, FacilitatorContact varchar(255)Not Null, FacilitatorEmail varchar(255)Not Null, ICASNo varchar(255)Not Null, ); CREATE TABLE Module( ModuleID int Primary Key, ModuelName varchar(255)Not Null, ModuleDuration varchar(255)Not Null, FacilitatorID varchar(255)Not Null, ); Using the INSERT statement, Add five rows of distinct dummy data per table. On the course table, add Foundation, MCSD, MCSE, MCSA and CAD on courseName how do i this in SQL Server

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

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),
);
CREATE TABLE Students(
ICASNo int Primary Key,
StudentName varchar (255)NOT NULL,
StudentSurname varchar (255)NOT NULL,
StudentContact varchar (255)NOT NULL,
StudentEmail varchar(255)NOT NULL,
HighSchoolAttended varchar(255)NOT NULL,
courseID int,
);
CREATE TABLE Semester(
SemesterID int Primary Key,
SemesterStartDate varchar(255)NOT NULL,
SemesterEndDate varchar(255)NOT NULL,
ICASNo varchar(255),
);
CREATE TABLE Facilitator(
FacilitatorID int Primary Key,
FacilitatorName varchar(255) Not Null,
FacilitatorContact varchar(255)Not Null,
FacilitatorEmail varchar(255)Not Null,
ICASNo varchar(255)Not Null,
);

CREATE TABLE Module(
ModuleID int Primary Key,
ModuelName varchar(255)Not Null,
ModuleDuration varchar(255)Not Null,
FacilitatorID varchar(255)Not Null,
);

Using the INSERT statement, Add five rows of distinct dummy data per table. On the course table, add Foundation, MCSD, MCSE, MCSA and CAD on courseName

how do i this in SQL Server

Expert Solution