Consider the following tables Library given below:
Library
Bid |
Name |
Author |
Price |
Mem_name |
Issue_Date |
Status |
B01 |
Wings of Fire |
A.P.J Abdul Kalam |
550 |
Sarita |
2018-05-20 |
Returned |
B02 |
The Monk who sold his Ferrari |
Robin Sharma |
340 |
Simmi |
2018-03-15 |
Not Returned |
B03 |
You can win |
Shiv Khera |
230 |
Rajat |
2018-04-16 |
Returned |
B04 |
Who moved my cheese |
Spencer Jhonson |
450 |
Ram |
2018-03-17 |
Not Returned |
B05 |
Real Success |
Patrick Mather-Pike |
250 |
Sia |
2018-06-18 |
Not Returned |
(i) Suggest the suitable data type for Issue_Date column.
(ii) Suggest the suitable SQL command to change the size of column name from 30 character to 50 characters.
(iii) Mention the significance of Bid column in table Library.
(iv) Suggest the suitable command to display a list of the books in a sequence so that first all the book’s name should be displayed which has been returned and after that all the book’s name which has not been returned should be displayed.