(a) Based on the table given above provide the relevant relational algebra operations that is been described in the following statements: 

i. List all employees in the library whose salaries are greater than 2000.00. 

ii. Produce a list of students, showing only the student id, name, and contact number.

iii. List the book title and publisher that students had borrowed (No title should be repeated).

(b) Using the Book, Student, Staff, and Borrow tables above, derive the output of the following relation algebra operation:

 i. Publisher = Oxford AND pubYear >=2005 (BOOK)

 ii. "title, author, publisher (Book) 

Result1 

 

Transcribed Image Text:

The following tables show a portion of the database of a library referring to the relations, Book, Staff, Students and Borrow shown: Book tstle author publisher pubYear 1abnNo 00001 An Introduction to A.K. Allen McGrawHill 2001 74895841 Database Systems 0000s Introduction to Relational Database 00025 Programming with N.B. Grag Visual Basic R. Torlone Addison Wesley 2003 58663571 Prentice 1999 851447356 Hall 00107 Mathematics for Engineering 03567 Fundamental of Programming 00267 Engineering Mathematics 00251 Engineering Mathematics Addison Wesley T. Date 2000 956482550 W.L Loure Prentice 2004 1551648 Hall W.C. Evans Oxford 2005 4478568 D. Woods Prentice Hall 2003 79212655 tate 00 15anos SE Student 14 Atees state coetact e all a Ases a S100no Chan Wai S6A Jalan 214 Kuala 012-3256780F waisse yahoo.com Penang o16-652856F nicholetang gmail.com Oe Loong Cheng Dua Taman Midah Lumpur Stocao Nichole 2314 Tan Jalan Mewah Taman Merdeka 284 Aalan KLS Melaka Kampung Lapan Loe 3 Lebuh Timur Kotamas 21, BockC Siow Ting alan P78/ Sapura Height a 12 SI0121 Mohd Aman S1a2se vy Maaaaze hotmal.com Penang 017-2548e9s Mhellovaye gmail.com Penang ons-2574165F sfonge yahoo.com Penang 2000 20unes Seotany S4 Fong To od ASso N Sa umpu Lacturer Borrow studentID bookID Taman Tang ASong Bod ing Aan ang P 10010 00025 os ssc actue 11094 00107 Melaka s Mays 11094 00005 Kam pung 10121 00107 AP 10020 00001 Labuh 10020 00005 The following tables show a portion of the database of a library referring to the relations, Book, Staff, Students and Borrow shown: Book tstle author publisher pubYear 1abnNo 00001 An Introduction to A.K. Allen McGrawHill 2001 74895841 Database Systems 0000s Introduction to Relational Database 00025 Programming with N.B. Grag Visual Basic R. Torlone Addison Wesley 2003 58663571 Prentice 1999 851447356 Hall 00107 Mathematics for Engineering 03567 Fundamental of Programming 00267 Engineering Mathematics 00251 Engineering Mathematics Addison Wesley T. Date 2000 956482550 W.L Loure Prentice 2004 1551648 Hall W.C. Evans Oxford 2005 4478568 D. Woods Prentice Hall 2003 79212655 tate 00 15anos SE Student 14 Atees state coetact e all a Ases a S100no Chan Wai S6A Jalan 214 Kuala 012-3256780F waisse yahoo.com Penang o16-652856F nicholetang gmail.com Oe Loong Cheng Dua Taman Midah Lumpur Stocao Nichole 2314 Tan Jalan Mewah Taman Merdeka 284 Aalan KLS Melaka Kampung Lapan Loe 3 Lebuh Timur Kotamas 21, BockC Siow Ting alan P78/ Sapura Height a 12 SI0121 Mohd Aman S1a2se vy Maaaaze hotmal.com Penang 017-2548e9s Mhellovaye gmail.com Penang ons-2574165F sfonge yahoo.com Penang 2000 20unes Seotany S4 Fong To od ASso N Sa umpu Lacturer Borrow studentID bookID Taman Tang ASong Bod ing Aan ang P 10010 00025 os ssc actue 11094 00107 Melaka s Mays 11094 00005 Kam pung 10121 00107 AP 10020 00001 Labuh 10020 00005

Answer rating: 100% (QA)

a i salary200000 Staff Explanation This selection operation will return rows of the input relation i... View the full answer