Question: b . tblReturns Field Name Data Type Description ReturnID AutoNumber A unique ID for a returned book field size long integer indexed yes ( no

b. tblReturns Field Name Data Type Description ReturnID AutoNumber A unique ID for a returned book field size long integer indexed yes(no duplicates) BorrowID Number A unique ID for a borrower Field size long integer reuired no indexed no BookID Number Unique ID for the book field size long integer required no indexed yes(Duplicates ok) returndate date/time return date for the book borrowed format short date required no indexed no Actreturndae date/time date the book was actually returned on format short date required no indexed no lateday number number of days that the book is submitted late field size long integer required no indexed yes (duplicated ok) fine currency fine levied for late book submission required no indexed no import and append data from ABL_return.txt in the tblreturns table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!