Answered step by step
Verified Expert Solution
Link Copied!

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 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning ASP.NET 2.0 And Databases

Authors: John Kauffman, Bradley Millington

1st Edition

0471781347, 978-0471781349

More Books

Students also viewed these Databases questions