StudentID* Name Advisor Dept Faculty Year GPA MAC-1-01-07 BIT-0-07-03 MAC-0-02-0
ID: 3613550 • Letter: S
Question
StudentID*
Name
Advisor
Dept
Faculty
Year
GPA
MAC-1-01-07
BIT-0-07-03
MAC-0-02-08
BIT-1-01-06
MAC-1-03-07
Peter
Jane
Mary
Andrew
John
Juma
Abdih
Henry
Abdih
Juma
CIS
BIT
CIS
BIT
CIS
Sciences
Business
Sciences
Business
Sciences
2007
2008
2008
2007
2008
2.93
3.01
3.32
2.79
3.42
StudentID*
Name
Advisor
Dept
Faculty
Year
GPA
MAC-1-01-07
BIT-0-07-03
MAC-0-02-08
BIT-1-01-06
MAC-1-03-07
Peter
Jane
Mary
Andrew
John
Juma
Abdih
Henry
Abdih
Juma
CIS
BIT
CIS
BIT
CIS
Sciences
Business
Sciences
Business
Sciences
2007
2008
2008
2007
2008
2.93
3.01
3.32
2.79
3.42
Explanation / Answer
Below is an example. You may have to adjust the size of thefields or which is a p_key, null, not null distinct or not distinctbut this should get you started. ***Note you must create theDBNAME first then create the table /*create database DBNAME go */ use DBNAME create table student ( studentID varchar(20) not null, StudentName varchar(30) notnull, Advisor varchar(30) not null, Dept varchar(5) not null, Faculty varchar(30) not null, CurrentYear char(4) not null, GPA float(5) not null ) go Insert into student Values('MAC-1-01-07', 'Peter', 'Advisor','CIS', 'Sciences', '2007', 2.93) ....... ...... ...... Good luck let me know if you need more help or if this is what yourasking