Library Management System

Lib_User

Field Name	   Type	          Length(bytes)	           Constraint 
User_ID	           int	          4	                    Primary Key
User_Name	   varchar	  120	                    Not Null	 
User_Password	   varchar	  120	                    Not Null	   
User_Is_System	   bit	          1	                    Not Null	  
User_Created_Date  datetime	  8	                    Not Null	
Number_Of_Books_Issued	int	  4	                    Not Null


Lib_Book_Categories

Field Name	  Type	        Length(bytes)	     Constraint	 	
Category_ID	  int	          4	               Primary Key	
Category_Name	  varchar	  120	               Not Null	


Lib_Book_Details

Field Name	       Type	    Length(bytes)	     Constraint	 
Lib_Book_ID	       int	     4	                     Primary Key	
Lib_Book_Title	       varchar	     120	             Not Null	
Lib_Book_Category      int	     4	                     Not Null	
Lib_Book_Author_Name	varchar	     120	             Not Null	
Lib_Book_Publisher_Name	varchar	     120	             Not Null	
Lib_Book_PublisAt_Name	varchar	     120	             Not Null	
Lib_Book_YearPubish	int	     4	                     Not Null	
Lib_Book_Edition	int	     4	                     Not Null	
Lib_Book_Volume	        int	     4	                     Not Null	
Lib_Book_Page	        int	     4	                     Not Null	
Lib_Book_Price	        float        8	                     Not Null	
Lib_Book_Issue_Status	bit	     1	                     Not Null	
Lib_Book_In_Inventory	bit	     1	                     Not Null	

Lib_Book_Issue_Details

Field Name	       Type	    Length(bytes)     Constraint 
Lib_Book_Issue_ID	int	    4	              Primary Key	
Lib_Book_ID	        int	    4	              Not Null	
Lib_Book_Issued_On	datetime    8	              Not Null	
Lib_Book_Issued_To	varchar	    120	              Not Null	
Lib_Book_Returned_On	datetime    8	              Null