1.

Observe the given table BOOK and write down the outputs of the following relational expressions :Book_codeBook_TitlePublisherPriceC105Computer Fundamentals BPB198C108C++ ProgrammingBPB170P105PhysicsNCERT215P112PhysicsSCERT200C112Mystery of chemistryTata MacGraw Hill189

Answer»

a. This query returns all the tuples (rows) that contain BPB in column publisher.

Book_codeBook_TitlePublisherPrice
C105Computer FundamentalsBPB198
C108C++ programmingBPB170

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

Book Title

Computer Fundamentals C++ Programming Mystery of Chemistry.



Discussion

No Comment Found