Question

Observe the given table BOOK and write down the outputs of the following relational expressions:

Book_code	Book_Title	Publisher	Price
C105	Computer Fundamentals	BPB	198
C108	C++ Programming	BPB	170
C105	Physics	NCERT	215
C112	Physics	SCERT	200
C112	Mystery of Chemistry	Tata MacGraw Hill	189

Answer 1

1. This query returns all the tuples(rows) that contain BPB in column Publisher.

Book_code	Book_Title	Publisher	Price
C105	Computer Fundamentals	BPB	198
C108	C++ Programming	BPB	170

2. This query returns the column Book_Title with price<200. 

Book Title 

• Computer Fundamentals 
• C++ Programming 
• Mystery of Chemistry