Scribd
Upload
18 views2 pages

Practice Question On SQL Server

The document outlines an assignment to create a database named 'university' with a 'student' table containing various attributes. It includes instructions for altering the table structure, such as adding and dropping columns, as well as creating a 'teacher' table with similar operations. The assignment emphasizes the importance of submitting the work before the next lab class.

Uploaded by

Usman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
18 views2 pages

Practice Question On SQL Server

The document outlines an assignment to create a database named 'university' with a 'student' table containing various attributes. It includes instructions for altering the table structure, such as adding and dropping columns, as well as creating a 'teacher' table with similar operations. The assignment emphasizes the importance of submitting the work before the next lab class.

Uploaded by

Usman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Database:

Assignment 1:

1. Create a new database university.


2. Create a table student.
Std_id Std_Fname Std_Lname Std_batch Std_address
001 Ahmad sagheer 16160819 gujrat
002 Wajih ahamd 16170819 lahore
003 Shoaib ikram 17172150 gujrat
004 waleed ijaz 17172250 wazirabad

3. Create new column std_gpa and set datatype


int.
4. Alter the type of std_gpa float.
5. Drop the column std_Lname.
6. Display all data.
7. Create table teacher
Tchr_id Tchr_name Tchr_adress Tchr_salary

222 abdullah gujrat 30000.5

333 umer lahore 35000

444 anees gujrat 40000

8. Add new column tchr_course and set


datatype.
9. Insert new values.
10. Change the size of tchr_adress.
11. Show the table.

Note: submit your assignment before next lab class.

You might also like