Requirements in System

Data Tables:

Table : Members

S.no.	ColoumName	DataType	Length	Description
1	Id_no	Text	50	Unique identificationof the members
2	Name	Text	70	Name of members
3	Address	Text	100	Location of Members
4	Date ofIssue	Date/Time		Date of Registration
5	Date ofExpiry	Date/Time		Registration expirydate
6	Status	Text	50	Permanent/Temporary

Table : Add Books

S.no.	ColumnName	Date-Type	Description
1	Book_name	Text	Title of the book
2	Book_code	Text	Book identification number
3	Author	Text	Author of books
4	Date ofarrival	Date/time	Date on which book wasreceived
5	Price	Text	Cost of books
6	Rack_no	Text	Rack number
7	No_of_books	Text	Quantity of books
8	Subject_code	Text	Unique identification no ofparticular subject

Table: issue

S.no.	ColumnType	DateType	Description
1	Id_no	Text	User identification number
2	Book_name	Text	Title of books
3	Issue_date	Date/time	Date on which book isissued
4	Due_date	Date/time	Due date on which book isto be returned