Question: Question 1 : ( CLO - 2 ) Consider the Student tuble having the following records. table [ [ SID , Name,Age,Address ] ,

Question 1: (CLO-2)
Consider the Student tuble having the following records.
\table[[SID,Name,Age,Address],[12,Usman,21,Clifton],[34,Sattar,23,Shah Faisal],[56,Babar,22,Malir],[78,Jawwad,20,Korangi],[93,Abdullah,24,Defense],[10,Ahad,21,Gulshan]]
Part 1- You have to fetch all SIDs and Names from this table. What will be the resulting table?
Part 2- Now a new student (consider My name miqdad and 15974) has been added in the class. What will the resulting table now? You can consider your age and address in remaining fields.
Part 3- The residence of Student Usman was on rent and now he is moving to the new location Nazimabad. What will be the resulting table now?
Part 4. After some lime, this student Usman has decided to leave the university. How the table looks like now?
In html
 Question 1: (CLO-2) Consider the Student tuble having the following records.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!