Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 yesno 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 yesDuplicates ok returndate datetime return date for the book borrowed format short date required no indexed no Actreturndae datetime 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 ABLreturn.txt in the tblreturns table
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started