Question

Q-2) Create a table for the information given below by choosing appropriate data types. Specify proper primary key for the table.


1) Table Name – Library.


A) Library (Book_ID, Book _issue_date, Book _ name, Author _ name).​

Answer 1

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

The number of tables to include in your database, as well as the table names

For each table, the number of columns it should contain, as well as the column names

For each column, what kind of data is to be stored