Question

1. Write the steps to 1. set the Book id as primary key 2. set the STUDENT NAME
FIELD to NOT NULL 3. to set the lending date not less than today's date.
TO
Books Information
SCHOOL LIBRARY DATABASE
Field Name
BOOK-ID
STUDENTS NAME
CLASS
DIVISION
ROLL NUMBER
LENDING DATE
DUE DATE
Data Type
Short Text
Short Text
Short Text
Short Text
Number
Date/Time
Date Time
​

Answer 1

Answer:

Write the steps to 1. set the Book id as primary key 2. set the STUDENT NAME

FIELD to NOT NULL 3. to set the lending date not less than today's date.

TO

Books Information

SCHOOL LIBRARY DATABASE

Field Name

BOOK-ID

STUDENTS NAME

CLASS

DIVISION

ROLL NUMBER

LENDING DATE

DUE DATE

Data Type

Short Text

Short Text

Short Text

Short Text

Number

Date/Time

Date Time