Question

Varsha has created a table named 'Book' for an online library database. She has created fields as Book ID, Name of the Book, Date of Publication and Number of Books Available. Suggest her the correct data types to be used for these fields.

Answer 1

Answer:

Column                                                                      Datatype

Book ID                                                                     varchar (20)

Name of the Book                                                     varchar (20)

Date of Publication                                                    Date

Number of Books Available                                      int

Explanation:

• Book ID can be in Int and characters or both so varchar is a better option.

• Name of the Book  varchar since it'll be most probably in text.

• Date of Publication is date.

• Number of Books Available is a number.