We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
Use the following tables to solve this assignment.
Table 1: INSTRUCTOR TABLE
Table 2: STUDENT TABLE
You are required to write a SQL query to display the following output table:
Our Expectations: Hopefully, you all would be fine. Here in this practice assignment. You all are required to create two tables (Instructor, Student) using SQL CREATE TABLE statement in SQL Server. Example CREATE TABLE practice queries have also been uploaded in “Downloads” section under VULMS.
We need screenshots of all your work, which will be pasted in your solution file (DOC File).
Marks Distribution will be as under:
CREATE TABLE Commands = 5 (2.5 for each table) marks
INSERT INTO Table Commands = 5 (2.5 for each table) marks // For time saving you can only insert three records in each table.
SELECT Query = 10 marks
+ Click Here To Join also Our facebook study Group...How to Join Subject Study Groups & Get Helping Material?..
.+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)
+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)+ Click Here to Search (Looking For something at vustudents.ning.com?)
thnx bhai :)..men kar rahi ,Allah karay ab hojae :)
actually mostly every student is selecting wrong data type
Hint: hire_date datetime will not because data is in charaters and number '15-JAN-2011' 11 character required so use your brain
can anyone tell me the link for downloading the sql software for win7 64bit window...
brother if you are using 64 bit OS then you need to first install dotnet framework 4.0 and after rebooting your pc install sql server express
Dot net framework download link : http://www.microsoft.com/download/en/details.aspx?id=17718
Microsoft SQL server 2005 download torrent link : http://www.mediafire.com/?40r127pazr9agvp (its a torrent link so you need torrent client and good net speed)