Describe each of the final relations (tables) as follows: Book ToLoan loanPeriod BookToSell dateNotForLoan sellingPrice (Mandatory,...

 

Transcribed Image Text:

Describe each of the final relations (tables) as follows: Book ToLoan loanPeriod BookToSell dateNotForLoan sellingPrice (Mandatory, And) Provides Book Copy Book 1. copy No {PK} ISBN (PK) 1.1 status title edition yearPublished Borrower borrowerNo (PK) 1.1 name address Borrows 1* 1.1 Is S- 1 Book Loan loanNo {PK} date Out date Returned TableA (att1, att2, att3,...) Primary Key (att1, att2) Foreign key att7 references TableB(batt1) Alternate Key(s): att4 Describe each of the final relations (tables) as follows: Book ToLoan loanPeriod BookToSell dateNotForLoan sellingPrice (Mandatory, And) Provides Book Copy Book 1. copy No {PK} ISBN (PK) 1.1 status title edition yearPublished Borrower borrowerNo (PK) 1.1 name address Borrows 1* 1.1 Is S- 1 Book Loan loanNo {PK} date Out date Returned TableA (att1, att2, att3,...) Primary Key (att1, att2) Foreign key att7 references TableB(batt1) Alternate Key(s): att4