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

Explanation:

In order to be able to add and manipulate data, you first have to create a database. There’s not much to this. You’re creating just a container in which you will add tables. Creating a table is more involved and offers many choices. There are several types of tables from which to choose, some with unique features. When creating tables, you must also decide on the structure of each table: the number of columns, the type of data each column may hold, how the tables will be indexed, and several other factors. However, while you’re still learning, you can accept the default setting for most of the options when creating tables.

There are a few basic things to decide when creating a structure for your data