Answer Happy

Please help. Screenshots would be great:)
Instructions: 1. Use the HW 11 below and
modify to allow it to be used in SQL Server, such as data types,
etc. AND Create the tables & insert the data into SQL
server
Make sure that datatypes work in sql server. 2.
Ch 5 Problems & Exercises #5-38 to 5-45 (in notepad; not
SQL server).
Homework 11
1. Student(StudentID, student name)
2. Qualified(FacultyID, CourseID, date qualified)
3. Faculty(FacultyID, faculty name)
4. Section(SectionNo. semester, CourseID)
5. Course (CourseID, course name)
6. Registration (StudentID, SectionNo)
Create table statements
Student table Create table student
(StudentID int PRIMARY KEY,
StudentName Char(25));
Qualified table Create table
qualified
(FacultyID int PRIMARY KEY, FOREIGN KEY
REFERENCES Faculty(FacultyID),
Coursed int PRIMARY KEY, FOREIGN KEY REFERENCES
course(CourseID),
Datequalified DATE);
Faculty table Create Faculty table
(FacultyID int PRIMARY KEY,
Faculty name Char(25));
Section table Create table section
(SectionNo int PRIMARY KEY,
Semester char(7),
CourseID int FOREIGN KEY REFERENCES
course(coursed));
Course table Create table course
(CourseID int PRIMARY KEY,
Course name Char(15));
Registration table Create table registration
(StudentID int PRIMARy KEY,
FOREIGN KEY
REFERENCES student(StudentID),
SectionNo int PRIMARY KEY FOREIGN KEY
REFERENCES section(section));
Insert Into Statements
Student Table
Insert into student(studentid, studentname)
values(38214, ’Lettersky’);
Insert into student(studentid, studentname)
values(38907,’Atlavatar’);
Insert into student(studentid,
studentname)
Values 38907,’Aiken’);
Insert into student(studentid, studentname)
values(70642, ’Miarra’);
Qualified table
Insert into qualified
(FacultyID, courseid, dateqaulified)
values(2143, ‘ISM 3112’,
9/2008)
Insert into
qualifies(FacultyID, courseid, dateqaulified)
values(2143, ‘ISM 3113’,
9/2008)
Insert into
qualifies(FacultyID, courseid, dateqaulified)
values(3467 ‘ISM 4212’,
9/2015)
Insert into qualifies(FacultyID, courseid, dateqaulified)
values(3467 ‘ISM 4930’,
9/2016)
Insert into qualifies(FacultyID,CourseID, dateqaulified)
values(4756 ‘ISM 3113,
9/2011)
Insert into qualifies(FacultyID, courseid, dateqaulified)
values(4756 ‘ISM 3112,
9/2011)
Faculty Table
Insert into faculty (Facultyid, facultyname)
values(2143, Birkin)
Insert into faculty (Facultyid, facultyname)
values(3467, Berndt)
Insert into faculty (FacultyID, facultyname)
values(4756, Collins)
Section Table
Insert into section(SectionNo,Semester, CourseID)
values(2712,I-2018,ISM 3113)
Insert into section(SectionNo,Semester, CourseID)
values(2713,I-2018,ISM 3113)
Insert into section(SectionNo,Semester, CourseID)
values(2714,II-2018,ISM 4212)
Insert into section(SectionNo,Semester, CourseID)
values(2715,II-2018,ISM 4930)
Course Table
Insert into course(CourseID, coursename)
values(ISM 3113, SySt Analysis)
Insert into course(CourseID, coursename)
values(ISM 3112, SySt Dsesign)
Insert into course(CourseID, coursename)
values(ISM 4212, Databasing)
Insert into course(CourseID, coursename)
values(ISM 4930, Networking)
Registration Table
Insert into registration(studentID, SectionNo);
Values (38214, 2714);
Insert into registration(studentID, SectionNo);
Values (54907, 2714);
Insert into registration(studentID, SectionNo);
Values (54907, 2715);
Insert into registration(studentID, SectionNo);
Values (66324, 2713);
* I will add the picture needed from the book in a
comment