Question

1. Devika wants to create a Library Database
a)Identify 6 fields that you would include in the Table
b)Write their data types
c)Which field will you make as the Primary key and why?

Answer 1

Answer:

6 field for library are something like as:

membership id [ integers] [primary key] [not null]

name [Varchar / String]

ph no [ Double]

book rerurn status [integer]

grade(if it is school or college library) [integer]

borrow status [integer]

optional fields:

Fine [Float]

Explanation:

I give answer is based on Mysql,Mariadb,Hive..