Item #1: Develop scripts to INSERT data into Instructor, and Student tables. Loa
ID: 3787543 • Letter: I
Question
Item #1:
Develop scripts to INSERT data into Instructor, and Student tables. Load the tables with sample data with at least 10 rows.
Instructor
Name
Data Type
Constraint
Address
Nvarchar (100)
Not Null
InstructorID
Int
Primary Key
Phone Number
Nvarchar(10)
Not null
Office
Int
Not null
Office Hours
Nvarchar (30)
Not null
Department
Nvarchar (15)
Not null
Department ID
Int
Not null
First Name
Nvarchar (30)
Not null
Last Name
Nvarchar (30)
Not null
Student
Name
Data Type
Constraint
Address
Nvarchar (100
Not Null
StudentID
Int
Primary Key
Phone Number
Nvarchar(10)
Not null
Major
Char (10)
Not null
GPA
Decimal (3,2)
Not null
First Name
Nvarchar (30)
Not null
Last Name
Nvarchar (30)
Not null
Name
Data Type
Constraint
Address
Nvarchar (100)
Not Null
InstructorID
Int
Primary Key
Phone Number
Nvarchar(10)
Not null
Office
Int
Not null
Office Hours
Nvarchar (30)
Not null
Department
Nvarchar (15)
Not null
Department ID
Int
Not null
First Name
Nvarchar (30)
Not null
Last Name
Nvarchar (30)
Not null
Explanation / Answer
Table:Instructor:
1- INSERT INTO Instructor (Address, Instructor Id, Phone No, Office,Office Hours, Department, Department Id, First Name, Last Name )
VALUES ('Torikatu 38','12', '8893648480','Chetu','6','Engineer','25', 'Rahul' , 'Bansal');
2- INSERT INTO Instructor (Address, Instructor Id, Phone No, Office,Office Hours, Department, Department Id, First Name, Last Name )
VALUES ('Delhi','13', '8293648480','','6','Engineer','25', 'Rahul' , 'Bansal');
3- INSERT INTO Instructor (Address, Instructor Id, Phone No, Office,Office Hours, Department, Department Id, First Name, Last Name )
VALUES ('Punjab','13', '8893633480','Chetu','6','Engineer','25', 'Rahul' , 'Bansal');
4- INSERT INTO Instructor (Address, Instructor Id, Phone No, Office,Office Hours, Department, Department Id, First Name, Last Name )
VALUES ('Puna','16', '8893648380','Chetu','6','Engineer','25', 'Rahul' , 'Bansal');
5- INSERT INTO Instructor (Address, Instructor Id, Phone No, Office,Office Hours, Department, Department Id, First Name, Last Name )
VALUES ('Goa','15', '8893643480','Galaxy','8','Developer','23', 'Rohit' , 'Bansal');
6- INSERT INTO Instructor (Address, Instructor Id, Phone No, Office,Office Hours, Department, Department Id, First Name, Last Name )
VALUES ('Gzbd','16', '8893648481','Mahindra','7','Engineer','15', 'Raj' , 'Bansal');
7- INSERT INTO Instructor (Address, Instructor Id, Phone No, Office,Office Hours, Department, Department Id, First Name, Last Name )
VALUES ('Mantra','17', '8893645480','Kotack','7','Manager','5', 'Divya' , 'Singh');
8- INSERT INTO Instructor (Address, Instructor Id, Phone No, Office,Office Hours, Department, Department Id, First Name, Last Name )
VALUES ('Chandausi','18', '8993648480','Moto','5','Senior Manager','11', 'hIna' , 'vanrshney');
9-INSERT INTO Instructor (Address, Instructor Id, Phone No, Office,Office Hours, Department, Department Id, First Name, Last Name )
VALUES ('Muradabad ','19', '8894648480','Mahindra','7','Software','12', 'Rahu' , 'Gupta');
10- INSERT INTO Instructor (Address, Instructor Id, Phone No, Office,Office Hours, Department, Department Id, First Name, Last Name )
VALUES ('Kota','20', '9808976455','Kotak','7','sr Engineer','13', 'Ruchi' , 'singh');
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.