No. of Printed Pages: 1 IBCSL-OS4(P)/SSI
BACHELOR OF COMPUTER APPLICATIONS (Revised)

Term-End Practical Examination
December, 2016


BCSL-034(P)/S3 DATABASE MANAGEMENT SYSTEMS LAB
Time: 1 Hour Maximum Marks: 50
Note: There are two questions in this paper carrying 20 marks each.
Answer them both.
Rest 10 marks are for viva-voce.


1. Create the following table with the fields given below:

ORDER ISBN, NO_OF_COPIES, DATE_OF_ORDER, RATE_OF_EACH_COPY, AUTHOR, PUBLISHER, YEAR)

Select ISBN as primary key. ORD_NO should be generated sequentially. Select appropriate datatypes for all the fields. Insert at least 20 meaningful records.

2. For the above table created in Q.l, answer the following queries using SQL: 5x4=20

To print all the ORD_Nos whose No_of_copies are equal to) 200.

To print the DATE_OF_ORDER for the book with ISBN "1112311".

To display all the details of books_order whose publisher name is "TMGH".

To display all the ORD_NOs whose year of publication of books is 2003.

To display ORD_NO, RATE_OF_EACH_COPY for the book written by the Author =TIM and published by "McGraw Hill".