Question

Consider the following relation. The Primary key is Rollno, Isbn.

Student(RollNo, Name, Branch), Book(Isbn, Title, Author, Publisher) Issue(Rollno, Isbn,

date_of_issue). Write the query in SQL of the following

i) List the Roll Number and Name of All CSE Branch Student.

ii) Find the name of students who have issued a book of publication ‘BPB’.

iii) List the title and author of all books which are issued by a student name started with a.​

Answer 1

Answer:

the answer 2 ur q' is

Explanation:

Għaliex int daqshekk stramba?

Agħmel aħjar fl-eżami li jmiss tiegħek.

Mhux se nkun hemm biex niekol kuċċarina.