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

Question I: (CLO-2)
Consider the Student tubic having the following records.
\table[[SID,Name,Age,Address],[12,Usman,21,Clifton],[34,Sattar,23,Shah Faisal],[56,Bubar,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 (Name miqdad and SID 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, Afler sone time, this student Usman has decided to leave the university. How the table looks like now?
 Question I: (CLO-2) Consider the Student tubic 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!